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
  365 days always
oracle 11g, linux
By: hisham99 on Sun, 08 April 2018
14 2308 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 1770 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 1187 Mon, 09 April 2018 09:42
By: BlackSwan
  Spell out numbers to words
By: Cyrille PETIT on Thu, 14 March 2002
17 10748 Fri, 06 April 2018 12:12
By: Solomon Yakobson
  Answer the query
Oracle 11g Query
By: Lokesh A on Thu, 05 April 2018
2 963 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 1063 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 1003 Mon, 02 April 2018 21:11
By: suneeshvr
  Administering queue
Oracle 11.2.0.3, AIX
By: arijit2004 on Fri, 30 March 2018
13 1795 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 1804 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 1062 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 1085 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 820 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 2408 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 1564 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 1398 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 1903 Sat, 24 March 2018 02:35
By: John Watson
  Display Comma Separated Values
11g
By: glmjoy on Wed, 21 March 2018
9 2020 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 3181 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 2613 Wed, 21 March 2018 11:56
By: Saz
  Comma Seprate
11g
By: glmjoy on Mon, 19 March 2018
4 1229 Tue, 20 March 2018 18:19
By: glmjoy
  return records based on records
By: mist598 on Mon, 19 March 2018
5 1275 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 802 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 1316 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 1052 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 1055 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 1157 Tue, 13 March 2018 13:11
By: EdStevens
  Import data from excel to oracle Db
By: malu on Mon, 12 March 2018
3 1166 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 1279 Tue, 13 March 2018 09:16
By: msol25
  DBMS_CRYPTO package
By: adovgan on Tue, 13 March 2018
2 820 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 801 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 1589 Fri, 09 March 2018 23:40
By: akssre
  Get Current & Previous Quarter Data from table
By: ramya29p on Fri, 09 March 2018
5 1227 Fri, 09 March 2018 05:03
By: flyboy
  Oracle Partitioned Table get values
11G
By: elixir86 on Tue, 06 March 2018
1 764 Tue, 06 March 2018 13:12
By: BlackSwan
  help with error executing a view
oracle 12c
By: laredoeneko on Sat, 03 March 2018
14 2064 Sun, 04 March 2018 11:36
By: Michel Cadot
  comma separated string to column dynamically
By: ramya29p on Tue, 27 February 2018
10 1738 Wed, 28 February 2018 07:35
By: Bill B
  Compare row & column data
11G
By: bond_8801 on Tue, 27 February 2018
8 1372 Tue, 27 February 2018 17:33
By: BlackSwan
  Count occurrences of String in field
Oracle 11g, Win 10
By: rajivn786 on Mon, 26 February 2018
2 927 Tue, 27 February 2018 10:52
By: rajivn786
  Table Archive and Purge
11.2
By: gopikrish_6 on Sun, 25 February 2018
6 1221 Mon, 26 February 2018 15:30
By: Bill B
  Commit after deletion of every 5000 rows
Oracle11g
By: ssyr on Mon, 08 January 2018
17 2941 Mon, 26 February 2018 15:23
By: Bill B
  string format
By: suji6281 on Mon, 26 February 2018
3 853 Mon, 26 February 2018 10:08
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: Tue Aug 21 18:45:59 CDT 2018