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
  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 428 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 773 Tue, 05 May 2015 11:32
By: flyboy
  need help in query
oracle 11i
By: moulivasireddy on Fri, 07 November 2014
6 696 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 468 Tue, 05 May 2015 05:58
By: mist598
  list of columns of a table
By: hahaie on Mon, 10 November 2014
5 680 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 716 Mon, 04 May 2015 13:18
By: Bill B
  exception for field width
Oracle 10g
By: m.abdulhaq on Mon, 04 May 2015
1 371 Mon, 04 May 2015 13:01
By: BlackSwan
  PIVOTING: one row to multiple columns
By: dancko on Sun, 03 May 2015
13 577 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 565 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 931 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 992 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 873 Fri, 01 May 2015 17:17
By: Solomon Yakobson
  Need help to Learn PL\SQL
By: marees.inspired on Fri, 01 May 2015
2 506 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 703 Fri, 01 May 2015 07:05
By: Lalit Kumar B
  select from two tables
By: amjad_alahdal on Thu, 30 April 2015
5 598 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 520 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 574 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 614 Wed, 29 April 2015 10:28
By: sinpeak
  How do I pass a table name dynamically using execute immediate
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, 23 April 2015
23 1374 Wed, 29 April 2015 10:04
By: Lalit Kumar B
  Reg Spliting line using instr,substr and regexp
Oracle,10G,Windows 7
By: gsaravanan on Tue, 28 April 2015
6 471 Tue, 28 April 2015 13:41
By: Michel Cadot
  While inserting record i got error ORA-00903: invalid table name
By: pandilakshmanan1989@gmail on Tue, 28 April 2015
8 647 Tue, 28 April 2015 05:36
By: flyboy
  SQL Query
10g/11g
By: ashish_sun123 on Tue, 14 April 2015
15 840 Mon, 27 April 2015 02:23
By: Michel Cadot
  Reading the Highvalue of partition and performing dynamic operation
Oracle 11g
By: srinivas.k2005 on Sat, 25 April 2015
1 431 Sat, 25 April 2015 17:12
By: srinivas.k2005
  inner query use outer query
oracle 11g
By: miroconnect@yahoo.com on Wed, 22 April 2015
4 822 Fri, 24 April 2015 01:34
By: Lalit Kumar B
  complex view query with multiple lookups
By: natrajdreams on Wed, 22 April 2015
14 820 Wed, 22 April 2015 09:17
By: cookiemonster
  SQL query for count
By: asbh123 on Thu, 20 November 2014
20 1856 Wed, 22 April 2015 03:12
By: cookiemonster
  UTL File reader
Oracle,10G,Windows 7
By: gsaravanan on Mon, 20 April 2015
14 812 Tue, 21 April 2015 14:39
By: Barbara Boehmer
  Hierarchical queries with aggregation
11.2.0.3
By: grpatwari on Tue, 21 April 2015
3 521 Tue, 21 April 2015 08:02
By: grpatwari
  Convert date to weeks in the month and days
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production Oracle ORACLE PL/SQL V10.1.0.4.2 - Pr
By: anumoses58 on Mon, 20 April 2015
36 745 Mon, 20 April 2015 14:16
By: EdStevens
  External Tables
Linux 5.5, Oracle 10g, Windows xp
By: ORA2015 on Wed, 25 March 2015
25 1240 Mon, 20 April 2015 13:07
By: ORA2015
  Date functions
By: thiruvari on Mon, 20 April 2015
10 547 Mon, 20 April 2015 12:40
By: thiruvari
  DBMS_CRYPTO
11g database
By: vippysharma on Mon, 20 April 2015
5 627 Mon, 20 April 2015 06:32
By: vippysharma
  Same Query taking significantly different time on different days
Oracle 11g
By: saurabh.sha on Wed, 15 April 2015
3 619 Sun, 19 April 2015 13:09
By: Kevin Meade
  how to decide when to go for local vs global partitioned index on a table
Oracle 11g
By: rishuk on Tue, 14 April 2015
7 825 Sun, 19 April 2015 13:01
By: Kevin Meade
  multilagual charactor
10g,11g
By: dsatya10 on Sun, 19 April 2015
14 730 Sun, 19 April 2015 12:56
By: Michel Cadot
  SQL query help
oracle 11g
By: gorants on Sat, 18 April 2015
2 452 Sat, 18 April 2015 12:20
By: Barbara Boehmer
  MAT view - Start with & Next
Oracle 12g
By: Oracle_Walker on Wed, 15 April 2015
9 854 Fri, 17 April 2015 01:12
By: Michel Cadot
  get data from two tables
By: ketangarg86 on Thu, 16 April 2015
2 418 Thu, 16 April 2015 14:54
By: Michel Cadot
  Need to know about some basic for explain plan
Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro
By: shumail on Wed, 15 April 2015
6 625 Thu, 16 April 2015 07:01
By: mnitu
  Procedure altered with compilation errors
11.2.0.4
By: krish96 on Tue, 14 April 2015
6 730 Wed, 15 April 2015 13:30
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: Fri Feb 12 10:32:52 CST 2016

Total time taken to generate the page: 0.18896 seconds