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 42234 Mon, 05 September 2011 02:20
By: Littlefoot
  creating view based on availability of data in 2 tables
windows, plsql
By: raja.i on Wed, 26 November 2014
9 133 Wed, 26 November 2014 08:15
By: Lalit Kumar B
Please help me to understand why the query works longer of server_A than on server_B has been moved to Performance Tuning by the moderator.
  Updating missing values
Oracle 11g
By: ramya_162 on Tue, 25 November 2014
11 232 Wed, 26 November 2014 06:58
By: cookiemonster
  Split 1 row into multiple based on date
Oracle 11G
By: sinpeak on Wed, 26 November 2014
5 128 Wed, 26 November 2014 06:24
By: cookiemonster
Trigger to clear then set focus has been moved to Forms by the moderator.
icon7.gif Update Statement with multiple joins
Oracle 12c, Windows 8.1 x64
By: SunilJdh on Tue, 18 November 2014
5 269 Wed, 26 November 2014 01:42
By: SunilJdh
  Fulfill the width with different combination
10g
By: ashokb21 on Wed, 26 November 2014
3 101 Wed, 26 November 2014 01:18
By: Michel Cadot
SP2-0552: Bind variable "V_D" not declared. has been moved to Client Tools by the moderator.
  Need data from table but there is multiple conditions
oracle 11g
By: deepak416 on Tue, 25 November 2014
7 130 Tue, 25 November 2014 13:38
By: Michel Cadot
  INSERT with SELECT ON DISTINCT
oracle 11g Rel2
By: azeem87 on Tue, 25 November 2014
5 125 Tue, 25 November 2014 13:36
By: joy_division
  Merge materialized views
oracle 11
By: JamesxxFord on Tue, 25 November 2014
4 103 Tue, 25 November 2014 10:36
By: gazzag
  materialized view on prebuilt table - refresh
By: ecivgamer on Tue, 25 November 2014
4 110 Tue, 25 November 2014 09:05
By: ecivgamer
  execution time
By: nisjess on Wed, 19 November 2014
6 265 Tue, 25 November 2014 08:19
By: Michel Cadot
  Quering Access DB.Table
11 g
By: annu-agi on Tue, 25 November 2014
3 103 Tue, 25 November 2014 05:30
By: Littlefoot
  Varchar2(4000 bytes) to Varchar2(4000 char) Conversion
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
By: queeny on Tue, 25 November 2014
3 124 Tue, 25 November 2014 04:07
By: Michel Cadot
  index
oracle 11g
By: Ashish_chand on Tue, 25 November 2014
3 125 Tue, 25 November 2014 04:03
By: Michel Cadot
  json data
By: nisjess on Mon, 24 November 2014
2 151 Tue, 25 November 2014 00:11
By: Michel Cadot
  Sql querry for count
By: asbh123 on Thu, 20 November 2014
13 396 Tue, 25 November 2014 00:07
By: Michel Cadot
  INSERT with subquery in VALUES
By: aliyesami on Sun, 23 November 2014
11 331 Mon, 24 November 2014 17:31
By: BlackSwan
  PL/SQL email config
By: slemma on Wed, 19 November 2014
6 243 Mon, 24 November 2014 17:03
By: slemma
  Perhaps a stupid query
11.2.0.3
By: Amine on Mon, 24 November 2014
5 182 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 126 Mon, 24 November 2014 13:33
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 152 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 450 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 389 Sun, 23 November 2014 13:08
By: Solomon Yakobson
  oracle xml
oracle 10.2.0.3
By: pointers on Sat, 22 November 2014
3 171 Sat, 22 November 2014 10:15
By: Michel Cadot
  Convert Columns to rows
win 8,Oracle 10g
By: Xandot on Thu, 20 November 2014
5 359 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 233 Thu, 20 November 2014 16:01
By: BlackSwan
  retrieving previous status code
oracle sql
By: silver_fox on Thu, 20 November 2014
2 198 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 212 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 194 Wed, 19 November 2014 13:20
By: ecivgamer
  GET EXACT STRING MATCH
By: kumar.chevva on Tue, 18 November 2014
10 467 Wed, 19 November 2014 11:49
By: Michel Cadot
  how to use analytical function
By: mist598 on Tue, 18 November 2014
6 278 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 227 Wed, 19 November 2014 09:22
By: sandeep_orafaq
  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 366 Wed, 19 November 2014 02:40
By: cookiemonster
  To use LIKE in dynamic SQL
By: gopal.biswal on Tue, 18 November 2014
6 347 Wed, 19 November 2014 01:26
By: gopal.biswal
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: Wed Nov 26 13:04:59 CST 2014

Total time taken to generate the page: 0.13234 seconds