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
  GET EXACT STRING MATCH
By: kumar.chevva on Tue, 18 November 2014
10 472 Wed, 19 November 2014 11:49
By: Michel Cadot
  how to use analytical function
By: mist598 on Tue, 18 November 2014
6 281 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 232 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 369 Wed, 19 November 2014 02:40
By: cookiemonster
  To use LIKE in dynamic SQL
By: gopal.biswal on Tue, 18 November 2014
6 351 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 246 Tue, 18 November 2014 12:15
By: Michel Cadot
  please help me in query...
By: hahaie on Tue, 18 November 2014
8 337 Tue, 18 November 2014 06:07
By: Michel Cadot
  Deferred transaction
Oracle 11g R2
By: sunil.rajak on Tue, 18 November 2014
7 232 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 274 Tue, 18 November 2014 02:14
By: Michel Cadot
  fetch data based on Column
Oracle 11g
By: thelearner on Mon, 17 November 2014
7 202 Mon, 17 November 2014 11:00
By: Solomon Yakobson
  date function
By: dineshchowdary532 on Mon, 17 November 2014
2 124 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 338 Mon, 17 November 2014 07:51
By: Michel Cadot
  Date comparison
Oracle 10.2.0.3
By: pointers on Mon, 17 November 2014
3 197 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 225 Sun, 16 November 2014 06:33
By: Solomon Yakobson
  Calling Web Service using UTL_DBWS
By: RAY_HT on Fri, 14 November 2014
2 219 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 256 Sat, 15 November 2014 06:25
By: John Watson
  Week in where clause
By: Omother on Wed, 12 November 2014
27 510 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 306 Fri, 14 November 2014 09:37
By: dariyoosh
  Procedure in oracle
By: sanodani on Thu, 13 November 2014
2 267 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 467 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 297 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 401 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 252 Wed, 12 November 2014 22:12
By: kumar0828
  sql
sql
By: sanodani on Wed, 12 November 2014
12 230 Wed, 12 November 2014 14:26
By: sanodani
  Need Backup of Objects
11g
By: AsthanaP on Wed, 12 November 2014
1 151 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 312 Wed, 12 November 2014 06:54
By: Michel Cadot
  Exporting multiline feeds to a single line in Oracle 8i
Oracle 8i,Unix/Solaris
By: jois on Tue, 11 November 2014
4 157 Wed, 12 November 2014 00:37
By: Michel Cadot
  ORA-01031: insufficient privileges
Oracle Database 11g Release 11.2.0.1.0 - Production
By: mokarem on Tue, 11 November 2014
6 209 Wed, 12 November 2014 00:17
By: mokarem
  Conditional INSERT
11g
By: shree_z on Mon, 10 November 2014
4 220 Tue, 11 November 2014 14:07
By: Bill B
  date validation
date validation
By: sanodani on Tue, 11 November 2014
6 206 Tue, 11 November 2014 13:43
By: sanodani
  Can I call a stored procedure through a select query
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
By: queeny on Mon, 10 November 2014
6 320 Tue, 11 November 2014 13:41
By: cookiemonster
  Long and Clob Problem
win 8,Oracle Forms 6i,Oracle 10g
By: Xandot on Tue, 11 November 2014
6 179 Tue, 11 November 2014 08:56
By: Xandot
  Buffer size error from External table
Oracle Database 11g Release 11.2.0.1.0 - Production
By: mokarem on Mon, 10 November 2014
3 219 Tue, 11 November 2014 00:42
By: Michel Cadot
  Oracle-Should I use temp table or ref cursor
Oracle 11g
By: sormita on Wed, 05 November 2014
5 339 Mon, 10 November 2014 17:12
By: CraigB
  log_table
By: sanodani on Mon, 10 November 2014
10 425 Mon, 10 November 2014 15:49
By: joy_division
  Delayed update to global variable via pipelined function?
Oracle DB 10g 10.2.0.4.0
By: GHott on Mon, 10 November 2014
4 167 Mon, 10 November 2014 15:01
By: GHott
  Pick random rows
11g
By: shree_z on Fri, 07 November 2014
15 350 Mon, 10 November 2014 14:25
By: shree_z
  Regular Expression ( REGEXP) not working with Oracle 10.2.0.4.0
Oracle 10.2.0.4.0
By: nadeemzones on Mon, 10 November 2014
1 163 Mon, 10 November 2014 04:32
By: Michel Cadot
  UTL_HTTP help
Oracle DB 11gR2
By: leeweb on Fri, 07 November 2014
7 273 Mon, 10 November 2014 03:20
By: leeweb
  Distribution of values/data in hash subpartition
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
By: Manoj.Gupta.91 on Fri, 07 November 2014
10 343 Mon, 10 November 2014 02:56
By: John Watson
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: Thu Nov 27 18:49:51 CST 2014

Total time taken to generate the page: 0.24743 seconds