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
  dbms_scheduler -WeekDays scheduling program.
Oracle 11g, Windows
By: vicktorz on Thu, 14 May 2015
2 371 Thu, 14 May 2015 07:38
By: BlackSwan
  want data of all columns in a single column (no concatenate)
oracle 10g/11g
By: jgjeetu on Thu, 14 May 2015
7 475 Thu, 14 May 2015 07:35
By: jgjeetu
  Query using Partitioning
Oracle 11 G release R1
By: saurabh.sha on Wed, 13 May 2015
4 479 Thu, 14 May 2015 07:32
By: John Watson
  To take Previous date
Oracle 11g
By: rohit_shinez on Wed, 13 May 2015
8 681 Wed, 13 May 2015 16:28
By: John Watson
  Transpose/Pivot with all combination
By: jjxxs on Wed, 13 May 2015
2 468 Wed, 13 May 2015 08:20
By: Michel Cadot
  CREATE ANY PACKAGE alternative
Oracle 10g
By: Gnans on Wed, 13 May 2015
4 398 Wed, 13 May 2015 08:09
By: mnitu
  Temporary table space error
Oracle 8i
By: harshal_lagwankar on Tue, 12 May 2015
11 883 Wed, 13 May 2015 00:43
By: harshal_lagwankar
  Trigger associated with two Database
By: jknath on Mon, 11 May 2015
3 516 Tue, 12 May 2015 08:10
By: Bill B
  Oracle case statment solution
By: purnima1 on Mon, 11 May 2015
6 689 Tue, 12 May 2015 03:25
By: cookiemonster
  Pivoting Data
By: vpat on Mon, 11 May 2015
2 533 Tue, 12 May 2015 00:19
By: Michel Cadot
  ORA-01847 problem
oracle 10g windows 7 pro
By: bobghw on Thu, 07 May 2015
10 940 Mon, 11 May 2015 16:25
By: bobghw
  Finding positions of all 'X' in string?
By: Flyfishingninja on Mon, 11 May 2015
8 683 Mon, 11 May 2015 11:42
By: Solomon Yakobson
  PL/SQL Tables
Oracle 11g XE
By: Eric Langager on Mon, 09 February 2015
19 1591 Mon, 11 May 2015 04:05
By: Eric Langager
  Viewing Object values in select
11.2.0.1.0
By: OraFerro on Thu, 07 May 2015
13 943 Mon, 11 May 2015 01:10
By: OraFerro
  PRAGMA EXCEPTION_INIT not working as desired
O/S:Windows 7 PRO; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Sat, 09 May 2015
6 803 Sat, 09 May 2015 21:05
By: buggleboy007
  Wrong number of arguments being passed into child element
O/S:Windows 7 PRO; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Thu, 07 May 2015
4 679 Fri, 08 May 2015 10:23
By: Michel Cadot
  Frequency Distribution with future date place holders
SQL
By: fluffycone on Fri, 01 May 2015
6 750 Fri, 08 May 2015 01:15
By: Michel Cadot
  Processing Records in Cursor
By: rohit_shinez on Thu, 07 May 2015
4 495 Thu, 07 May 2015 13:41
By: John Watson
  View is not able to execute successfully because of using
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Thu, 07 May 2015
8 594 Thu, 07 May 2015 03:09
By: Roachcoach
  How to get count of character in the table
Oracle10g, Oracle11g
By: kumar0828 on Tue, 05 May 2015
5 673 Thu, 07 May 2015 01:01
By: Lalit Kumar B
  PL/SQL: ORA-00980: synonym translation is no longer valid
By: amit.sonar on Tue, 05 May 2015
5 749 Wed, 06 May 2015 17:19
By: BlackSwan
  How to get the right information suggested about Date
By: sbouhila on Mon, 04 May 2015
11 891 Wed, 06 May 2015 04:07
By: sbouhila
  How to convert CLOB(results of an SQL query) to XMLDocument
O/S:Windows 7 PRO; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Tue, 05 May 2015
5 534 Tue, 05 May 2015 21:56
By: BlackSwan
  How to avoid showing data on each row
Oracle 11g XE
By: kaz123 on Thu, 30 April 2015
12 872 Tue, 05 May 2015 11:32
By: flyboy
  need help in query
oracle 11i
By: moulivasireddy on Fri, 07 November 2014
6 789 Tue, 05 May 2015 06:35
By: Solomon Yakobson
  alignment of output in the dbms_output file
Oracle Database 11.1.0.7.0
By: mist598 on Tue, 05 May 2015
2 614 Tue, 05 May 2015 05:58
By: mist598
  list of columns of a table
By: hahaie on Mon, 10 November 2014
5 774 Tue, 05 May 2015 04:43
By: Lalit Kumar B
  Update record based on previous record
Oracle 11g
By: rohit_shinez on Sat, 02 May 2015
7 836 Mon, 04 May 2015 13:18
By: Bill B
  exception for field width
Oracle 10g
By: m.abdulhaq on Mon, 04 May 2015
1 422 Mon, 04 May 2015 13:01
By: BlackSwan
  PIVOTING: one row to multiple columns
By: dancko on Sun, 03 May 2015
13 676 Mon, 04 May 2015 04:22
By: Michel Cadot
  Generate range with given set of list
10.2.0.1.0
By: bluetooth420 on Sun, 03 May 2015
7 662 Mon, 04 May 2015 02:59
By: Michel Cadot
  How to convert a table of CLOBS to VARCHAR & How to come up with a magic number for any table that returns more than 32KB & ... ? (merged 3)
O/S:Windows 7 PRO; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Sat, 02 May 2015
18 1034 Sun, 03 May 2015 15:01
By: Michel Cadot
  Partition & Sub partition Table Creation Error
Oracle 11.2.0.4
By: hitesh.bhatt on Thu, 30 April 2015
17 1223 Sat, 02 May 2015 23:40
By: hitesh.bhatt
  Calc elapsed time per event & date
11.2
By: lott42 on Thu, 30 April 2015
9 1031 Fri, 01 May 2015 17:17
By: Solomon Yakobson
  Need help to Learn PL\SQL
By: marees.inspired on Fri, 01 May 2015
2 556 Fri, 01 May 2015 14:50
By: Michel Cadot
  How to fetch rows having only numbers in a varchar2 column
oracle 10g
By: m.abdulhaq on Thu, 30 April 2015
10 789 Fri, 01 May 2015 07:05
By: Lalit Kumar B
  select from two tables
By: amjad_alahdal on Thu, 30 April 2015
5 711 Thu, 30 April 2015 12:31
By: joy_division
  REGEXP_REPLACE IN A CASE STATEMENT
Oracle PS/SQL Developer
By: headrj on Wed, 29 April 2015
8 628 Wed, 29 April 2015 14:12
By: Michel Cadot
icon6.gif When was a tablespace created?
By: LKBrwn_DBA on Wed, 29 April 2015
7 633 Wed, 29 April 2015 11:25
By: LKBrwn_DBA
  Leading zero and comma decimal separator
Oracle 11 G
By: sinpeak on Wed, 29 April 2015
3 822 Wed, 29 April 2015 10:28
By: sinpeak
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 Jul 26 13:09:16 CDT 2016

Total time taken to generate the page: 0.06138 seconds