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
  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 691 Mon, 16 April 2018 05:51
By: msol25
  Need Help In Plsql Procedure
Plsql
By: Djpats on Sat, 14 April 2018
3 1095 Mon, 16 April 2018 03:23
By: cookiemonster
  divide string into multiple parts
By: suji6281 on Sat, 14 April 2018
13 1470 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 1076 Mon, 16 April 2018 00:34
By: Djpats
  multiple selects after with clauses
By: dinavahi.saradhi@gmail.co on Thu, 12 April 2018
3 1061 Fri, 13 April 2018 00:10
By: Barbara Boehmer
  group timestamp column hourly
By: dinavahi.saradhi@gmail.co on Wed, 11 April 2018
3 808 Wed, 11 April 2018 13:00
By: Michel Cadot
  365 days always
oracle 11g, linux
By: hisham99 on Sun, 08 April 2018
14 1615 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 1481 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 909 Mon, 09 April 2018 09:42
By: BlackSwan
  Spell out numbers to words
By: Cyrille PETIT on Thu, 14 March 2002
17 9821 Fri, 06 April 2018 12:12
By: Solomon Yakobson
  Answer the query
Oracle 11g Query
By: Lokesh A on Thu, 05 April 2018
2 761 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 849 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 762 Mon, 02 April 2018 21:11
By: suneeshvr
  Administering queue
Oracle 11.2.0.3, AIX
By: arijit2004 on Fri, 30 March 2018
13 1502 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 1356 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 875 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 888 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 617 Thu, 29 March 2018 01:53
By: Michel Cadot
  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 1485 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 1272 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 1106 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 1451 Sat, 24 March 2018 02:35
By: John Watson
  Display Comma Separated Values
11g
By: glmjoy on Wed, 21 March 2018
9 1724 Fri, 23 March 2018 11:34
By: glmjoy
  Oracle 10 vs Oracle 12: order from SELECT statement
Oracle12
By: basileus on Wed, 14 March 2018
15 2455 Fri, 23 March 2018 07:53
By: cookiemonster
icon1.gif Transaction 2 happen within 60 days of Transaction 1
Oracle Database 12c Enterprise Edition 12.1.0.2.0
By: Saz on Tue, 20 March 2018
13 1771 Wed, 21 March 2018 11:56
By: Saz
  Comma Seprate
11g
By: glmjoy on Mon, 19 March 2018
4 1032 Tue, 20 March 2018 18:19
By: glmjoy
  return records based on records
By: mist598 on Mon, 19 March 2018
5 1049 Tue, 20 March 2018 14:20
By: Barbara Boehmer
  Arranging row data in column
Oracel 10G, Windows 10
By: anil029 on Tue, 20 March 2018
1 640 Tue, 20 March 2018 07:44
By: BlackSwan
  How To Count Total number of rows deleted by DELETE and reset counter after some condition
Oracle11g
By: ssyr on Thu, 15 March 2018
9 836 Thu, 15 March 2018 06:13
By: ssyr
  Help on running difference sql query (2 merged by CM)
oracle 11g
By: bharathi89 on Wed, 14 March 2018
6 850 Wed, 14 March 2018 21:21
By: bharathi89
  How Can I Execute Table Name in Order without using ORDER BY Clayuse
Oracle11g
By: ssyr on Tue, 13 March 2018
6 812 Wed, 14 March 2018 05:37
By: msol25
  Help required for taking distinct count without using DISTINCT keyword
By: ramya29p on Mon, 12 March 2018
7 904 Tue, 13 March 2018 13:11
By: EdStevens
  Import data from excel to oracle Db
By: malu on Mon, 12 March 2018
3 937 Tue, 13 March 2018 13:06
By: EdStevens
  select more rows and insert less
oracle 11gr2
By: guddu_12 on Tue, 06 March 2018
6 1076 Tue, 13 March 2018 09:16
By: msol25
  DBMS_CRYPTO package
By: adovgan on Tue, 13 March 2018
2 625 Tue, 13 March 2018 07:09
By: adovgan
  steps to create dynamic join query in oracle sql
By: asheolik on Mon, 12 March 2018
1 640 Mon, 12 March 2018 08:04
By: John Watson
  How to print Boolean or True/False value in Sql
Oracle 12c, Windows
By: akssre on Wed, 07 March 2018
9 1273 Fri, 09 March 2018 23:40
By: akssre
  Get Current & Previous Quarter Data from table
By: ramya29p on Fri, 09 March 2018
5 992 Fri, 09 March 2018 05:03
By: flyboy
  Oracle Partitioned Table get values
11G
By: elixir86 on Tue, 06 March 2018
1 593 Tue, 06 March 2018 13:12
By: BlackSwan
  help with error executing a view
oracle 12c
By: laredoeneko on Sat, 03 March 2018
14 1341 Sun, 04 March 2018 11:36
By: Michel Cadot
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 May 27 20:45:17 CDT 2018