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
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
41 146213 Thu, 23 July 2015 10:23
By: Lalit Kumar B
  sticky: How to use code tags and make your code easier to read
By: Littlefoot on Mon, 05 September 2011
0 7841 Mon, 05 September 2011 02:20
By: Littlefoot
  Retrieve column names with aliases
Oracle 10g
By: ananya.saphira on Tue, 12 December 2017
6 29 Tue, 12 December 2017 12:45
By: Michel Cadot
  CREATE VIEW with "SELECT * FROM" several tables
Oracle 11 / Oracle 12
By: Rumak18 on Tue, 12 December 2017
3 80 Tue, 12 December 2017 10:41
By: cookiemonster
  ORA-01502: index or partition of such index is in usable
Oracle 12C (12.1.0.2.0)
By: takwadin on Tue, 12 December 2017
3 130 Tue, 12 December 2017 05:09
By: John Watson
  need two token matching query
oracle 11.2.0.4
By: mvrkr44 on Thu, 07 December 2017
13 1234 Mon, 11 December 2017 21:11
By: Barbara Boehmer
  i need to know hows this happening?
By: amul on Wed, 19 July 2006
8 707 Mon, 11 December 2017 09:30
By: appailoveyou
  Temporary LOBs, temp space, PGA
DB 12.x
By: John Watson on Fri, 08 December 2017
3 693 Fri, 08 December 2017 11:53
By: Michel Cadot
  sequence problem?
forms 6i , 11g db
By: Amjad_1975 on Sat, 02 December 2017
23 1576 Fri, 08 December 2017 06:18
By: EdStevens
  How to convert column to rows
Oracle 11g
By: sss111ind on Fri, 08 December 2017
1 392 Fri, 08 December 2017 01:49
By: sss111ind
  Help in Query for Required output
Oracle8i Enterprise Edition Release 8.1.7.0.0
By: shawaj on Tue, 05 December 2017
17 652 Wed, 06 December 2017 09:30
By: shawaj
icon7.gif Number Conversion
Oracle 10g
By: maanosajnabi on Wed, 06 December 2017
2 202 Wed, 06 December 2017 03:58
By: maanosajnabi
  Term Match with Jaro-Winkler logic
11
By: OracleUser2017 on Fri, 01 December 2017
14 1520 Tue, 05 December 2017 10:48
By: Barbara Boehmer
  remove duplicate values by date
all
By: laredoeneko on Tue, 28 November 2017
8 994 Tue, 05 December 2017 07:10
By: Bill B
  SQL Query
11g
By: LKT on Fri, 01 December 2017
11 1197 Mon, 04 December 2017 03:02
By: Michel Cadot
  Difference in SQL 'order by' and MIN, MAX, LISTAGG results
oracle 12c, client 11G sous windows
By: moracles on Thu, 30 November 2017
25 1009 Fri, 01 December 2017 10:27
By: Michel Cadot
  regexp_replace() function help
By: wtolentino on Thu, 30 November 2017
9 938 Fri, 01 December 2017 08:57
By: wtolentino
  Function Creation
By: WhoAmI on Wed, 29 November 2017
5 537 Thu, 30 November 2017 03:31
By: cookiemonster
  switch data positions
By: wtolentino on Tue, 28 November 2017
4 633 Wed, 29 November 2017 11:06
By: wtolentino
  trigger impacting performance
11g32 linux(RHEL)
By: dba4oracle on Tue, 28 November 2017
14 722 Wed, 29 November 2017 06:05
By: dba4oracle
  Help in YIELD [Excel Function] formula in PLSQL
Oracle 11 G
By: SATHISHENU on Mon, 27 November 2017
4 616 Mon, 27 November 2017 10:08
By: Barbara Boehmer
  Packages
By: rkapex on Sat, 25 November 2017
6 835 Mon, 27 November 2017 08:04
By: Bill B
  How to Avoid ORA-01438: value larger than specified precision allowed for this column
Oracle11g
By: ssyr on Fri, 24 November 2017
23 1280 Mon, 27 November 2017 06:01
By: ssyr
  Procedure
By: rkapex on Sat, 25 November 2017
3 755 Mon, 27 November 2017 03:25
By: cookiemonster
  Using views to summarise payment info
Oracle SQL 12
By: Rugad on Sun, 26 November 2017
1 512 Sun, 26 November 2017 16:44
By: BlackSwan
  help convert mac address string to hex
oracle 12c
By: laredoeneko on Sun, 26 November 2017
7 522 Sun, 26 November 2017 14:16
By: EdStevens
  Array ORA-06533: Subscript beyond count
11.0.2.10
By: OraFerro on Wed, 22 November 2017
8 1339 Sat, 25 November 2017 23:01
By: OraFerro
  Oracle Sub-query and AND clause behaviour
11g
By: LKT on Sun, 19 November 2017
3 800 Fri, 24 November 2017 09:11
By: Bill B
  Is there a way to do a rollup on only one dimension
11.2.0.4, Windows 2012 R2
By: juniordbanewbie on Thu, 23 November 2017
2 614 Fri, 24 November 2017 07:51
By: Solomon Yakobson
icon5.gif Unable to grant Admin privileges on SQL Developer 12c
Oracle SQL Developer 12c
By: Dave0001 on Fri, 24 November 2017
6 601 Fri, 24 November 2017 02:20
By: Littlefoot
  Drop Function gives error
oracle 12c Windows 2012
By: muthukrish104 on Fri, 17 November 2017
6 1303 Wed, 22 November 2017 07:05
By: BlackSwan
  how can get Three consecutive days
By: hassan08 on Fri, 17 November 2017
5 1050 Mon, 20 November 2017 05:21
By: Solomon Yakobson
  grouping in matrix
12c
By: m.abdulhaq on Sun, 19 November 2017
3 779 Mon, 20 November 2017 05:02
By: Solomon Yakobson
  Query Analysis
Oracle 12c
By: srinivas.k2005 on Mon, 20 November 2017
7 581 Mon, 20 November 2017 04:53
By: srinivas.k2005
  Passing warning collection from PL/SQL
11.0.2.10
By: OraFerro on Sun, 19 November 2017
2 586 Sun, 19 November 2017 22:27
By: OraFerro
  ora 01882
Sql Developer, 1.5.1.54.40, Windows Server 2003
By: getritesh on Tue, 25 May 2010
24 8465 Sun, 19 November 2017 14:23
By: ashisheck
  REST API with DDOS protection
ORACLE 12c
By: mmation on Fri, 17 November 2017
2 642 Sat, 18 November 2017 09:47
By: mmation
  REGEXP_SUBSTR
ORACLE,12C,UNIX
By: pstanand on Fri, 17 November 2017
4 608 Fri, 17 November 2017 10:21
By: pstanand
  PL/SQL: SQL Statement Ignored
ORACLE XE sql developer version 17.3.0.271
By: malflowers on Thu, 16 November 2017
9 854 Fri, 17 November 2017 05:35
By: malflowers
  oracle external table issue
oracle 11g
By: POGAKU_SANTHOSH on Sun, 12 November 2017
6 687 Sun, 12 November 2017 11:51
By: POGAKU_SANTHOSH
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 Dec 12 13:02:32 CST 2017

Total time taken to generate the page: 0.03176 seconds