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
  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 393 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 825 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 418 Tue, 19 August 2014 02:32
By: Michel Cadot
  Insert as select from Table
11G
By: Yuvraaj on Thu, 14 August 2014
15 1208 Mon, 18 August 2014 18:10
By: BlackSwan
  ORA-04052 Error - URGENT
Oracle 11g
By: Oracle_Walker on Sun, 17 August 2014
19 1043 Mon, 18 August 2014 08:00
By: EdStevens
  Bind Variables
By: supriya_singh on Mon, 18 August 2014
3 441 Mon, 18 August 2014 07:59
By: Michel Cadot
  Hierarchical Output
Oracle 11g R2
By: javed.khan on Tue, 12 August 2014
9 609 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 1410 Mon, 18 August 2014 03:46
By: Lalit Kumar B
  who can create this output?
By: hahaie on Sun, 10 August 2014
11 1042 Mon, 18 August 2014 03:34
By: Lalit Kumar B
icon5.gif table should allow to insert only one row
Oracle 11.2.0.1.0
By: ecivgamer on Sat, 16 August 2014
11 662 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 530 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 374 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 491 Fri, 15 August 2014 12:09
By: Lalit Kumar B
  multiple currency value
oracle 11g
By: dariusd7 on Thu, 14 August 2014
11 789 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 743 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 868 Thu, 14 August 2014 13:38
By: m5124oracle
  Item Validation
oracle 11.g
By: diva_thilak on Wed, 13 August 2014
2 437 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 640 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 911 Thu, 14 August 2014 09:46
By: Lalit Kumar B
  SQL Update - Avoid Unique Constraint Error
By: gaganmadhu on Thu, 14 August 2014
3 383 Thu, 14 August 2014 07:50
By: gaganmadhu
  Index and Partitions
Oracle 11g
By: dariusd7 on Wed, 13 August 2014
11 593 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 438 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 626 Wed, 13 August 2014 12:44
By: Bill B
  SQL
Oracle 10g
By: gopikannan on Wed, 13 August 2014
4 320 Wed, 13 August 2014 10:25
By: gopikannan
  parent and Child issue ?
By: tondapi on Wed, 13 August 2014
3 389 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 600 Wed, 13 August 2014 03:20
By: ajitpal.s
  SQL
11g
By: userora on Tue, 12 August 2014
18 646 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 1082 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 1117 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 597 Tue, 12 August 2014 12:58
By: Solomon Yakobson
  Find table with column
Oracle 11g
By: keekee on Tue, 12 August 2014
14 554 Tue, 12 August 2014 09:29
By: cookiemonster
  read hebrew from file
ORACLE linux
By: einatmilo on Tue, 12 August 2014
1 356 Tue, 12 August 2014 09:14
By: ThomasG
  joining between 2 different dates ?
By: tondapi on Tue, 12 August 2014
15 483 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 445 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 511 Mon, 11 August 2014 15:39
By: Littlefoot
  number to date format ?
By: tondapi on Mon, 11 August 2014
12 936 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 1136 Mon, 11 August 2014 11:50
By: lott42
  procedure with loop
oracle 11g
By: tuckersuz on Mon, 11 August 2014
6 396 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 451 Sun, 10 August 2014 22:14
By: zhuyeq
  list of invalid objects
11g
By: kiranrathodkr916 on Sat, 02 August 2014
30 1340 Fri, 08 August 2014 22:14
By: kiranrathodkr916
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 Jul 04 05:14:47 CDT 2015

Total time taken to generate the page: 0.11449 seconds