Recent questions tagged oracle

0 votes

1.2k views

1 answer

oracle - how to pass a table name as parameter to stored procedure?

Is it possible to create a rowtype for a table name which is passed as a parameter to a Stored-Procedure and ... if it is possible . Thanks. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

oracle - How do you pass an argument to a PL/SQL block within a sql file called using START in sqlplus?

I have a bash script running several sql files via sqlplus: sqlplus $connectioninfo << end start file1.sql start file2 ... &1' for all of these. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

oracle - How to resolve ORA-01795 in Java code

I am getting ORA-01795 error in my Java code while executing more than 1000 records in IN clause. I am thinking ... . Can anyone help me here? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

oracle - How to get business days or hours between two dates

How can I calculate business hours or days between two dates in oracle 10g? For example we have two dates; 14/08 ... Sat & Sun with oracle 10g? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.8k views

1 answer

oracle - How to show errors in sqlplus

I would like to know how to show errors in sqlplus. try to compile a view alter view SYS.DBA_XML_SCHEMAS ... errors of the view thank you See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

oracle - how send email by Pl/sql

I want send email by using *oracle 9i - Enterprise edition release 9.2.0.8.0 ,*I know there is one package ... and my form builder is version 6. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

oracle - Formating UUID String without REGEXP_REPLACE and PL/SQL

I'd like to format the result of the sys_guid() function such as proposed in this answer select regexp_replace( ... this is clear illegal */ See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

oracle - SQLplus decode to execute scripts

I am writing a script to be run in sqlplus 11. I have a user defined variable called compression. If ... SQLPlus wouldn't recognise decode? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

912 views

1 answer

oracle - catch DB exception in JSF+EJB application

I'm using Glassfish 3.1 with JSF2 and EJB stateless to query and write an Oracle DB. The table the user ... EJB exception. Is there any way? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.5k views

1 answer

oracle - Error: PLS-00428: an into clause is expected in this select statement

I'm trying to create a function as shown below but getting the error stated in the title. create or replace ... ); end gettaxmin; Any ideas? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

903 views

1 answer

oracle - Sql: difference between two dates

one short question: I am using this code SELECT trunc (SYSDATE) - TO_DATE('04/10/2015','mm/dd/yyyy') ... own holidays). Thanks for help! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

oracle - Plsql to spell number (currency) to Italian currency without hardcoded the translation number

I could not find a post to do it automatically as I don't want to hard coded the mapping between ... : AP_AMOUNT_UTILITIES_PKG in my oracle. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

oracle - to_date function with sysdate

select TO_CHAR(to_date(sysdate, 'DD-MON-YYYY'), 'DAY') FROM DUAL; When I run this query the output was : ... in oracle db. Please help me. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

oracle - SQL, On delete cascade and on update cascade

I am new to SQL and I encountered a weird problem. So I have two tables OFFERS and SUPPLIER. Here is the ... .com if that makes any difference. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

904 views

1 answer

oracle - Can a deadlock occur with the same access method?

Is it possible for a deadlock to occur if two concurrent DML statements modify the same data and use the same ... same plan, causes a deadlock? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

oracle - DDL statements in PL/SQL?

I am trying the code below to create a table in PL/SQL: DECLARE V_NAME VARCHAR2(20); BEGIN EXECUTE IMMEDIATE ' ... PL/SQL Block one after other? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

oracle - PL/SQL "between x and y" does not work, if y < x. Why?

I have a PL/SQL code like: case when column between 201203 and 201201 then other_column end I know that ... is implemented on Oracle Databases? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

oracle - IF NOT EXISTS In Function PLSQL

I have a function which has three If/Then statements before opening a cursor. The If/Then statements check validity ... variable2; end if; end; See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

oracle - Problem with execute procedure in PL/SQL Developer

I this is my first attempt to create procedure and execute it. First I create simple table. DB scheme of table is ... is bad, thank for help. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

oracle - What is wrong with this PL/SQL? Bind Variable * is NOT DECLARED

Here is: declare v_str1 varchar2(80); begin v_str1 := 'test'; print :v_str1; end When I run it ... is NOT DECLARED anonymous block completed See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

oracle - How can I perform a SELECT DISTINCT on all fields except a BLOB?

I'm trying to perform a SELECT DISTINCT query in Oracle, like this: SELECT MOVIES.TITLE, CERTIFICATIONS.ID, PROJECTION. ... BLOB What can I do? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

oracle - display sql custom text from table column result

let say i do select score from table1. this will return result score ---- 0 20 40 how to use case, to ... not agree 20->agree 40->very agreed See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

993 views

1 answer

oracle - SSMA unable to find specified provider

i've installed the full oracle client 12.2.0 and i'm trying to migrate some db from oracle to sql server with ... , but the results is the same See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

851 views

1 answer

oracle - NOT IN selection with NULL values

Who can explain the result of the second select. I expected the first row of data1 (1, '1') is not in ... neither IN data2 nor NOT IN data2? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

oracle - SQL: Parse Comma-delimited string and use as join

How can I parsed a string comma-delimited string from a column in Oracle database and use each one as join to ... = tbl2.ID Thanks in advance. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

oracle - How to execute a procedure with DBMS_SCHEDULER.CREATE_JOB procedure

I want to create a job that would drop a database object at a given date. The job created all right but ... . Thanks in advance gurus. Cheers! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

oracle - SQL - Finding the maximum date group by id table

Having a table below, I need to get rows with the maximum date having statut equal 2 REMUN_ID HISTO_ID DATE_MAJ ... . Any suggestions? Thank you See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

oracle - SQL select for all records that may holds specific value

How to select all records,that may contain specific value that is known, without referring to specific column in SQL ... in table. Thank you. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags