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
  Reference Partitioning
Oracle 11g
By: srinivas.k2005 on Tue, 24 December 2013
22 986 Thu, 26 December 2013 23:20
By: srinivas.k2005
  REGEXP
Oracle 11g r2
By: mokarem on Thu, 19 December 2013
22 1176 Thu, 26 December 2013 21:31
By: mokarem
  How to Create Packages and Procedures to automatically drop table indexes
By: mist598 on Thu, 26 December 2013
13 601 Thu, 26 December 2013 07:34
By: Solomon Yakobson
  get row counts of tables in schema without using dba_tables.num_rows
Oracle 10g
By: jxh461 on Mon, 09 August 2010
15 3348 Tue, 24 December 2013 04:59
By: Michel Cadot
  Find no. of times column value modified
TOAD - 11g
By: dhivyak on Tue, 24 December 2013
13 631 Tue, 24 December 2013 04:42
By: Michel Cadot
  How to restrict the rows while generating XML
Oracle 11g
By: ajaykumarkona on Tue, 24 December 2013
1 260 Tue, 24 December 2013 03:46
By: Michel Cadot
  ORA-00932: inconsistent datatypes: expected NUMBER got -
11g,11.1.0.6.0,window7
By: vinaykumarora on Mon, 23 December 2013
1 309 Tue, 24 December 2013 00:48
By: Littlefoot
  Delete primary key in case of parent-child relation
Windows XP, Oracle 9i
By: dark_prince on Mon, 23 December 2013
2 294 Tue, 24 December 2013 00:21
By: dark_prince
  please sole it
By: lavkumar78 on Mon, 23 December 2013
3 244 Mon, 23 December 2013 23:47
By: Lalit Kumar B
  Select clause issue
By: vssunil86 on Mon, 23 December 2013
2 325 Mon, 23 December 2013 23:09
By: vssunil86
  Pass variable value in input XML for calling webservice
By: sur_7887 on Mon, 23 December 2013
1 237 Mon, 23 December 2013 09:33
By: BlackSwan
  Explain below query
By: mist598 on Mon, 23 December 2013
2 255 Mon, 23 December 2013 06:39
By: mist598
  Adding column to the table is taking long time
oracle 10g , solaris
By: prejib on Fri, 20 December 2013
15 818 Mon, 23 December 2013 06:13
By: pointers
  getting error on enabling constraints even using novalidate clause
Oracle ,10g,windows 7
By: evivek on Sat, 21 December 2013
10 700 Mon, 23 December 2013 03:25
By: Lalit Kumar B
icon3.gif Help required to understand sys refcursor
Oracle 10g 10.2.0.4.0, Linux
By: harpreetsinghkup on Fri, 20 December 2013
3 297 Fri, 20 December 2013 13:34
By: Solomon Yakobson
  sequel help to reference a different database on the same server
By: rkaria on Fri, 20 December 2013
5 427 Fri, 20 December 2013 10:57
By: Michel Cadot
  count according to headlines
10G
By: sequel on Fri, 20 December 2013
3 388 Fri, 20 December 2013 10:51
By: Michel Cadot
  Object Reference Identnifications
By: ORAGENASHOK on Wed, 18 December 2013
10 527 Fri, 20 December 2013 10:16
By: Michel Cadot
  Partitioning of tables
Oracle 11g
By: srinivas.k2005 on Fri, 20 December 2013
1 408 Fri, 20 December 2013 09:35
By: John Watson
  delete record from table
By: haider_1pk on Thu, 12 December 2013
11 629 Fri, 20 December 2013 07:00
By: Solomon Yakobson
  MAX value of column
Oracle 10g
By: m.abdulhaq on Mon, 16 December 2013
15 897 Fri, 20 December 2013 05:16
By: cookiemonster
  Making a single query
Oracle 10g
By: sss111ind on Fri, 13 December 2013
15 869 Fri, 20 December 2013 03:47
By: pablolee
  Normalization
11.0.2
By: pratik4891 on Tue, 10 December 2013
23 909 Thu, 19 December 2013 09:16
By: Michel Cadot
  Oracle Aggregation Problem in join between tables
Oracle 9i,Windows 2003
By: rajamohankumar on Thu, 19 December 2013
10 747 Thu, 19 December 2013 06:22
By: rajamohankumar
  how to allow a user to view roles on a DB
Oracle 11.2.0.3 Enterprise
By: rcct on Fri, 13 December 2013
12 606 Wed, 18 December 2013 13:45
By: Solomon Yakobson
  insert into
By: nataliafoster26 on Tue, 17 December 2013
9 888 Wed, 18 December 2013 11:28
By: BlackSwan
  update sql script
11g2
By: anncao on Mon, 16 December 2013
17 749 Wed, 18 December 2013 04:25
By: flyboy
  LAG & LEAD Question
10g
By: venky83 on Sun, 15 December 2013
4 484 Wed, 18 December 2013 04:08
By: tigsav
  Problem in SQL report
Oracle 9i R2
By: devesh5683 on Wed, 18 December 2013
7 384 Wed, 18 December 2013 04:06
By: cookiemonster
  Select query given ORA-01722 error message
ora 11g
By: Tlg13team on Mon, 16 December 2013
3 314 Wed, 18 December 2013 02:44
By: Maaher
  How to add and multiply values in columns
APEX 4.2
By: brijeshgupta on Tue, 17 December 2013
2 366 Tue, 17 December 2013 14:58
By: Michel Cadot
icon5.gif help me please to migrate from MS SQL to Oracle
Oracle 11.2.0.2.0
By: ecivgamer on Tue, 17 December 2013
15 594 Tue, 17 December 2013 06:19
By: mokarem
  update the date column
11g
By: kekanap on Tue, 17 December 2013
6 452 Tue, 17 December 2013 05:13
By: pablolee
  Not getting head or tails
Oracle R12;PL/SQL;SQL Developer
By: megamind on Tue, 10 December 2013
12 765 Tue, 17 December 2013 04:41
By: John Watson
  how to get last week end date ?
By: malli123 on Mon, 16 December 2013
7 531 Mon, 16 December 2013 14:47
By: Bill B
  Get ovelap
Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro
By: shumail on Mon, 16 December 2013
4 376 Mon, 16 December 2013 14:25
By: shumail
  Materialized View on Remote DB
Oracle 11g Release2
By: feroze on Mon, 09 December 2013
5 422 Mon, 16 December 2013 11:56
By: feroze
  Right Outer Join - ORA-01719
Oracle 10.2.0.5
By: praveenramaswamy on Mon, 16 December 2013
5 486 Mon, 16 December 2013 11:53
By: Michel Cadot
  PLS-00103: Encountered the symbol "end-of-file" ...
By: krishnapb66 on Mon, 16 December 2013
1 260 Mon, 16 December 2013 10:00
By: BlackSwan
  ORA-20120:ORA-01405:fetched column value is null
toad
By: sravanim on Fri, 13 December 2013
3 393 Fri, 13 December 2013 10:10
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: Sun Apr 20 12:12:37 CDT 2014

Total time taken to generate the page: 0.10714 seconds