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 42184 Mon, 05 September 2011 02:20
By: Littlefoot
  INSERT with subquery in VALUES
By: aliyesami on Sun, 23 November 2014
10 261 Mon, 24 November 2014 15:43
By: Littlefoot
  json data
By: nisjess on Mon, 24 November 2014
1 45 Mon, 24 November 2014 15:24
By: BlackSwan
  Perhaps a stupid query
11.2.0.3
By: Amine on Mon, 24 November 2014
5 124 Mon, 24 November 2014 14:26
By: Michel Cadot
  divisor is equal to zero error
Oracle 11g
By: kkeebler on Mon, 24 November 2014
2 67 Mon, 24 November 2014 13:33
By: Michel Cadot
  PL/SQL email config
By: slemma on Wed, 19 November 2014
5 196 Mon, 24 November 2014 13:16
By: Michel Cadot
  Sql Satement print list of string
11.2.0.3,Linux X86_64
By: preet_kumar on Mon, 24 November 2014
6 124 Mon, 24 November 2014 08:23
By: John Watson
Only values a select-result has been moved to Client Tools by the moderator.
Testing in SQL Developer has been moved to Client Tools by the moderator.
Oracle and SQLServer DB Link has been moved to Networking and Gateways by the moderator.
  Oracle Regular Expression
Oracle 10g
By: infosuresh2k on Wed, 19 November 2014
6 435 Sun, 23 November 2014 14:12
By: Solomon Yakobson
  "too many declarations of 'SUBSTR' match this call" while refreshing Materialized view
Oracle 11.1.0.7
By: kskarun on Thu, 20 November 2014
6 375 Sun, 23 November 2014 13:08
By: Solomon Yakobson
  oracle xml
oracle 10.2.0.3
By: pointers on Sat, 22 November 2014
3 154 Sat, 22 November 2014 10:15
By: Michel Cadot
  Sql querry for count
By: asbh123 on Thu, 20 November 2014
11 310 Fri, 21 November 2014 19:44
By: Solomon Yakobson
  Convert Columns to rows
win 8,Oracle 10g
By: Xandot on Thu, 20 November 2014
5 345 Fri, 21 November 2014 05:55
By: Xandot
  column names are row values from another table.
11g
By: shree_z on Thu, 20 November 2014
8 227 Thu, 20 November 2014 16:01
By: BlackSwan
  retrieving previous status code
oracle sql
By: silver_fox on Thu, 20 November 2014
2 186 Thu, 20 November 2014 09:20
By: Michel Cadot
  Pattern Marching using regexp
UNIX, Oracle 11g
By: a_oracle on Thu, 20 November 2014
5 205 Thu, 20 November 2014 05:05
By: Michel Cadot
  materialized view log size doesn't correlate with its rows quantity
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
By: ecivgamer on Wed, 19 November 2014
4 182 Wed, 19 November 2014 13:20
By: ecivgamer
  GET EXACT STRING MATCH
By: kumar.chevva on Tue, 18 November 2014
10 454 Wed, 19 November 2014 11:49
By: Michel Cadot
  how to use analytical function
By: mist598 on Tue, 18 November 2014
6 271 Wed, 19 November 2014 09:47
By: Michel Cadot
  how to get the previous value in the loop into, 2 separate variable without overwriting
By: venki459 on Mon, 17 November 2014
4 215 Wed, 19 November 2014 09:22
By: sandeep_orafaq
  execution time
By: nisjess on Wed, 19 November 2014
3 189 Wed, 19 November 2014 09:10
By: Lalit Kumar B
  Inner Loop Stops Iterating through the cursor's values
Oracle XE 11g 11.2.0 Windows 7, Oracle SQL Dev 4.0.3.16
By: weather on Mon, 17 November 2014
4 360 Wed, 19 November 2014 02:40
By: cookiemonster
  To use LIKE in dynamic SQL
By: gopal.biswal on Tue, 18 November 2014
6 336 Wed, 19 November 2014 01:26
By: gopal.biswal
icon7.gif Update Statement with multiple joins
Oracle 12c, Windows 8.1 x64
By: SunilJdh on Tue, 18 November 2014
4 216 Wed, 19 November 2014 00:53
By: Michel Cadot
icon5.gif error when trying to refresh materialized view
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
By: ecivgamer on Tue, 18 November 2014
7 231 Tue, 18 November 2014 12:15
By: Michel Cadot
  please help me in query...
By: hahaie on Tue, 18 November 2014
8 318 Tue, 18 November 2014 06:07
By: Michel Cadot
  Deferred transaction
Oracle 11g R2
By: sunil.rajak on Tue, 18 November 2014
7 219 Tue, 18 November 2014 04:26
By: John Watson
  compile package - select V$MVREFRESH without user's rights
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
By: ecivgamer on Mon, 17 November 2014
12 264 Tue, 18 November 2014 02:14
By: Michel Cadot
  fetch data based on Column
Oracle 11g
By: thelearner on Mon, 17 November 2014
7 195 Mon, 17 November 2014 11:00
By: Solomon Yakobson
  date function
By: dineshchowdary532 on Mon, 17 November 2014
2 117 Mon, 17 November 2014 08:53
By: BlackSwan
  how to find record with all 0 values records
By: mmi78 on Mon, 17 November 2014
22 330 Mon, 17 November 2014 07:51
By: Michel Cadot
  Date comparison
Oracle 10.2.0.3
By: pointers on Mon, 17 November 2014
3 190 Mon, 17 November 2014 05:10
By: Michel Cadot
  Error encountered while deleting a record with foreign key relationship.
Oracle 10G
By: Asfakul on Sun, 16 November 2014
6 218 Sun, 16 November 2014 06:33
By: Solomon Yakobson
  Calling Web Service using UTL_DBWS
By: RAY_HT on Fri, 14 November 2014
2 208 Sat, 15 November 2014 07:00
By: RAY_HT
  Sync master and local database
Oracle 11g R2, windows
By: sunil.rajak on Fri, 14 November 2014
6 250 Sat, 15 November 2014 06:25
By: John Watson
  Week in where clause
By: Omother on Wed, 12 November 2014
27 500 Sat, 15 November 2014 00:40
By: Michel Cadot
icon5.gif Question about tracing Web Applications SQL statements by using oracle AUDIT command
By: dariyoosh on Fri, 07 November 2014
4 302 Fri, 14 November 2014 09:37
By: dariyoosh
  Procedure in oracle
By: sanodani on Thu, 13 November 2014
2 257 Fri, 14 November 2014 01:13
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: Mon Nov 24 15:48:11 CST 2014

Total time taken to generate the page: 0.13340 seconds