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: How to use code tags and make your code easier to read
By: Littlefoot on Mon, 05 September 2011
0 3436 Mon, 05 September 2011 02:20
By: Littlefoot
  query to write rows to column values
11.2.0.4
By: grpatwari on Tue, 31 May 2016
13 490 Mon, 29 August 2016 23:00
By: grpatwari
  Format result set of a union
DB 10g
By: adfnewbie on Mon, 29 August 2016
15 279 Mon, 29 August 2016 16:53
By: Barbara Boehmer
Problem with Oracle Wallet functionality in a call HTTPS web serivces has been moved to Security by the moderator.
  Selective count with a condition
Oracle SQL 11G
By: vickytalware on Thu, 25 August 2016
8 338 Fri, 26 August 2016 23:25
By: vickytalware
  How to identify the partition type
Oracle 11
By: saipradyumn on Tue, 23 August 2016
5 473 Fri, 26 August 2016 02:46
By: saipradyumn
  Minus Minutes
11g
By: glmjoy on Fri, 26 August 2016
9 247 Fri, 26 August 2016 02:43
By: glmjoy
  Script Help
SQL Developer
By: kolpalamayaw on Tue, 16 August 2016
4 295 Thu, 25 August 2016 09:40
By: ALEXWE
  how to restrict set of data in oracle
oracle,12.1.0.2.0 ,windows7
By: saini006 on Thu, 25 August 2016
3 281 Thu, 25 August 2016 07:51
By: Michel Cadot
  Query to get Middle Record from a table
Oracle 11g
By: arifs3738 on Wed, 24 August 2016
8 398 Thu, 25 August 2016 06:37
By: EdStevens
icon5.gif Union of 4 different columns in Single Row
SQL, PLSQL
By: anil_apps on Wed, 24 August 2016
4 240 Thu, 25 August 2016 00:44
By: Michel Cadot
  Sequence partition clause
DB12.x (and possibly earlier)
By: John Watson on Tue, 23 August 2016
2 116 Tue, 23 August 2016 03:15
By: John Watson
  Need to correlate and reconcile two data sets with different number of records
Oracle Database, 10g Rel.2 , Windows Server 2012
By: mazam on Mon, 22 August 2016
1 331 Mon, 22 August 2016 13:54
By: Barbara Boehmer
  How to remove duplicate value from type in SQL
Oracle 11i,Toad
By: victoryhendry on Tue, 16 August 2016
6 720 Mon, 22 August 2016 04:51
By: sandeep_orafaq
  Insert the data into dynamically created table (2 threads merged by bb)
11.2.0.4
By: grpatwari on Thu, 18 August 2016
14 690 Mon, 22 August 2016 04:03
By: sandeep_orafaq
  connect by prior help
11G
By: sanjuchand on Sat, 20 August 2016
4 345 Sun, 21 August 2016 11:00
By: sanjuchand
  Dropping tables in a stored procedure
119
By: simonrlee22 on Fri, 19 August 2016
8 501 Fri, 19 August 2016 14:28
By: BlackSwan
  Dynamic SQL Learning
11g
By: Irish88 on Wed, 10 August 2016
7 442 Thu, 18 August 2016 12:10
By: Irish88
  How to get a value that has never been updated
Oracle Database:11.2.0.1.0; TOAD: 12.1, O/S: Windows 7 Professional 64 bit
By: buggleboy007 on Wed, 17 August 2016
8 602 Thu, 18 August 2016 07:25
By: Bill B
  ORA-01917 ERROR
By: mfahimaamirgmailcom on Thu, 18 August 2016
2 255 Thu, 18 August 2016 06:11
By: Michel Cadot
  previous data
oracle 11gr2
By: guddu_12 on Wed, 17 August 2016
7 270 Wed, 17 August 2016 14:04
By: Michel Cadot
  Renaming a table
Oracle 11
By: saipradyumn on Tue, 16 August 2016
6 363 Wed, 17 August 2016 07:28
By: Bill B
  PL/SQL: ORA-00942: table or view does not exist
Oracle 11g, 11.2.0.3.0
By: wtolentino on Tue, 16 August 2016
3 521 Wed, 17 August 2016 06:45
By: wtolentino
  Find unique and sorted field value
By: amarbose on Tue, 16 August 2016
10 400 Wed, 17 August 2016 06:28
By: Michel Cadot
  Need to Retrieve data from JSON file in Oracle sql select query
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Thu, 11 August 2016
9 489 Wed, 17 August 2016 04:20
By: Michel Cadot
  keep only numeric values in a string
oracle 11g, windows
By: chinmay45 on Tue, 16 August 2016
18 347 Wed, 17 August 2016 01:35
By: Michel Cadot
  PLS-00231:
By: desmond30 on Mon, 15 August 2016
7 338 Tue, 16 August 2016 08:08
By: Michel Cadot
  Update or create function paramater
Oracle Database 10g Enterprise Edition ,10.2.0.4.0, linux64_86
By: abdo2203 on Sat, 13 August 2016
5 452 Sat, 13 August 2016 09:36
By: abdo2203
  Help reverse engineering pl sql query
Oracle sql
By: jprisk on Fri, 12 August 2016
4 387 Fri, 12 August 2016 15:03
By: Barbara Boehmer
  Repeat data based on count column
Oracle 11g Release 2, Linux
By: anil_mk on Thu, 11 August 2016
5 315 Fri, 12 August 2016 07:23
By: anil_mk
  Dynamic Update statement Error
Oracle 9i
By: cvs_1984 on Thu, 11 August 2016
2 213 Thu, 11 August 2016 05:31
By: cvs_1984
  Query help
Oracle 12.1.0.2.0, Linux
By: sspn2010 on Mon, 08 August 2016
6 377 Tue, 09 August 2016 16:21
By: sspn2010
  Check if value EXISTS in plsql table of record type
11G
By: harshadsp on Wed, 03 August 2016
11 590 Mon, 08 August 2016 05:57
By: harshadsp
  SQL connectivity test
oracle, 11g, AIX
By: Prathikesh on Sat, 06 August 2016
24 500 Mon, 08 August 2016 02:50
By: cookiemonster
  UTL_DBWS error: ORA-29540: class oracle/jpub/runtime/dbws/DbwsProxy does not exist
Oracle DB, 10g R2, Windows Server 2008R2
By: mdsirajoddin on Sat, 06 August 2016
12 381 Sat, 06 August 2016 10:38
By: Michel Cadot
  Sum from part of coloumn
Oracle,11g Release 11.2.0.4.0, Solaris 11
By: nms123 on Fri, 05 August 2016
2 246 Fri, 05 August 2016 09:47
By: nms123
  Help using regexp_substr - Urgent Help needed
Oracle 11
By: Member2014 on Thu, 04 August 2016
8 343 Fri, 05 August 2016 08:41
By: Member2014
  Regular expression search
By: saipradyumn on Fri, 05 August 2016
2 211 Fri, 05 August 2016 07:58
By: Solomon Yakobson
  Count group data
12.1.0.2
By: bdtran on Sat, 02 July 2016
21 1704 Wed, 03 August 2016 23:44
By: bdtran
  Make use of UNUSABLE_INDEX by uisnh HInt
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: saipradyumn on Wed, 27 July 2016
4 317 Wed, 03 August 2016 13:37
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 30 02:25:20 CDT 2016

Total time taken to generate the page: 0.13132 seconds