Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

Recent questions tagged oracle

0 votes
307 views
1 answer
    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
287 views
1 answer
    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
652 views
1 answer
    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
411 views
1 answer
    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
258 views
1 answer
    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
245 views
1 answer
    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
561 views
1 answer
    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
174 views
1 answer
    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
241 views
1 answer
    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
188 views
1 answer
    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
226 views
1 answer
    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
337 views
1 answer
    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
495 views
1 answer
    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
377 views
1 answer
    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
207 views
1 answer
    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
345 views
1 answer
    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
285 views
1 answer
    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
337 views
1 answer
    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
382 views
1 answer
    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
339 views
1 answer
    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
282 views
1 answer
    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
536 views
1 answer
    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
334 views
1 answer
    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
278 views
1 answer
    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
313 views
1 answer
    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
441 views
1 answer
    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
356 views
1 answer
    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
242 views
1 answer
    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)
To see more, click for the full list of questions or popular tags.
Ask a question:
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...