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
  Announcement: How to use [code] tags and make your code easier to read?
Other people will appreciate it
By: Littlefoot on Mon, 05 September 2011
0 47434 Mon, 05 September 2011 02:20
By: Littlefoot
  dbms_scheduler
10g
By: m.abdulhaq on Fri, 29 May 2015
11 194 Sat, 30 May 2015 03:14
By: Michel Cadot
Bulk updates on a table for updating IDing a sequence to a table has been moved to Server Utilities by the moderator.
  Identify bottlenecks in queries
Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro
By: shumail on Sun, 24 May 2015
13 590 Fri, 29 May 2015 11:10
By: shumail
  better query other than multiple for loop's?
By: mist598 on Fri, 29 May 2015
8 295 Fri, 29 May 2015 09:43
By: BlackSwan
  Duplicate Data
Oracle 11g
By: plsql_guy on Sat, 23 May 2015
33 1085 Fri, 29 May 2015 01:59
By: Michel Cadot
  Increasing Initrans for Partitioned table without re-creating it
Oracle 11g (11.2.0.4)
By: venkatesh_b on Wed, 27 May 2015
11 441 Thu, 28 May 2015 14:50
By: BlackSwan
  Displaying calculated field with selected rows and Adding row according to date condition
11.2.0.1.0
By: OraFerro on Thu, 28 May 2015
4 249 Thu, 28 May 2015 06:37
By: OraFerro
  Interview questions
By: purnima1 on Mon, 25 May 2015
8 616 Thu, 28 May 2015 01:25
By: Michel Cadot
  Procedure is taking more time to execute
oracle 10g windows 7
By: nayana08 on Thu, 21 May 2015
22 641 Tue, 26 May 2015 14:01
By: John Watson
  Problem with calculating hours
oracle sql 10g
By: ifti6650 on Mon, 25 May 2015
9 314 Mon, 25 May 2015 10:13
By: BlackSwan
  Need Help on query
oracle 10g
By: samyms on Sun, 10 May 2015
9 475 Fri, 22 May 2015 08:19
By: BlackSwan
  Recursive Hierarchy Help
By: kiekar on Thu, 21 May 2015
1 212 Thu, 21 May 2015 20:37
By: BlackSwan
  Select max date in row of columns. . .
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: fluffycone on Thu, 21 May 2015
5 236 Thu, 21 May 2015 14:01
By: EdStevens
  string aggregation
oracle 11g
By: patneel on Thu, 21 May 2015
2 179 Thu, 21 May 2015 12:47
By: Michel Cadot
  date Format error
sql oracle
By: palpali on Thu, 21 May 2015
9 224 Thu, 21 May 2015 09:13
By: Bill B
  Error in execution of Trigger
oracle 10g
By: jgjeetu on Thu, 21 May 2015
11 265 Thu, 21 May 2015 08:49
By: Bill B
  does any one use oracle v12?
oracle v12
By: LargeHadronCollider on Thu, 21 May 2015
13 295 Thu, 21 May 2015 07:26
By: LargeHadronCollider
  Error using INTO clause in execute immediate
oracle 10g
By: jgjeetu on Thu, 21 May 2015
4 195 Thu, 21 May 2015 05:12
By: jgjeetu
  DELETING of RECORDS simultaneously.
By: saipavan.plsql on Wed, 20 May 2015
6 305 Thu, 21 May 2015 03:41
By: naga.oracle
  Date validation
11g
By: rohit_shinez on Sat, 16 May 2015
9 490 Wed, 20 May 2015 07:23
By: Lalit Kumar B
  Row length of table in Oracle
By: irfankundi786@yahoo.com on Mon, 18 May 2015
24 530 Wed, 20 May 2015 05:21
By: Michel Cadot
  ERROR-ORA-06533: Subscript beyond count
By: ritubhayana on Wed, 20 May 2015
2 207 Wed, 20 May 2015 03:28
By: Michel Cadot
  Round Robin implementaion through sql script
Oracle 10g
By: virmahi on Thu, 19 August 2010
22 3261 Wed, 20 May 2015 02:51
By: cookiemonster
  Subquery with multiple rows
oracle db 10g
By: aruntutor on Tue, 19 May 2015
3 271 Wed, 20 May 2015 01:00
By: flyboy
  Dirty read issues
By: raj_te on Fri, 15 May 2015
7 468 Tue, 19 May 2015 08:04
By: Bill B
  what is the difference between "generated always as" and "as" at the time of creating virtual column
oracle 11g
By: jgjeetu on Tue, 19 May 2015
3 207 Tue, 19 May 2015 06:17
By: Lalit Kumar B
  regexp_replace comma separated whole string
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Mon, 18 May 2015
10 274 Mon, 18 May 2015 14:58
By: manubatham20
icon5.gif Asp.Net Application hangs until oracle package is recompiled
Oracle Database 11g Release 11.2.0.1.0 64bit CentOS 6.5
By: praveenpraj on Tue, 27 January 2015
8 785 Mon, 18 May 2015 03:40
By: praveenpraj
  Procedure creation error - PLS-00103
Oracle 11.2.0.3, Linux x86 64
By: hitesh.bhatt on Mon, 18 May 2015
6 242 Mon, 18 May 2015 03:00
By: Lalit Kumar B
icon6.gif vpd condition with joins in DataWarehouse
oracle 11g
By: Droryash on Thu, 14 May 2015
6 360 Mon, 18 May 2015 00:55
By: Droryash
  Calculation of Day, month and year
Oracle 11g, Window 7
By: Bilal Khan on Fri, 15 May 2015
6 399 Sun, 17 May 2015 13:41
By: Barbara Boehmer
  Format check on varchar check!!
Oracle 11g
By: kaltiimaar on Sun, 17 May 2015
15 347 Sun, 17 May 2015 09:55
By: Michel Cadot
  Inserting records in Table using cursor
Oracle 11g ( 1 2)
By: rohit_shinez on Sun, 10 May 2015
41 1209 Sat, 16 May 2015 08:13
By: BlackSwan
  Row level lock after updation
windows 7,oracle 10g, form builder 10g
By: hcdba on Fri, 15 May 2015
8 277 Fri, 15 May 2015 09:12
By: Lalit Kumar B
  Select best 2 value out of 3 three values
Oracle 11g, Window 7
By: Bilal Khan on Thu, 14 May 2015
5 269 Fri, 15 May 2015 01:54
By: Bilal Khan
  replace number in column
By: hassan08 on Wed, 13 May 2015
6 300 Thu, 14 May 2015 11:39
By: Michel Cadot
  Viewing Object values in select and fill (multiple rows)
11.2.0.1.0
By: OraFerro on Thu, 14 May 2015
4 244 Thu, 14 May 2015 11:36
By: Michel Cadot
  dbms_scheduler -WeekDays scheduling program.
Oracle 11g, Windows
By: vicktorz on Thu, 14 May 2015
2 161 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 204 Thu, 14 May 2015 07:35
By: jgjeetu
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 30 08:09:15 CDT 2015

Total time taken to generate the page: 0.12977 seconds