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
  Bind Variables
By: supriya_singh on Mon, 18 August 2014
3 273 Mon, 18 August 2014 07:59
By: Michel Cadot
  Hierarchical Output
Oracle 11g R2
By: javed.khan on Tue, 12 August 2014
9 452 Mon, 18 August 2014 05:24
By: Lalit Kumar B
  Reading the xml value
Oralce 10g
By: sss111ind on Thu, 17 July 2014
21 719 Mon, 18 August 2014 04:28
By: Lalit Kumar B
  Hierarchy output
11.2.0.3.0
By: Amine on Tue, 22 July 2014
18 1178 Mon, 18 August 2014 03:46
By: Lalit Kumar B
  who can create this output?
By: hahaie on Sun, 10 August 2014
11 823 Mon, 18 August 2014 03:34
By: Lalit Kumar B
  What we should use for better function or procedure
By: aaditya321 on Mon, 18 August 2014
8 361 Mon, 18 August 2014 02:51
By: aaditya321
icon5.gif table should allow to insert only one row
Oracle 11.2.0.1.0
By: ecivgamer on Sat, 16 August 2014
11 449 Sat, 16 August 2014 15:33
By: John Watson
  get hour value from sysdate in 24 hour format
Oracle 11.2.0.1.0
By: ecivgamer on Sat, 16 August 2014
4 324 Sat, 16 August 2014 14:30
By: BlackSwan
  get number of week day - no matter what national locale is used
Oracle 11.2.0.1.0
By: ecivgamer on Sat, 16 August 2014
1 211 Sat, 16 August 2014 11:39
By: ecivgamer
  loading table from excel without using util
PL/SQL Release 11.1.0.6.0 - Production
By: rkhatiwala on Fri, 15 August 2014
6 336 Fri, 15 August 2014 12:09
By: Lalit Kumar B
  multiple currency value
oracle 11g
By: dariusd7 on Thu, 14 August 2014
11 585 Fri, 15 August 2014 10:32
By: Michel Cadot
  How to eliminate duplicate rows from a table
oracle 11g
By: dariusd7 on Thu, 14 August 2014
10 511 Thu, 14 August 2014 15:31
By: BlackSwan
  Spool into excel file with different tabs
Oracle PLSQL
By: m5124oracle on Wed, 13 August 2014
6 466 Thu, 14 August 2014 13:38
By: m5124oracle
  Item Validation
oracle 11.g
By: diva_thilak on Wed, 13 August 2014
2 238 Thu, 14 August 2014 13:00
By: diva_thilak
icon2.gif Clustered index on primary key columns
11 G, Linux
By: harpreetsinghkup on Wed, 13 August 2014
3 450 Thu, 14 August 2014 12:02
By: Michel Cadot
  How to Send E-Mail in Oracle(PL-SQL) very urgent please
By: swamy6040 on Wed, 06 August 2014
12 681 Thu, 14 August 2014 09:46
By: Lalit Kumar B
  SQL Update - Avoid Unique Constraint Error
By: gaganmadhu on Thu, 14 August 2014
3 242 Thu, 14 August 2014 07:50
By: gaganmadhu
  Index and Partitions
Oracle 11g
By: dariusd7 on Wed, 13 August 2014
11 373 Wed, 13 August 2014 20:15
By: dariusd7
  Schedule a Procedure with Input Parameters
Oracle PL/SQL
By: praveenramaswamy on Wed, 13 August 2014
3 243 Wed, 13 August 2014 14:19
By: BlackSwan
  USE IS NULL AND NOT NULL IN A CHECK CONSTRAINT
ORACLE 11G SQL PLUS
By: dariusd7 on Mon, 11 August 2014
10 408 Wed, 13 August 2014 12:44
By: Bill B
  SQL
Oracle 10g
By: gopikannan on Wed, 13 August 2014
4 220 Wed, 13 August 2014 10:25
By: gopikannan
  parent and Child issue ?
By: tondapi on Wed, 13 August 2014
3 237 Wed, 13 August 2014 08:00
By: joy_division
  Filling the Rows of a PL/SQL Nested Table
10g
By: ajitpal.s on Tue, 12 August 2014
7 453 Wed, 13 August 2014 03:20
By: ajitpal.s
  SQL
11g
By: userora on Tue, 12 August 2014
18 469 Wed, 13 August 2014 03:17
By: userora
  Help me! 06546. 00000 - "DDL statement is executed in an illegal context"
Oracle 11g r2
By: baoph9it on Tue, 12 August 2014
9 486 Tue, 12 August 2014 15:14
By: baoph9it
  ALTERING OR MODIFYING FREIGN KEY CONSTRAINT
SQL pLUS oRACLE 11G
By: dariusd7 on Mon, 11 August 2014
12 485 Tue, 12 August 2014 13:29
By: balu_dba
icon8.gif issue inserting multiple lines into one row
toad/oracle, 11.0.0.116, windows 7 x64
By: martinez77 on Tue, 12 August 2014
9 357 Tue, 12 August 2014 12:58
By: Solomon Yakobson
  Find table with column
Oracle 11g
By: keekee on Tue, 12 August 2014
14 382 Tue, 12 August 2014 09:29
By: cookiemonster
  read hebrew from file
ORACLE linux
By: einatmilo on Tue, 12 August 2014
1 195 Tue, 12 August 2014 09:14
By: ThomasG
  joining between 2 different dates ?
By: tondapi on Tue, 12 August 2014
15 369 Tue, 12 August 2014 07:17
By: Michel Cadot
  Find the number 3 in the third and last digits of an SSN
oracle 11g
By: tuckersuz on Thu, 07 August 2014
5 277 Mon, 11 August 2014 16:53
By: tuckersuz
  Window Functions = Analytic Functions in Oracle RDBMS?
Oracle 11g
By: rc3d on Mon, 11 August 2014
10 303 Mon, 11 August 2014 15:39
By: Littlefoot
  number to date format ?
By: tondapi on Mon, 11 August 2014
12 592 Mon, 11 August 2014 13:25
By: Lalit Kumar B
  Testing for Numeric when a varchar is passed in
10.2
By: lott42 on Fri, 08 August 2014
7 600 Mon, 11 August 2014 11:50
By: lott42
  procedure with loop
oracle 11g
By: tuckersuz on Mon, 11 August 2014
6 227 Mon, 11 August 2014 09:32
By: Lalit Kumar B
  How can I get the distinct rows?
oracle
By: zhuyeq on Sun, 10 August 2014
4 304 Sun, 10 August 2014 22:14
By: zhuyeq
  list of invalid objects
11g
By: kiranrathodkr916 on Sat, 02 August 2014
30 1065 Fri, 08 August 2014 22:14
By: kiranrathodkr916
  Matching pattern with given word
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Thu, 07 August 2014
15 461 Fri, 08 August 2014 20:30
By: manubatham20
  how to use constant
By: mist598 on Thu, 07 August 2014
11 458 Fri, 08 August 2014 00:15
By: mist598
  Moving Data from one table to other base on records size.
11G
By: Yuvraaj on Wed, 06 August 2014
12 386 Thu, 07 August 2014 14:59
By: Yuvraaj
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: Wed Oct 22 05:27:22 CDT 2014

Total time taken to generate the page: 0.12619 seconds