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
  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 236 Tue, 25 November 2014 04:07
By: Michel Cadot
  index
oracle 11g
By: Ashish_chand on Tue, 25 November 2014
3 213 Tue, 25 November 2014 04:03
By: Michel Cadot
  json data
By: nisjess on Mon, 24 November 2014
2 265 Tue, 25 November 2014 00:11
By: Michel Cadot
  INSERT with subquery in VALUES
By: aliyesami on Sun, 23 November 2014
11 473 Mon, 24 November 2014 17:31
By: BlackSwan
  PL/SQL email config
By: slemma on Wed, 19 November 2014
6 394 Mon, 24 November 2014 17:03
By: slemma
  divisor is equal to zero error
Oracle 11g
By: kkeebler on Mon, 24 November 2014
2 254 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 252 Mon, 24 November 2014 08:23
By: John Watson
  Oracle Regular Expression
Oracle 10g
By: infosuresh2k on Wed, 19 November 2014
6 620 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 561 Sun, 23 November 2014 13:08
By: Solomon Yakobson
  oracle xml
oracle 10.2.0.3
By: pointers on Sat, 22 November 2014
3 279 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 602 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 392 Thu, 20 November 2014 16:01
By: BlackSwan
  retrieving previous status code
oracle sql
By: silver_fox on Thu, 20 November 2014
2 282 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 282 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 266 Wed, 19 November 2014 13:20
By: ecivgamer
  how to use analytical function
By: mist598 on Tue, 18 November 2014
6 363 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 317 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 563 Wed, 19 November 2014 02:40
By: cookiemonster
  To use LIKE in dynamic SQL
By: gopal.biswal on Tue, 18 November 2014
6 472 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 355 Tue, 18 November 2014 12:15
By: Michel Cadot
  please help me in query...
By: hahaie on Tue, 18 November 2014
8 420 Tue, 18 November 2014 06:07
By: Michel Cadot
  Deferred transaction
Oracle 11g R2
By: sunil.rajak on Tue, 18 November 2014
7 367 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 389 Tue, 18 November 2014 02:14
By: Michel Cadot
  fetch data based on Column
Oracle 11g
By: thelearner on Mon, 17 November 2014
7 277 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 426 Mon, 17 November 2014 07:51
By: Michel Cadot
  Date comparison
Oracle 10.2.0.3
By: pointers on Mon, 17 November 2014
3 298 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 352 Sun, 16 November 2014 06:33
By: Solomon Yakobson
  Calling Web Service using UTL_DBWS
By: RAY_HT on Fri, 14 November 2014
2 368 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 343 Sat, 15 November 2014 06:25
By: John Watson
  Week in where clause
By: Omother on Wed, 12 November 2014
27 631 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 462 Fri, 14 November 2014 09:37
By: dariyoosh
  Procedure in oracle
By: sanodani on Thu, 13 November 2014
2 321 Fri, 14 November 2014 01:13
By: Michel Cadot
  sending mail using java in oracle PL/SQL 11g
oracle 11g database
By: m7777G on Sat, 08 November 2014
7 958 Thu, 13 November 2014 09:14
By: Lalit Kumar B
  extract sql statements from trace file in windows environment
windows 07
By: raja.i on Wed, 12 November 2014
14 396 Thu, 13 November 2014 01:44
By: John Watson
  finding the gaps in between the sequences
Oracle 10G
By: SW26477 on Wed, 12 November 2014
18 533 Thu, 13 November 2014 00:51
By: Michel Cadot
  Achieving Report Format in PL/SQL or SQL
Oracle 10g, Windows
By: kumar0828 on Wed, 12 November 2014
10 306 Wed, 12 November 2014 22:12
By: kumar0828
  sql
sql
By: sanodani on Wed, 12 November 2014
12 313 Wed, 12 November 2014 14:26
By: sanodani
  Need Backup of Objects
11g
By: AsthanaP on Wed, 12 November 2014
1 218 Wed, 12 November 2014 08:08
By: cookiemonster
  Handling Big String
Apex 4.0,win8,Oracle 10g
By: Xandot on Wed, 12 November 2014
10 407 Wed, 12 November 2014 06:54
By: Michel Cadot
  Exporting multiline feeds to a single line in Oracle 8i
Oracle 8i,Unix/Solaris
By: Jay1 on Tue, 11 November 2014
4 216 Wed, 12 November 2014 00:37
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: Fri Mar 06 11:41:20 CST 2015

Total time taken to generate the page: 0.06539 seconds