|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
PLS-00497: cannot mix between single row and multi-row (BULK) in oracle 10.2.0.4.0 - 64bi linux |
6 |
40124 |
Mon, 24 April 2017 15:40 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ORA-00054 RESOURCE BUSY AND ACQUIRE WITH NOWAIT |
4 |
2815 |
Mon, 24 April 2017 10:50 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Taking Sum of Similar Tables Oracle 11g By: gobi21 on Sun, 23 April 2017 |
13 |
5693 |
Mon, 24 April 2017 07:45 By: gobi21 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Pivot result using "Pivot" keyword 11.2 |
4 |
2666 |
Fri, 21 April 2017 12:22 By: lott42_gmail ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
LIKE vs NOT LIKE operator Oracle 12c |
4 |
2347 |
Fri, 21 April 2017 08:47 By: srinivas.k2005 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
DEFINE_COLUMN in DBMS_SQL Oracle 11.2.0.3 |
2 |
5804 |
Fri, 21 April 2017 02:09 By: pointers ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Need help to form Query to split count into multiple rows |
5 |
3564 |
Thu, 20 April 2017 14:30 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
merge issue |
11 |
4977 |
Thu, 20 April 2017 03:55 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Regexp magic ! (I hope) 11.2.0.3.0 By: Amine on Fri, 14 April 2017 |
6 |
2898 |
Wed, 19 April 2017 01:47 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
pl/sql procedure using cursors oracle 11g |
3 |
2350 |
Mon, 17 April 2017 16:03 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Help required in SQL Analytic Function lag() Oracle 11gR2 11.2.0.1.0 |
5 |
2913 |
Mon, 17 April 2017 12:31 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Partition tablespace name does not change after moving subpartition oracle12c |
2 |
2569 |
Sat, 15 April 2017 12:59 By: shrinika ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
cursors windows By: jay12 on Tue, 04 April 2017 |
3 |
2141 |
Fri, 14 April 2017 15:49 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
testing rollback 12.1.0.1 By: jinga on Fri, 07 April 2017 |
2 |
2094 |
Tue, 11 April 2017 12:56 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Hierarchical Queries Oracle 11.2.0.3 |
2 |
2532 |
Sat, 08 April 2017 07:42 By: pointers ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
UNION and dependent LOV Oracle R12 |
3 |
3011 |
Sat, 08 April 2017 03:20 By: Littlefoot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Pre Insert logic in Trigger Oracle 11.2.0.3 |
10 |
3198 |
Thu, 06 April 2017 21:09 By: pointers ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Avoid Distinct Oracle 11g |
6 |
3769 |
Thu, 06 April 2017 03:33 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
package By: jay12 on Wed, 05 April 2017 |
3 |
2442 |
Thu, 06 April 2017 03:30 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Split clob data and store in table Oracle 11g |
3 |
2878 |
Tue, 04 April 2017 10:30 By: Roots_ct5 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Need a help with SQL Oracle 12C |
10 |
4288 |
Tue, 04 April 2017 06:59 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
how to send tablespace mail alerts with PL/SQL |
24 |
9353 |
Tue, 04 April 2017 03:56 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How can I convert a SQL command to MySql |
24 |
9343 |
Tue, 04 April 2017 03:28 By: vinodkalpaka ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Need help with SQL Oracle 12c By: jvanh on Fri, 31 March 2017 |
11 |
4377 |
Mon, 03 April 2017 07:05 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Converting comma separated value in different rows Oracle 10g R2 |
5 |
2904 |
Mon, 03 April 2017 01:34 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Can we replace any sub query using join |
3 |
2145 |
Sat, 01 April 2017 02:59 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
oracle-dbms-fga-dynamically-create-an-audit-trail-or-policy (3 threads merged by bb) |
9 |
5348 |
Fri, 31 March 2017 11:45 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Re: ToDate function (split from hijacked thread http://www.orafaq.com/forum/t/56308/ by bb) By: hyder on Thu, 30 March 2017 |
2 |
2172 |
Fri, 31 March 2017 11:41 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
UTL_FILE_DIR Oracle 10gR2/ Solaris 10 By: reym21 on Wed, 29 March 2017 |
13 |
5452 |
Thu, 30 March 2017 07:22 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Avoid UNION ALL Oracle 11.2.0.3 |
5 |
6029 |
Wed, 29 March 2017 08:14 By: pointers ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Grouping for varying weeks Oracle 11.2.0.3 |
7 |
3364 |
Tue, 28 March 2017 04:13 By: pointers ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Inserting data from multiple table into 1 table windows |
8 |
4029 |
Mon, 27 March 2017 00:48 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Receiving Email Messages through Oracle procedure. ( 1 2) |
68 |
63690 |
Sat, 25 March 2017 13:10 By: Littlefoot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query performance SQL By: Jiggu on Thu, 16 March 2017 |
19 |
8576 |
Fri, 24 March 2017 04:40 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
CURSOR taking more time Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit |
11 |
3379 |
Thu, 23 March 2017 14:30 By: mikek ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Orcale: Missing Group By expression working Oracle 12, Windows |
5 |
2588 |
Wed, 22 March 2017 10:56 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
copy table structure |
17 |
7326 |
Wed, 22 March 2017 09:08 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Conditional Join Logic Oracle 11g |
3 |
5203 |
Wed, 22 March 2017 03:35 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
need help in setting constraints for the column based on subquery (2 threads merged by bb) sql,oracle 11g By: sowk on Thu, 16 March 2017 |
13 |
6053 |
Tue, 21 March 2017 06:24 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Append Hint in oracle |
10 |
4263 |
Mon, 20 March 2017 09:44 By: Solomon Yakobson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |