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
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
41 174365 Thu, 23 July 2015 10:23
By: Lalit Kumar B
  sticky: How to use code tags and make your code easier to read
By: Littlefoot on Mon, 05 September 2011
0 9417 Mon, 05 September 2011 02:20
By: Littlefoot
  Executing the run time file at SQLPLUS
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Mon, 23 April 2018
16 984 Thu, 26 April 2018 14:47
By: Bill B
  roles granted to a role
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
By: wtolentino on Thu, 26 April 2018
4 175 Thu, 26 April 2018 14:35
By: Solomon Yakobson
  Trap Constraint Errors in PL/SQL?
11g Release 11.2.0.3.0
By: whdyck on Thu, 26 April 2018
5 242 Thu, 26 April 2018 10:10
By: Michel Cadot
Database Upgrade has been moved to Server Administration by the moderator.
  Table select show blank
oracle 12c Windows 2012
By: muthukrish104 on Sun, 22 April 2018
16 849 Wed, 25 April 2018 04:42
By: muthukrish104
synonym how get info on how user has access to it has been moved to Security by the moderator.
  Pagination
Oracle 12 C
By: satya_ora on Sun, 22 April 2018
3 490 Mon, 23 April 2018 06:42
By: Solomon Yakobson
  Handle return empty cursor in SP output parameter
11.0.2.10
By: OraFerro on Mon, 16 April 2018
9 1377 Mon, 23 April 2018 04:54
By: OraFerro
  Polish Characters are missing through the SQLPLUS
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Wed, 18 April 2018
2 972 Mon, 23 April 2018 04:44
By: saipradyumn
  Need Help In Dates
sql Oraccle
By: Djpats on Sat, 21 April 2018
3 400 Sat, 21 April 2018 20:20
By: Solomon Yakobson
  SQL rollup count every day
By: dinavahi.saradhi@gmail.co on Thu, 19 April 2018
1 600 Thu, 19 April 2018 10:43
By: BlackSwan
  Dropping a Primary Key constraint
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professional
By: buggleboy007 on Mon, 16 April 2018
15 1075 Wed, 18 April 2018 10:22
By: buggleboy007
  modification date for package SP
11.0.2.10
By: OraFerro on Mon, 16 April 2018
4 453 Tue, 17 April 2018 23:55
By: OraFerro
  Main Stored procedure to execute multiple procedures
Oracle 11.2,Linux
By: senmng on Mon, 16 April 2018
8 841 Tue, 17 April 2018 06:26
By: EdStevens
  SQL statement with averages
By: dinavahi.saradhi@gmail.co on Mon, 16 April 2018
0 583 Mon, 16 April 2018 10:42
By: dinavahi.saradhi@gmail.co
  Please help for resolving error for PIPELINED table function call
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: msol25 on Mon, 16 April 2018
2 423 Mon, 16 April 2018 05:51
By: msol25
  Need Help In Plsql Procedure
Plsql
By: Djpats on Sat, 14 April 2018
3 784 Mon, 16 April 2018 03:23
By: cookiemonster
  divide string into multiple parts
By: suji6281 on Sat, 14 April 2018
13 966 Mon, 16 April 2018 01:46
By: _jum
  Problem in adding Html code in PL/SQL procedure
By: Djpats on Sat, 14 April 2018
3 777 Mon, 16 April 2018 00:34
By: Djpats
  multiple selects after with clauses
By: dinavahi.saradhi@gmail.co on Thu, 12 April 2018
3 763 Fri, 13 April 2018 00:10
By: Barbara Boehmer
  group timestamp column hourly
By: dinavahi.saradhi@gmail.co on Wed, 11 April 2018
3 513 Wed, 11 April 2018 13:00
By: Michel Cadot
  365 days always
oracle 11g, linux
By: hisham99 on Sun, 08 April 2018
14 1160 Wed, 11 April 2018 09:41
By: JPBoileau
  ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Sat, 07 April 2018
7 1169 Wed, 11 April 2018 09:14
By: saipradyumn
  Oracle 12C error tracing and debugging issue (merged 2)
By: ImSandip on Mon, 09 April 2018
5 668 Mon, 09 April 2018 09:42
By: BlackSwan
  Spell out numbers to words
By: Cyrille PETIT on Thu, 14 March 2002
17 9379 Fri, 06 April 2018 12:12
By: Solomon Yakobson
  Answer the query
Oracle 11g Query
By: Lokesh A on Thu, 05 April 2018
2 554 Fri, 06 April 2018 08:04
By: joy_division
  UNUSABLE INDEX on Partition table
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Tue, 03 April 2018
3 644 Tue, 03 April 2018 08:52
By: saipradyumn
  Resource allocation problem
Oracle 12c- 12.2.0.1.0
By: suneeshvr on Mon, 02 April 2018
5 552 Mon, 02 April 2018 21:11
By: suneeshvr
  Administering queue
Oracle 11.2.0.3, AIX
By: arijit2004 on Fri, 30 March 2018
13 1292 Sat, 31 March 2018 04:53
By: arijit2004
  getting error "table table1 is mutating, trigger/function may no" on executing trigger
ORacle 11g
By: gold14388 on Thu, 29 March 2018
8 1103 Fri, 30 March 2018 10:59
By: BlackSwan
  identifier 'PACK_GEO.TRAN001' must be declared
AIX, Oracle 11.2.0.3
By: arijit2004 on Fri, 30 March 2018
2 739 Fri, 30 March 2018 06:29
By: arijit2004
  How to get this table from that Database
PL/SQL Developer, unknown, Win 10
By: Nanex on Thu, 29 March 2018
2 745 Thu, 29 March 2018 08:30
By: joy_division
  How to insert table alias in query
Oracle 11g
By: ssyr on Wed, 28 March 2018
2 500 Thu, 29 March 2018 01:53
By: Michel Cadot
  how to use variable to store comma seperated values
11G
By: satya_ora on Tue, 27 March 2018
7 902 Tue, 27 March 2018 20:26
By: satya_ora
  ORA-21561: OID generation failed !!
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production, Redhat 6
By: fixxxer on Wed, 07 March 2018
10 1164 Tue, 27 March 2018 09:40
By: fixxxer
  oracle Trigger for E-mail notifications !!
oracle 11g
By: shipon_97 on Sun, 25 March 2018
10 1102 Mon, 26 March 2018 23:57
By: shipon_97
  How to log error using UTL_CALL_STACK
Oracle 12c
By: sss111ind on Wed, 07 March 2018
6 994 Mon, 26 March 2018 07:16
By: Bill B
  Merge 2 or more rows into 1
oracle 12c
By: laredoeneko on Fri, 23 March 2018
7 1338 Sat, 24 March 2018 02:35
By: John Watson
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: Fri Apr 27 02:01:32 CDT 2018

Total time taken to generate the page: 0.01674 seconds