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 get count of character in the table
Oracle10g, Oracle11g
By: kumar0828 on Tue, 05 May 2015
5 641 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 685 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 861 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 500 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 840 Tue, 05 May 2015 11:32
By: flyboy
  need help in query
oracle 11i
By: moulivasireddy on Fri, 07 November 2014
6 758 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 565 Tue, 05 May 2015 05:58
By: mist598
  list of columns of a table
By: hahaie on Mon, 10 November 2014
5 755 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 810 Mon, 04 May 2015 13:18
By: Bill B
  exception for field width
Oracle 10g
By: m.abdulhaq on Mon, 04 May 2015
1 409 Mon, 04 May 2015 13:01
By: BlackSwan
  PIVOTING: one row to multiple columns
By: dancko on Sun, 03 May 2015
13 645 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 634 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 1002 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 1158 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 976 Fri, 01 May 2015 17:17
By: Solomon Yakobson
  Need help to Learn PL\SQL
By: marees.inspired on Fri, 01 May 2015
2 543 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 756 Fri, 01 May 2015 07:05
By: Lalit Kumar B
  select from two tables
By: amjad_alahdal on Thu, 30 April 2015
5 684 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 596 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 621 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 767 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 1589 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 549 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 762 Tue, 28 April 2015 05:36
By: flyboy
  SQL Query
10g/11g
By: ashish_sun123 on Tue, 14 April 2015
15 913 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 477 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 878 Fri, 24 April 2015 01:34
By: Lalit Kumar B
  complex view query with multiple lookups
By: natrajdreams on Wed, 22 April 2015
14 903 Wed, 22 April 2015 09:17
By: cookiemonster
  SQL query for count
By: asbh123 on Thu, 20 November 2014
20 2017 Wed, 22 April 2015 03:12
By: cookiemonster
  UTL File reader
Oracle,10G,Windows 7
By: gsaravanan on Mon, 20 April 2015
14 887 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 581 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 826 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 1321 Mon, 20 April 2015 13:07
By: ORA2015
  Date functions
By: thiruvari on Mon, 20 April 2015
10 589 Mon, 20 April 2015 12:40
By: thiruvari
  DBMS_CRYPTO
11g database
By: vippysharma on Mon, 20 April 2015
5 716 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 690 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 905 Sun, 19 April 2015 13:01
By: Kevin Meade
  multilagual charactor
10g,11g
By: dsatya10 on Sun, 19 April 2015
14 807 Sun, 19 April 2015 12:56
By: Michel Cadot
  SQL query help
oracle 11g
By: gorants on Sat, 18 April 2015
2 511 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 946 Fri, 17 April 2015 01:12
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: Sat May 28 21:47:26 CDT 2016

Total time taken to generate the page: 0.15476 seconds