Home » SQL & PL/SQL » SQL & PL/SQL
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
icon5.gif Using Virtual Column
Oracle 11g R2, pl/sql
By: kaos.tissue on Fri, 05 May 2017
18 364 Fri, 05 May 2017 05:06
By: kaos.tissue
  Get Return Value from Function without SELECT
By: whdyck on Thu, 04 May 2017
8 358 Fri, 05 May 2017 12:00
By: Michel Cadot
  ORA-14097
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: scottwmackey on Thu, 04 May 2017
2 263 Thu, 04 May 2017 15:53
By: scottwmackey
  Inserting data in multiple tables
Oracle 11g R2, pl/sql
By: kaos.tissue on Tue, 02 May 2017
27 685 Thu, 04 May 2017 08:34
By: Bill B
  Need to get the top 3 employees whose salary increased in three consecutive year
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Product ,window
By: arpit0508 on Thu, 27 April 2017
6 637 Mon, 01 May 2017 03:05
By: arpit0508
  Multiple rows based on column
Oracle 10g
By: sss111ind on Thu, 27 April 2017
9 836 Mon, 22 May 2017 10:51
By: Michel Cadot
  COnditional change Serial
Oracle 11G, Windows 2003
By: mmohsinaziz on Thu, 27 April 2017
2 384 Thu, 27 April 2017 02:23
By: mmohsinaziz
  ORA-00054 RESOURCE BUSY AND ACQUIRE WITH NOWAIT
By: mskphani on Mon, 24 April 2017
4 262 Mon, 24 April 2017 10:50
By: Michel Cadot
  Taking Sum of Similar Tables
Oracle 11g
By: gobi21 on Sun, 23 April 2017
13 444 Mon, 24 April 2017 07:45
By: gobi21
  Dynamic array as SP input
11.0.2.10
By: OraFerro on Sun, 23 April 2017
12 564 Tue, 09 May 2017 01:58
By: OraFerro
  DEFINE_COLUMN in DBMS_SQL
Oracle 11.2.0.3
By: pointers on Thu, 20 April 2017
2 196 Fri, 21 April 2017 02:09
By: pointers
  Pivot result using "Pivot" keyword
11.2
By: lott42 on Thu, 20 April 2017
4 347 Fri, 21 April 2017 12:22
By: lott42
  LIKE vs NOT LIKE operator
Oracle 12c
By: srinivas.k2005 on Fri, 21 April 2017
4 284 Fri, 21 April 2017 08:47
By: srinivas.k2005
  Need help to form Query to split count into multiple rows
By: rakesh281214 on Wed, 19 April 2017
5 365 Thu, 20 April 2017 14:30
By: Barbara Boehmer
  merge issue
By: JEWEL78 on Tue, 18 April 2017
11 412 Thu, 20 April 2017 03:55
By: cookiemonster
  pl/sql procedure using cursors
oracle 11g
By: POGAKU_SANTHOSH on Mon, 17 April 2017
3 209 Mon, 17 April 2017 16:03
By: BlackSwan
  Help required in SQL Analytic Function lag()
Oracle 11gR2 11.2.0.1.0
By: jimit_shaili on Sat, 15 April 2017
5 349 Mon, 17 April 2017 12:31
By: Michel Cadot
  Regexp magic ! (I hope)
11.2.0.3.0
By: Amine on Fri, 14 April 2017
6 388 Wed, 19 April 2017 01:47
By: Michel Cadot
  NOT LIKE operation on the numbers columns
Oracle 12c
By: ora_newbie111 on Sun, 16 April 2017
20 1027 Wed, 26 April 2017 10:47
By: Bill B
  SQL Tunning - Please Help Me
Oracle 10g
By: parthaspaul@gmail.com on Mon, 17 April 2017
21 661 Mon, 24 April 2017 18:21
By: mikek
  Partition tablespace name does not change after moving subpartition
oracle12c
By: shrinika on Sat, 15 April 2017
2 262 Sat, 15 April 2017 12:59
By: shrinika
  Issue with DATE
By: rajkumar561991 on Tue, 25 April 2017
5 554 Wed, 26 April 2017 06:49
By: EdStevens
  testing rollback
12.1.0.1
By: jinga on Fri, 07 April 2017
2 353 Tue, 11 April 2017 12:56
By: Bill B
  UNION and dependent LOV
Oracle R12
By: umamagi on Fri, 07 April 2017
3 389 Sat, 08 April 2017 03:20
By: Littlefoot
  Hierarchical Queries
Oracle 11.2.0.3
By: pointers on Thu, 06 April 2017
2 501 Sat, 08 April 2017 07:42
By: pointers
  package
By: jay12 on Wed, 05 April 2017
3 259 Thu, 06 April 2017 03:30
By: cookiemonster
  Avoid Distinct
Oracle 11g
By: manikandan23 on Wed, 05 April 2017
6 356 Thu, 06 April 2017 03:33
By: cookiemonster
  Pre Insert logic in Trigger
Oracle 11.2.0.3
By: pointers on Wed, 05 April 2017
10 481 Thu, 06 April 2017 21:09
By: pointers
  Split clob data and store in table
Oracle 11g
By: Roots_ct5 on Tue, 04 April 2017
3 297 Tue, 04 April 2017 10:30
By: Roots_ct5
  cursors
windows
By: jay12 on Tue, 04 April 2017
3 265 Fri, 14 April 2017 15:49
By: Bill B
  How can I convert a SQL command to MySql
By: vinodkalpaka on Mon, 03 April 2017
24 684 Tue, 04 April 2017 03:28
By: vinodkalpaka
  Need a help with SQL
Oracle 12C
By: mangeshbhasme on Sun, 02 April 2017
10 453 Tue, 04 April 2017 06:59
By: EdStevens
  Need help with SQL
Oracle 12c
By: jvanh on Fri, 31 March 2017
11 491 Mon, 03 April 2017 07:05
By: John Watson
  Re: ToDate function (split from hijacked thread http://www.orafaq.com/forum/t/56308/ by bb)
By: hyder on Thu, 30 March 2017
2 278 Fri, 31 March 2017 11:41
By: Bill B
  Converting comma separated value in different rows
Oracle 10g R2
By: amarbose on Sun, 02 April 2017
5 336 Mon, 03 April 2017 01:34
By: Michel Cadot
  UTL_FILE_DIR
Oracle 10gR2/ Solaris 10
By: reym21 on Wed, 29 March 2017
13 480 Thu, 30 March 2017 07:22
By: Bill B
  Avoid UNION ALL
Oracle 11.2.0.3
By: pointers on Tue, 28 March 2017
5 453 Wed, 29 March 2017 08:14
By: pointers
  Grouping for varying weeks
Oracle 11.2.0.3
By: pointers on Mon, 27 March 2017
7 545 Tue, 28 March 2017 04:13
By: pointers
  Inserting data from multiple table into 1 table
windows
By: Dnmunde on Sun, 26 March 2017
8 446 Mon, 27 March 2017 00:48
By: Michel Cadot
  oracle-dbms-fga-dynamically-create-an-audit-trail-or-policy (3 threads merged by bb)
By: jokrasa on Wed, 22 March 2017
9 626 Fri, 31 March 2017 11:45
By: Bill B
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Sun Aug 20 01:05:50 CDT 2017

Total time taken to generate the page: 0.74594 seconds