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
  OUTPUT Of SYS_REFCURSOR
oracle 11g Release 2
By: azeem87 on Wed, 26 November 2014
3 223 Wed, 26 November 2014 16:32
By: azeem87
  Fulfill the width with different combination
10g
By: ashokb21 on Wed, 26 November 2014
4 239 Wed, 26 November 2014 14:47
By: Solomon Yakobson
  Updating missing values
Oracle 11g
By: ramya_162 on Tue, 25 November 2014
11 409 Wed, 26 November 2014 06:58
By: cookiemonster
icon7.gif Update Statement with multiple joins
Oracle 12c, Windows 8.1 x64
By: SunilJdh on Tue, 18 November 2014
5 422 Wed, 26 November 2014 01:42
By: SunilJdh
  Need data from table but there is multiple conditions
oracle 11g
By: deepak416 on Tue, 25 November 2014
7 257 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 279 Tue, 25 November 2014 13:36
By: joy_division
  Merge materialized views
oracle 11
By: JamesxxFord on Tue, 25 November 2014
4 261 Tue, 25 November 2014 10:36
By: gazzag
  materialized view on prebuilt table - refresh
By: ecivgamer on Tue, 25 November 2014
4 283 Tue, 25 November 2014 09:05
By: ecivgamer
  execution time
By: nisjess on Wed, 19 November 2014
6 452 Tue, 25 November 2014 08:19
By: Michel Cadot
  Quering Access DB.Table
11 g
By: annu-agi on Tue, 25 November 2014
3 228 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 254 Tue, 25 November 2014 04:07
By: Michel Cadot
  index
oracle 11g
By: Ashish_chand on Tue, 25 November 2014
3 225 Tue, 25 November 2014 04:03
By: Michel Cadot
  json data
By: nisjess on Mon, 24 November 2014
2 287 Tue, 25 November 2014 00:11
By: Michel Cadot
  INSERT with subquery in VALUES
By: aliyesami on Sun, 23 November 2014
11 498 Mon, 24 November 2014 17:31
By: BlackSwan
  PL/SQL email config
By: slemma on Wed, 19 November 2014
6 414 Mon, 24 November 2014 17:03
By: slemma
  divisor is equal to zero error
Oracle 11g
By: kkeebler on Mon, 24 November 2014
2 291 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 274 Mon, 24 November 2014 08:23
By: John Watson
  Oracle Regular Expression
Oracle 10g
By: infosuresh2k on Wed, 19 November 2014
6 653 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 591 Sun, 23 November 2014 13:08
By: Solomon Yakobson
  oracle xml
oracle 10.2.0.3
By: pointers on Sat, 22 November 2014
3 307 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 644 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 418 Thu, 20 November 2014 16:01
By: BlackSwan
  retrieving previous status code
oracle sql
By: silver_fox on Thu, 20 November 2014
2 305 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 299 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 285 Wed, 19 November 2014 13:20
By: ecivgamer
  how to use analytical function
By: mist598 on Tue, 18 November 2014
6 385 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 329 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 597 Wed, 19 November 2014 02:40
By: cookiemonster
  To use LIKE in dynamic SQL
By: gopal.biswal on Tue, 18 November 2014
6 499 Wed, 19 November 2014 01:26
By: gopal.biswal
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 394 Tue, 18 November 2014 12:15
By: Michel Cadot
  please help me in query...
By: hahaie on Tue, 18 November 2014
8 443 Tue, 18 November 2014 06:07
By: Michel Cadot
  Deferred transaction
Oracle 11g R2
By: sunil.rajak on Tue, 18 November 2014
7 396 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 423 Tue, 18 November 2014 02:14
By: Michel Cadot
  fetch data based on Column
Oracle 11g
By: thelearner on Mon, 17 November 2014
7 314 Mon, 17 November 2014 11:00
By: Solomon Yakobson
  how to find record with all 0 values records
By: mmi78 on Mon, 17 November 2014
22 458 Mon, 17 November 2014 07:51
By: Michel Cadot
  Date comparison
Oracle 10.2.0.3
By: pointers on Mon, 17 November 2014
3 331 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 387 Sun, 16 November 2014 06:33
By: Solomon Yakobson
  Calling Web Service using UTL_DBWS
By: RAY_HT on Fri, 14 November 2014
2 452 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 369 Sat, 15 November 2014 06:25
By: John Watson
  Week in where clause
By: Omother on Wed, 12 November 2014
27 675 Sat, 15 November 2014 00:40
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: Tue Mar 31 22:33:24 CDT 2015

Total time taken to generate the page: 0.16053 seconds