Recent questions tagged Oracle

0 votes

1.6k 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 ... CHAR) NVARCHAR2(10) See Question&Answers more detail:os...

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

0 votes

1.6k 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 ... the way it is". See Question&Answers more detail:os...

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

0 votes

2.5k 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: ... text for error ORA-01804". See Question&Answers more detail:os...

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

0 votes

1.8k 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 ... be greatly appreciated. Thanks!! See Question&Answers more detail:os...

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

0 votes

1.6k 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 ... SELECT SYSDATE - val FROM (...); See Question&Answers more detail:os...

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

0 votes

1.5k 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 ... of solving this problem in general? See Question&Answers more detail:os...

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

0 votes

2.1k 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

1.4k 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 ... can I speed up the process? See Question&Answers more detail:os...

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

0 votes

1.7k 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

1.4k 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 ... to finish processing before executing(101,200) Thanks. Question&Answers:os...

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

0 votes

1.5k 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 ... placing the commit like this in program? Question&Answers:os...

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

0 votes

1.7k 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 ... variables in DDL/SCL statements in dynamic SQL? Question&Answers:os...

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

0 votes

2.0k 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

1.8k 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 ... 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

1.7k 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! > ... execute sal_status('C:','vin1.txt');--Executing Question&Answers:os...

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

0 votes

1.7k 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 ... TO_NUMBER(REGEXP_SUBSTR(field, '^d+')), 0) Question&Answers:os...

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

0 votes

1.5k 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 ... fine. Is there some workaround for this error? Question&Answers:os...

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

0 votes

1.7k 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 ... . Can anyone please help me with this ? Question&Answers:os...

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

0 votes

1.9k 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.) ... MyListOfValues I am using Oracle SQL Developer Question&Answers:os...

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

0 votes

1.7k 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 ... environment. Anything else we can test? Question&Answers:os...

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

0 votes

1.7k 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 ... 21 2011 Oracle Version : 11.2.0.1.0 Question&Answers:os...

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

0 votes

1.9k 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: ... level 1 ORA-01882: timezone region not found Question&Answers:os...

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

0 votes

1.7k 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 ... getting the output only as anonymous block completed. Question&Answers:os...

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

0 votes

1.7k 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 ... Implementation-Time: Sat Feb 2 11:40:29 2008 Question&Answers:os...

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

0 votes

1.7k 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 ... SELECT foo, bar FROM foobar; END; doesn't work. Question&Answers:os...

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

0 votes

2.3k 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 ... others then rollback; dbms_output.put_line(sqlerrm); end; / Question&Answers:os...

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

0 votes

1.8k 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 ... 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

1.6k 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 ... 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