Recent questions tagged oracle

0 votes

448 views

1 answer

oracle - Difference between VARCHAR2(10 CHAR) and NVARCHAR2(10)

I've installed Oracle Database 10g Express Edition (Universal) with the default settings: SELECT * FROM NLS_DATABASE_PARAMETERS; NLS_CHARACTERSET AL32UTF8 ... VARCHAR2(10 CHAR) NVARCHAR2(10) See Question&Answers more detail:os...

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

0 votes

440 views

1 answer

oracle - Why doesn't PL/SQL respect privileges granted by Roles?

When executing a PL/SQL block, any privileges granted to roles are ignored. Instead you must give specific users specific grants to run it. If I want to give DBAs ... isn't "that's just the way it is". See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - Error while trying to retrieve text for error ORA-01804

I am having an issue to connect my C++ application to my Oracle DB,I get an error "[OracleException] errcode: 1804, desc: Error while trying to retrieve text for error ORA-01804". See Question&Answers more detail:os...

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

0 votes

532 views

1 answer

oracle - How to handle to_date exceptions in a SELECT statment to ignore those rows?

I have the following query that I am attempting to use as a COMMAND in a crystal report that I am working on. SELECT * FROM myTable WHERE ... exception. Any help would be greatly appreciated. Thanks!! See Question&Answers more detail:os...

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

0 votes

438 views

1 answer

oracle - Generate a range of dates using SQL

I have a SQL query that takes a date parameter (if I were to throw it into a function) and I need to run it on every day of the last year. How to ... since I could always: SELECT SYSDATE - val FROM (...); See Question&Answers more detail:os...

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

0 votes

362 views

1 answer

oracle - SQL multiple columns in IN clause

If we need to query a table based on some set of values for a given column, we can simply use the IN clause. But if query need to be ... what is the preferred of solving this problem in general? See Question&Answers more detail:os...

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

0 votes

968 views

1 answer

oracle - Convert comma separated string to array in PL/SQL

How do I convert a comma separated string to a array? I have the input '1,2,3' , and I need to convert it into an array. See Question&Answers more detail:os...

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

0 votes

256 views

1 answer

oracle - How to increase performance for bulk INSERTs to ODBC linked tables in Access?

I have CSV and TXT files to import. I am importing the files into Access and then inserting the records into a linked Oracle table. Each file has around 3 ... very slow. How can I speed up the process? See Question&Answers more detail:os...

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

0 votes

404 views

1 answer

oracle - SQL to generate a list of numbers from 1 to 100

Using the DUAL table, how can I get a list of numbers from 1 to 100? See Question&Answers more detail:os...

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

0 votes

352 views

1 answer

oracle - Can We use threading in PL/SQL?

Is there any feature of asynchronous calling in PL/SQL? Suppose I am in a block of code would like to call a procedure multiple times and wouldn't ... myProc(1,100) to finish processing before executing(101,200) Thanks. Question&Answers:os...

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

0 votes

349 views

1 answer

oracle - What is the effect of placing the commit after DML in procedure?

I have created a procedure in a package which is doing insert/delete in the table and after successful transaction, commit is done. like this: create or ... What is the effect of placing the commit like this in program? Question&Answers:os...

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

0 votes

500 views

1 answer

oracle - Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?

I am trying to execute an SQL command within dynamic SQL with bind variables: -- this procedure is a part of PL/SQL package Test_Pkg PROCEDURE ... I use bind variables in DDL/SCL statements in dynamic SQL? Question&Answers:os...

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

0 votes

667 views

1 answer

oracle - ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

Why am I getting this database error when I update a table? ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired Question&Answers:os...

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

0 votes

657 views

1 answer

oracle - if (select count(column) from table) > 0 then

I need to check a condition. i.e: if (condition)> 0 then update table else do not update end if Do I need to store the result into a variable ... from table end if valuecount > o then update table else do not update Question&Answers:os...

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

0 votes

341 views

1 answer

oracle - UTL_FILE.FOPEN() procedure not accepting path for directory?

I am trying to write in a file stored in c: drive named vin1.txt and getting this error .Please suggest! > ERROR at line 1: ORA-29280: invalid ... ); end sal_status; execute sal_status('C:','vin1.txt');--Executing Question&Answers:os...

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

0 votes

534 views

1 answer

oracle - "Safe" TO_NUMBER()

SELECT TO_NUMBER('*') FROM DUAL This obviously gives me an exception: ORA-01722: invalid number Is there a way to "skip" it and get 0 or NULL ... this issue with COALESCE(TO_NUMBER(REGEXP_SUBSTR(field, '^d+')), 0) Question&Answers:os...

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

0 votes

425 views

1 answer

oracle - TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

I'm trying to connect to Oracle 10.2.0 from NetBeans, using the following connection string: jdbc:oracle:thin:@localhost:1521:XE The weirdest part is ... SQL*Plus connects fine. Is there some workaround for this error? Question&Answers:os...

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

0 votes

527 views

1 answer

oracle - ORA-28040: No matching authentication protocol exception

I am trying to connect my grails project to Oracle databse(Oracle 12c) in windows(8) system. However, whenever I run my application I get following exception ... of them is working. Can anyone please help me with this ? Question&Answers:os...

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

0 votes

558 views

1 answer

oracle - PL/SQL - Use "List" Variable in Where In Clause

In PL/SQL, how do I declare variable MyListOfValues that contains multiple values (MyValue1, MyValue2, etc.) SELECT * FROM DatabaseTable WHERE DatabaseTable.Field in MyListOfValues I am using Oracle SQL Developer Question&Answers:os...

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

0 votes

539 views

1 answer

oracle - ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in ... were made to this environment. Anything else we can test? Question&Answers:os...

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

0 votes

451 views

1 answer

oracle - No more data to read from socket error

We are using Oracle as the database for our Web application. The application runs well most of the time, but we get this "No more data to read from socket" error. ... Thu Oct 20 10:34:21 2011 Oracle Version : 11.2.0.1.0 Question&Answers:os...

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

0 votes

752 views

1 answer

oracle - ORA-01882: timezone region not found

I'm accessing an Oracle Database from a java application, when I run my application I get the following error: java.sql.SQLException: ORA-00604: error ... at recursive SQL level 1 ORA-01882: timezone region not found Question&Answers:os...

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

0 votes

496 views

1 answer

oracle - Printing the value of a variable in SQL Developer

I wanted to print the value of a particular variable which is inside an anonymous block. I am using Oracle SQL Developer. I tried using dbms_output. ... And I am getting the output only as anonymous block completed. Question&Answers:os...

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

0 votes

450 views

1 answer

oracle - Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?

I've got a problem with JDBC. I'have the following code: //blargeparam is a blob column. PreparedStatement pst =connection.prepareStatement("update ... Oracle Corporation Implementation-Time: Sat Feb 2 11:40:29 2008 Question&Answers:os...

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

0 votes

476 views

1 answer

oracle - Is it possible to output a SELECT statement from a PL/SQL block?

How can I get a PL/SQL block to output the results of a SELECT statement the same way as if I had done a plain SELECT? For example how to do a ... foobar; Hint : BEGIN SELECT foo, bar FROM foobar; END; doesn't work. Question&Answers:os...

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

0 votes

642 views

1 answer

oracle - PL/SQL, how to escape single quote in a string?

In the Oracle PL/SQL, how to escape single quote in a string ? I tried this way, it doesn't work. declare stmt varchar2(2000); begin ... loop; exception when others then rollback; dbms_output.put_line(sqlerrm); end; / Question&Answers:os...

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

0 votes

543 views

1 answer

oracle - Escaping ampersand character in SQL string

I am trying to query a certain row by name in my sql database and it has an ampersand. I tried to set an escape character and then escape the ... same solution, but that does not mean that the questions are the same. Question&Answers:os...

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

0 votes

438 views

1 answer

oracle - GROUP BY / aggregate function confusion in SQL

I need a bit of help straightening out something, I know it's a very easy easy question but it's something that is slightly confusing me in SQL. ... ' attributes, where simply using 'SELECT order_no' will throw an error? Question&Answers:os...

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

Categories

Just Browsing Browsing

Most popular tags