Recent questions tagged oracle

0 votes

935 views

1 answer

oracle - Check String of characters is a valid date or not

I have a table with field sourcefilename which has 5 records. Following are the records. SN. SOURCEFILENAME ... FALSE' END FROM ai_4451_1_metl; See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - no ocijdbc9 in java.library.path

When I try to run Java application, I receive the following error: Exception in thread "main" java.lang. ... the wrong version is specified? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - local collection types not allowed in SQL statements

I have a question regarding using of collections in Oracle SQL functions. There are definitions of types in ... RETURN table_2; END function_2; See Question&Answers more detail:os...

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

0 votes

877 views

1 answer

oracle - How to get number of rows affected by a statement when inside that statement's trigger

I have a statement level trigger that fires whenever INSERT UPDATE or DELETE operations are performed on a table ... , any help appreciated! 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 column name same as PL/SQL variable name - How can this be done in a select statement?

Suppose I have a table: create table foo ( col_1 number; col_2 number; ); Then I have the following code ... need to change the variable names? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

oracle - execute immediate alter sequence not working

I'm stuck on this pretty simple script. It isn't working like I expect it to. declare st VARCHAR(1024); begin ... I want. What am I missing? See Question&Answers more detail:os...

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

0 votes

868 views

1 answer

oracle - Are PL/SQL variables in cursors effectively the same as bind parameters?

I've heard that using bind variables is (can be) more efficient, because for subsequent calls with a different bind ... null; end loop; end; See Question&Answers more detail:os...

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

0 votes

975 views

1 answer

oracle - Does PL/SQL have an equivalent StringTokenizer to Java's?

I use java.util.StringTokenizer for simple parsing of delimited strings in java. I have a need for ... implementation? Some useful alternative? 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 results into one string

I'm trying to create a simple stored procedure that stores queried result into one string. v_string1 varchar2(100) ... way to handle this? 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 return an array from Java to PL/SQL?

I have no problems to pass numbers and strings back and forth from PL/SQL to Java, but how do I pass arrays ? I' ... (i)); end loop; 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 - PL/SQL maximum size of VARRAY

I'm trying to figure out the possible upper bound of VARRAY in PL/SQL. We sure can define VARRAY type as TYPE ... integer (4,294,967,295)? See Question&Answers more detail:os...

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

0 votes

968 views

1 answer

oracle - Function or Procedure for an IN clause

I want to write a funcion or procedure that can be used in the IN clause of another procedure. The function ... there be a performance penalty? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

oracle - Is it possible to run a SQLPLUS script on a file encoded as UTF-8 with BOM

I'm trying to run a collection of scripts which have been auto-generated from a large number of sources. ... file which has a BOM? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle varchar to number

How do i convert a oracle varchar value to number eg table - exception exception_value 555 where exception_value is ... exception_value = '105' 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 call one stored proc from anther and modify refcursor that is returned?

I have two stored procs, p_proc1 and p_proc2. p_proc1 returns a refcursor and I want to use the data in p_proc2 ... )? The database is Oracle. See Question&Answers more detail:os...

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

0 votes

975 views

1 answer

oracle - Why can't we use strong ref cursor with dynamic SQL Statement?

I am trying to use a strong ref cur with dynamic sql statment but it is giving out an error,but when ... emp_ref_cur%NOTFOUND; END lOOP; END; See Question&Answers more detail:os...

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

0 votes

837 views

1 answer

oracle - No Dialect mapping for JDBC type: -9

I'm having a trouble with a native SQL query... When this code : SimpleDateFormat = new SimpleDateFormat("yyyy- ... guess ? Thanks by advance. See Question&Answers more detail:os...

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

0 votes

951 views

1 answer

oracle - sqlplus error on select from external table: ORA-29913: error in executing ODCIEXTTABLEOPEN callout

I have setup a simple Oracle external table test that I (alongside a DBA and Unix admin) can't get to work. ... would be OK for permissions... See Question&Answers more detail:os...

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

0 votes

928 views

1 answer

oracle - FOR r in (SELECT ... INTO ...)

Today, I came across a funny piece of code that I think should not compile. It uses an SELECT ... INTO ... . Are my two assumptions right? See Question&Answers more detail:os...

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

0 votes

938 views

1 answer

oracle - SQL join subquery

I tried searching for an answer to my problem but failed to get an answer that actually helped. I've written an ... . Thank you very much- Ruth See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - SQLPlus - spooling to multiple files from PL/SQL blocks

I have a query that returns a lot of data into a CSV file. So much, in fact, that Excel can't open it ... WHILE the data is being returned... See Question&Answers more detail:os...

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

0 votes

975 views

1 answer

oracle - Time zone conversion in SQL query

I am using a query to get some application Received Date from Oracle DB which is stored as GMT. Now I have to ... do this. Please help me out See Question&Answers more detail:os...

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

0 votes

44.0k views

1 answer

oracle - SQL not recognizing column alias in where clause

I am only a beginner in SQL, but I've come across this annoying error. SQL is having an issue with ... results in descending order by item_total See Question&Answers more detail:os...

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

0 votes

928 views

1 answer

oracle - Using PL/SQL how do you I get a file's contents in to a blob?

I have a file. I want to get its contents into a blob column in my oracle database or into a blob variable in ... is the best way to do that? See Question&Answers more detail:os...

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

0 votes

927 views

1 answer

oracle faster paging query

I have two paging query that I consider to use. First one is SELECT * FROM ( SELECT rownum rnum, a.* from ... which query is the faster one? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - pl/sql - Using a dynamic query inside a stored procedure

I am using a stored procedure to insert data into a temp table using a cursor. This procedure stores a dynamic ... Thank you very much! (: See Question&Answers more detail:os...

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

0 votes

764 views

1 answer

oracle - How to best manage historical lookup values in a database?

Overview An incident database that will have a number of columns holding an ID for a record held in a ... with changing business requirements. See Question&Answers more detail:os...

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

0 votes

896 views

1 answer

oracle - Why can't we use strong ref cursor with dynamic SQL Statement?

I am trying to use a strong ref cur with dynamic sql statment but it is giving out an error,but when ... emp_ref_cur%NOTFOUND; END lOOP; END; See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags