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 2898 Mon, 05 September 2011 02:20
By: Littlefoot
  column with data_type CLOB does not appear in user_ind_columns, why?
By: gunderj on Sat, 25 June 2016
7 258 Sat, 25 June 2016 10:57
By: Michel Cadot
  How to prevent trigger from firing on failed insert
Oracle 8,2
By: laddg on Fri, 24 June 2016
13 405 Sat, 25 June 2016 07:02
By: EdStevens
  Help Creating a Trigger for Reoccuring Events
Oracle 12c
By: mattfriend on Thu, 23 June 2016
5 384 Sat, 25 June 2016 05:19
By: Solomon Yakobson
Oracle temp_space_header: parameter not set has been moved to Linux by the moderator.
icon4.gif Table update through nested loop issue in function
By: nitesh.erp@gmail.com on Thu, 23 June 2016
15 266 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 193 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 22278 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 2930 Thu, 23 June 2016 03:50
By: Michel Cadot
  Better query
Oracle 11
By: iliyan_84@abv.bg on Wed, 22 June 2016
2 177 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 234 Wed, 22 June 2016 06:34
By: EdStevens
  A Query for Seating Arrangement
By: javed.khan on Tue, 21 June 2016
5 2984 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 1654 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 138 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 170 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 146 Mon, 20 June 2016 13:06
By: Michel Cadot
  Exception Handling
oracle 11g
By: Satheesh.A on Mon, 20 June 2016
4 200 Mon, 20 June 2016 03:01
By: cookiemonster
  LAG function
10g, win8.1
By: rzkhan on Sat, 18 June 2016
3 214 Sat, 18 June 2016 02:30
By: Michel Cadot
  connect and level
sql developer
By: nath123 on Fri, 17 June 2016
1 195 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 267 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 218 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 231 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 361 Thu, 16 June 2016 02:33
By: harshadsp
  TO_NUMBER function not working
By: richard_oak on Wed, 15 June 2016
2 207 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 418 Wed, 15 June 2016 13:01
By: Michel Cadot
  What is wrong with this sql code?
By: anticristo on Tue, 14 June 2016
3 291 Wed, 15 June 2016 07:34
By: EdStevens
  regexp replace
Oracle 11g, Win 7
By: rajivn786 on Tue, 14 June 2016
9 253 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 7578 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 3730 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 417 Sat, 11 June 2016 16:47
By: Barbara Boehmer
  Query that gives many different values
By: Jdevil on Fri, 20 May 2016
22 1057 Sat, 11 June 2016 10:43
By: EdStevens
  error 04063 creating view
By: loginel on Fri, 10 June 2016
3 306 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 294 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 509 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 171 Fri, 10 June 2016 08:35
By: Bill B
  Oracle Special character while dbms_output
11g
By: harshadsp on Thu, 09 June 2016
16 529 Fri, 10 June 2016 03:29
By: harshadsp
  Rebuild table contain partition
Oracle database 10g
By: dophuong_cs on Wed, 08 June 2016
3 284 Thu, 09 June 2016 01:01
By: Michel Cadot
  Set a range into in time
Forms,
By: Salehin on Tue, 07 June 2016
20 759 Thu, 09 June 2016 00:03
By: Littlefoot
  How To Update Encrypted Password for all user id's using Update Query
Oracle 11
By: ramraju20000 on Tue, 07 June 2016
13 422 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 207 Wed, 08 June 2016 09:52
By: tolupuluri
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: Sun Jun 26 23:27:28 CDT 2016

Total time taken to generate the page: 0.07256 seconds