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
  IF is not working right please suggest
By: sahnra on Thu, 14 November 2013
16 934 Fri, 15 November 2013 00:38
By: pablolee
  Use of All with equal (=)
Oracle 10gR1 and upper
By: manubatham20 on Wed, 13 November 2013
12 552 Thu, 14 November 2013 10:42
By: manubatham20
  Date comparison issue
Oracle 10g ( 1 2)
By: chat2raj.s on Thu, 14 November 2013
40 1533 Thu, 14 November 2013 06:41
By: chat2raj.s
  ORA-01031: insufficient privileges error in Oracle
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit
By: subhadip.chanda on Thu, 14 November 2013
9 708 Thu, 14 November 2013 03:38
By: John Watson
  To find all the tables and their columns where the data has changed in a table
oracle 10g
By: novice1 on Wed, 13 November 2013
5 423 Thu, 14 November 2013 02:51
By: novice1
  Query to find users logged in lasttime
oracle 10g
By: krish96 on Wed, 13 November 2013
9 472 Wed, 13 November 2013 14:51
By: John Watson
  The Book Of Null
By: John Watson on Tue, 12 November 2013
6 337 Wed, 13 November 2013 12:58
By: Solomon Yakobson
  Difference between null & Empty string
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: saipradyumn on Tue, 12 November 2013
6 760 Wed, 13 November 2013 12:16
By: John Watson
  Maximum Date
By: sahnra on Wed, 13 November 2013
17 793 Wed, 13 November 2013 08:19
By: Lalit Kumar B
  update
By: nataliafoster26 on Tue, 12 November 2013
13 524 Wed, 13 November 2013 01:13
By: Littlefoot
  Procedure not running and not even throwing any error
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Pr
By: gupta27 on Tue, 12 November 2013
6 282 Tue, 12 November 2013 11:58
By: gupta27
  FORALL Stops when First Errors Occures
Oracle 11g Windows 7
By: mvmkandan on Tue, 12 November 2013
2 223 Tue, 12 November 2013 08:31
By: cookiemonster
  Displaying output of PL/SQL select statement
Oracle 11 g/ Oracle SQL PLus
By: meetsumit03 on Tue, 12 November 2013
5 494 Tue, 12 November 2013 06:10
By: meetsumit03
  parallel_enable aggregate in Pacakged Function
By: mokarem on Tue, 12 November 2013
1 330 Tue, 12 November 2013 04:27
By: Maaher
  Column name starting with numeric value
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: saipradyumn on Tue, 12 November 2013
2 379 Tue, 12 November 2013 02:58
By: saipradyumn
  Need SQL query help
By: ora1979 on Wed, 06 November 2013
4 456 Tue, 12 November 2013 02:00
By: saipradyumn
  Can We Club both Query....? Please Help ..
By: sahnra on Mon, 11 November 2013
8 535 Tue, 12 November 2013 00:37
By: sahnra
  What wroung i am doing In this query Please suggest
By: sahnra on Mon, 11 November 2013
10 642 Tue, 12 November 2013 00:36
By: sahnra
  does a query can use more than one index on table at a time
oracle 10g
By: neerumishra on Mon, 11 November 2013
7 486 Mon, 11 November 2013 15:04
By: rleishman
  Is it possible to get 1st day of the month based on
11
By: cplusplus1 on Mon, 11 November 2013
3 283 Mon, 11 November 2013 13:04
By: joy_division
  check constraint on column
forms 6i
By: sanjlaxmi on Thu, 07 November 2013
19 1115 Sun, 10 November 2013 18:42
By: sanjlaxmi
  validate records in nested table
Oracle DB 11g Enterprise Release 11.2.0.3.0 - 64bit
By: misragopal on Sat, 09 November 2013
15 943 Sun, 10 November 2013 11:58
By: manubatham20
  To get a text after . from a text box
By: techgirl123 on Sun, 10 November 2013
1 274 Sun, 10 November 2013 10:46
By: Littlefoot
icon12.gif Create a procedure inside a function
Pl/sql
By: vinaykumarnaveen on Fri, 08 November 2013
2 348 Sun, 10 November 2013 01:20
By: Lalit Kumar B
  Select distinct
Oracle 10g
By: abhayman on Thu, 07 November 2013
4 453 Sat, 09 November 2013 02:02
By: abhayman
  ORA-01839: date not valid for month specified
Oracle 10g
By: rc3d on Fri, 01 November 2013
10 783 Fri, 08 November 2013 15:17
By: Bill B
  Record vs Object problem
Oracle 11g
By: ageless1946 on Fri, 08 November 2013
3 346 Fri, 08 November 2013 12:40
By: ageless1946
  Dynamic Condition in STATIC SQL
Oracle 11g
By: achockal on Fri, 08 November 2013
3 404 Fri, 08 November 2013 12:18
By: BlackSwan
  Writing to CSV or excel using UTL_FILE in ORACLE
By: nathran on Wed, 06 November 2013
7 740 Fri, 08 November 2013 06:36
By: Solomon Yakobson
  How to count different items with one sentence instead of above?
ORACLE
By: zhaoquer on Mon, 04 November 2013
14 811 Fri, 08 November 2013 02:34
By: cookiemonster
  char to timestamp conversion
10G, unix
By: babhuko on Thu, 07 November 2013
1 198 Thu, 07 November 2013 14:34
By: Solomon Yakobson
  How to allow only numbers where condition substr(Object_id,7,10)
oracle 11
By: cplusplus1 on Thu, 07 November 2013
4 280 Thu, 07 November 2013 08:26
By: Solomon Yakobson
  Use of UPPER function with wild cards
By: newbieinapps on Wed, 06 November 2013
5 337 Thu, 07 November 2013 02:14
By: ThomasG
  ORA-06508: PL/SQL: could not find program unit being called
oracle database 10g
By: njnbat on Tue, 15 October 2013
12 806 Thu, 07 November 2013 00:00
By: njnbat
  what array or collection type to use
oracle 11g
By: gentleman777us on Wed, 06 November 2013
11 580 Wed, 06 November 2013 15:19
By: gentleman777us
  day,month year regex
oracle 10g, unix
By: babhuko on Mon, 04 November 2013
9 626 Tue, 05 November 2013 11:36
By: Solomon Yakobson
  How to update data from backup table
PL/SQL,ORACLE
By: chary12345 on Mon, 04 November 2013
13 952 Tue, 05 November 2013 07:36
By: cookiemonster
  syntax
By: nataliafoster26 on Mon, 04 November 2013
3 316 Tue, 05 November 2013 02:49
By: gazzag
  Transpose and dynamic column depending on result
Oracle 10g
By: rasi_85 on Mon, 04 November 2013
6 434 Mon, 04 November 2013 14:56
By: rasi_85
  hours validation
Oracle 10g,windows 7
By: thelearner on Fri, 01 November 2013
10 1677 Sat, 02 November 2013 11:29
By: Littlefoot
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: Sat Apr 19 21:01:18 CDT 2014

Total time taken to generate the page: 0.17679 seconds