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
  Find UPPER Chars in a name column
11g
By: Yuvraaj on Tue, 26 August 2014
8 455 Wed, 27 August 2014 00:54
By: Michel Cadot
  Code Convertions to Oracle 7.3.4
Oracle 7.3.4
By: saiphani723 on Wed, 27 August 2014
1 202 Wed, 27 August 2014 00:51
By: Michel Cadot
  select data using partition by clause where value of column is max
oracle 10g
By: jgjeetu on Mon, 25 August 2014
8 556 Tue, 26 August 2014 11:24
By: Michel Cadot
  Sql Satement with is null
11g Linux
By: preet_kumar on Tue, 26 August 2014
20 727 Tue, 26 August 2014 08:55
By: John Watson
  Use of /*All*/ or /*One*/ at the end of a Query
By: sread11 on Mon, 25 August 2014
4 289 Mon, 25 August 2014 14:48
By: Michel Cadot
  datatype of Null
PL SQL
By: smartkadhir on Sun, 24 August 2014
7 446 Sun, 24 August 2014 11:03
By: Lalit Kumar B
  exists data condition
By: mist598 on Thu, 21 August 2014
17 706 Fri, 22 August 2014 09:23
By: Lalit Kumar B
  using pivot
Oracle 11g
By: ora1980 on Thu, 21 August 2014
1 330 Thu, 21 August 2014 19:31
By: Barbara Boehmer
  fetching dynamic columns from a table
Oracle 11g
By: punitsoneji on Wed, 20 August 2014
17 850 Thu, 21 August 2014 14:07
By: Lalit Kumar B
  Help Required In - Row Generator Query
Oracle 11gR2, 11.2.0.1.0
By: jimit_shaili on Thu, 21 August 2014
6 342 Thu, 21 August 2014 06:31
By: Lalit Kumar B
  query
By: hany_marawan on Thu, 21 August 2014
2 200 Thu, 21 August 2014 03:05
By: hany_marawan
  SP2-0552: Bind variable "5" not declared.
Oracle 11.2.0.3 , Linux
By: Srijesh on Wed, 20 August 2014
19 736 Thu, 21 August 2014 00:56
By: Srijesh
  Row Count as End of the Row
Oracle 11g
By: Genesys on Wed, 20 August 2014
9 397 Wed, 20 August 2014 16:19
By: Bill B
  Compare and update Stored proc
By: deepugun on Wed, 20 August 2014
3 302 Wed, 20 August 2014 14:15
By: CraigB
  Table dependency for Audit tables
Oracle 11.2.0.3 , Linux
By: Srijesh on Wed, 20 August 2014
15 451 Wed, 20 August 2014 10:32
By: EdStevens
  How to find cardinality of a table in oracle
By: aaditya321 on Tue, 19 August 2014
17 572 Wed, 20 August 2014 07:26
By: aaditya321
  Retrieve one transaction which has max Net Sales in that day for 1 year and display by date
By: dwhasini@gmail.com on Tue, 19 August 2014
2 253 Tue, 19 August 2014 15:03
By: Michel Cadot
  EXCEPTION WHEN OTHERS
Oracle 10.2.0.5.0
By: Buchas on Mon, 18 August 2014
8 668 Tue, 19 August 2014 03:27
By: Lalit Kumar B
  MATERIALIZED VIEW on commit
linux, oracle11.2
By: zxx2403 on Mon, 18 August 2014
3 312 Tue, 19 August 2014 02:32
By: Michel Cadot
  Insert as select from Table
11G
By: Yuvraaj on Thu, 14 August 2014
15 988 Mon, 18 August 2014 18:10
By: BlackSwan
  ORA-04052 Error - URGENT
Oracle 11g
By: Oracle_Walker on Sun, 17 August 2014
19 634 Mon, 18 August 2014 08:00
By: EdStevens
  Bind Variables
By: supriya_singh on Mon, 18 August 2014
3 305 Mon, 18 August 2014 07:59
By: Michel Cadot
  Hierarchical Output
Oracle 11g R2
By: javed.khan on Tue, 12 August 2014
9 476 Mon, 18 August 2014 05:24
By: Lalit Kumar B
  Hierarchy output
11.2.0.3.0
By: Amine on Tue, 22 July 2014
18 1220 Mon, 18 August 2014 03:46
By: Lalit Kumar B
  who can create this output?
By: hahaie on Sun, 10 August 2014
11 877 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 382 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 491 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 361 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 231 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 364 Fri, 15 August 2014 12:09
By: Lalit Kumar B
  multiple currency value
oracle 11g
By: dariusd7 on Thu, 14 August 2014
11 611 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 546 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 532 Thu, 14 August 2014 13:38
By: m5124oracle
  Item Validation
oracle 11.g
By: diva_thilak on Wed, 13 August 2014
2 268 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 479 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 714 Thu, 14 August 2014 09:46
By: Lalit Kumar B
  SQL Update - Avoid Unique Constraint Error
By: gaganmadhu on Thu, 14 August 2014
3 262 Thu, 14 August 2014 07:50
By: gaganmadhu
  Index and Partitions
Oracle 11g
By: dariusd7 on Wed, 13 August 2014
11 396 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 264 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 434 Wed, 13 August 2014 12:44
By: Bill B
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 Nov 22 23:08:03 CST 2014

Total time taken to generate the page: 0.11301 seconds