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 prevent trigger from firing on failed insert
Oracle 8,2
By: laddg on Fri, 24 June 2016
13 670 Sat, 25 June 2016 07:02
By: EdStevens
icon4.gif Table update through nested loop issue in function
By: nitesh.erp@gmail.com on Thu, 23 June 2016
15 447 Thu, 23 June 2016 09:28
By: nitesh.erp@gmail.com
  Analytic Report query
Oracle 11g
By: srinivas.k2005 on Thu, 23 June 2016
2 331 Thu, 23 June 2016 08:18
By: srinivas.k2005
  ORA-29278: SMTP transient error: 421 Service not available
By: musman on Tue, 06 May 2008
29 25450 Thu, 23 June 2016 08:12
By: BlackSwan
  Need Help to convert rows into column
Oracle 11g
By: chintan.patel on Tue, 21 June 2016
12 3150 Thu, 23 June 2016 03:50
By: Michel Cadot
  Better query
Oracle 11
By: iliyan_84@abv.bg on Wed, 22 June 2016
2 355 Thu, 23 June 2016 02:56
By: Roachcoach
  how to get one week historical query for v$SQL
By: royalyogi on Tue, 21 June 2016
4 378 Wed, 22 June 2016 06:34
By: EdStevens
  A Query for Seating Arrangement
By: javed.khan on Tue, 21 June 2016
5 3167 Wed, 22 June 2016 00:43
By: Michel Cadot
icon7.gif Update 7% basic Salary
SQL Plus 8.0 ( 1 2)
By: Salehin on Wed, 11 May 2016
44 1868 Mon, 20 June 2016 22:05
By: Salehin
  SQL to filter redundant key field
Oracle 9.2 on Solaris
By: raghx on Mon, 20 June 2016
2 289 Mon, 20 June 2016 19:34
By: Barbara Boehmer
  how to export the data from table to the file
oracle 11g
By: tolupuluri on Mon, 20 June 2016
4 335 Mon, 20 June 2016 15:31
By: tolupuluri
  Aggregate based on serial number after checking for thresholds
By: ketangarg86 on Mon, 20 June 2016
3 264 Mon, 20 June 2016 13:06
By: Michel Cadot
  Exception Handling
oracle 11g
By: Satheesh.A on Mon, 20 June 2016
4 381 Mon, 20 June 2016 03:01
By: cookiemonster
  LAG function
10g, win8.1
By: rzkhan on Sat, 18 June 2016
3 404 Sat, 18 June 2016 02:30
By: Michel Cadot
  connect and level
sql developer
By: nath123 on Fri, 17 June 2016
1 315 Fri, 17 June 2016 15:10
By: Solomon Yakobson
  What is the use of %ROWTYPE and %TYPE in PL/SQL?
By: abhik143 on Fri, 17 June 2016
2 411 Fri, 17 June 2016 02:13
By: Frank Naude
  Query table with multi part column names
11g
By: bobghw on Thu, 16 June 2016
6 329 Thu, 16 June 2016 15:21
By: Bill B
  Calculating values from two different tables by using SQL command.
Oracle 11g ver 11.2.0.1.0
By: faisal78 on Thu, 16 June 2016
5 350 Thu, 16 June 2016 08:39
By: Bill B
  Removing specific line from file using UTL_FILE
11g
By: harshadsp on Tue, 14 June 2016
6 511 Thu, 16 June 2016 02:33
By: harshadsp
  TO_NUMBER function not working
By: richard_oak on Wed, 15 June 2016
2 334 Wed, 15 June 2016 17:56
By: richard_oak
  "ORA-22813: operand value exceeds system limits" on executing sql returning XMLTYPE data
Oracle 11g
By: Nikita_01 on Tue, 14 June 2016
12 793 Wed, 15 June 2016 13:01
By: Michel Cadot
  What is wrong with this sql code?
By: anticristo on Tue, 14 June 2016
3 446 Wed, 15 June 2016 07:34
By: EdStevens
  regexp replace
Oracle 11g, Win 7
By: rajivn786 on Tue, 14 June 2016
9 426 Tue, 14 June 2016 15:55
By: Bill B
  External Table and Blank spaces
Oracle 12C Windows NT
By: pstanand on Mon, 13 June 2016
14 7709 Tue, 14 June 2016 11:01
By: Michel Cadot
  order of geting value from sequence by trigger
Oracle 11g
By: miodas007 on Wed, 01 June 2016
6 3867 Mon, 13 June 2016 09:58
By: Bill B
icon5.gif Extract the most data after joining 3 tables
Oracle SQL
By: misy on Sat, 11 June 2016
8 546 Sat, 11 June 2016 16:47
By: Barbara Boehmer
  Query that gives many different values
By: Jdevil on Fri, 20 May 2016
22 1233 Sat, 11 June 2016 10:43
By: EdStevens
  error 04063 creating view
By: loginel on Fri, 10 June 2016
3 417 Fri, 10 June 2016 17:31
By: Barbara Boehmer
icon5.gif Listing individual average price
Oracle SQL
By: misy on Thu, 09 June 2016
3 382 Fri, 10 June 2016 12:00
By: misy
  Query Date Ranges with select statement (merged 3)
Oracle SQL
By: basitfaazal on Tue, 07 June 2016
12 683 Fri, 10 June 2016 08:36
By: Bill B
  RAISE_APPLICATION_ERROR to display multiple line
11g
By: harshadsp on Fri, 10 June 2016
1 262 Fri, 10 June 2016 08:35
By: Bill B
  Oracle Special character while dbms_output
11g
By: harshadsp on Thu, 09 June 2016
16 698 Fri, 10 June 2016 03:29
By: harshadsp
  Rebuild table contain partition
Oracle database 10g
By: dophuong_cs on Wed, 08 June 2016
3 402 Thu, 09 June 2016 01:01
By: Michel Cadot
  How To Update Encrypted Password for all user id's using Update Query
Oracle 11
By: ramraju20000 on Tue, 07 June 2016
13 533 Wed, 08 June 2016 18:30
By: Solomon Yakobson
  Read/write files from remote server using utl_file in oracle
oracle 11g
By: tolupuluri on Wed, 08 June 2016
3 417 Wed, 08 June 2016 09:52
By: tolupuluri
  behaviour of to_timestamp and time zones
Win10, Oracle 12c
By: GusGF on Mon, 06 June 2016
5 473 Wed, 08 June 2016 04:47
By: GusGF
  Collections in plsql - syntax
Oracle 11.2.0.4.0
By: adfnewbie on Mon, 06 June 2016
5 407 Tue, 07 June 2016 11:46
By: adfnewbie
  Number to words
pl sql
By: raghuramgupta on Tue, 07 June 2016
5 312 Tue, 07 June 2016 11:35
By: Bill B
  union all and sql*plus
By: Eugene on Thu, 26 December 2002
8 10408 Tue, 07 June 2016 06:38
By: EdStevens
  Convert Rows to Columns
Oracle 11g
By: arifs3738 on Sun, 05 June 2016
9 462 Mon, 06 June 2016 08:21
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 Dec 10 01:12:47 CST 2016

Total time taken to generate the page: 0.08836 seconds