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
  what is the difference between "generated always as" and "as" at the time of creating virtual column
oracle 11g
By: jgjeetu on Tue, 19 May 2015
3 274 Tue, 19 May 2015 06:17
By: Lalit Kumar B
  regexp_replace comma separated whole string
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Mon, 18 May 2015
10 361 Mon, 18 May 2015 14:58
By: manubatham20
icon5.gif Asp.Net Application hangs until oracle package is recompiled
Oracle Database 11g Release 11.2.0.1.0 64bit CentOS 6.5
By: praveenpraj on Tue, 27 January 2015
8 848 Mon, 18 May 2015 03:40
By: praveenpraj
  Procedure creation error - PLS-00103
Oracle 11.2.0.3, Linux x86 64
By: hitesh.bhatt on Mon, 18 May 2015
6 346 Mon, 18 May 2015 03:00
By: Lalit Kumar B
icon6.gif vpd condition with joins in DataWarehouse
oracle 11g
By: Droryash on Thu, 14 May 2015
6 452 Mon, 18 May 2015 00:55
By: Droryash
  Calculation of Day, month and year
Oracle 11g, Window 7
By: Bilal Khan on Fri, 15 May 2015
6 453 Sun, 17 May 2015 13:41
By: Barbara Boehmer
  Format check on varchar check!!
Oracle 11g
By: kaltiimaar on Sun, 17 May 2015
15 410 Sun, 17 May 2015 09:55
By: Michel Cadot
  Inserting records in Table using cursor
Oracle 11g ( 1 2)
By: rohit_shinez on Sun, 10 May 2015
41 1326 Sat, 16 May 2015 08:13
By: BlackSwan
  Row level lock after updation
windows 7,oracle 10g, form builder 10g
By: hcdba on Fri, 15 May 2015
8 342 Fri, 15 May 2015 09:12
By: Lalit Kumar B
  Select best 2 value out of 3 three values
Oracle 11g, Window 7
By: Bilal Khan on Thu, 14 May 2015
5 342 Fri, 15 May 2015 01:54
By: Bilal Khan
  replace number in column
By: hassan08 on Wed, 13 May 2015
6 360 Thu, 14 May 2015 11:39
By: Michel Cadot
  Viewing Object values in select and fill (multiple rows)
11.2.0.1.0
By: OraFerro on Thu, 14 May 2015
4 296 Thu, 14 May 2015 11:36
By: Michel Cadot
  dbms_scheduler -WeekDays scheduling program.
Oracle 11g, Windows
By: vicktorz on Thu, 14 May 2015
2 211 Thu, 14 May 2015 07:38
By: BlackSwan
  want data of all columns in a single column (no concatenate)
oracle 10g/11g
By: jgjeetu on Thu, 14 May 2015
7 256 Thu, 14 May 2015 07:35
By: jgjeetu
  Query using Partitioning
Oracle 11 G release R1
By: saurabh.sha on Wed, 13 May 2015
4 323 Thu, 14 May 2015 07:32
By: John Watson
  To take Previous date
Oracle 11g
By: rohit_shinez on Wed, 13 May 2015
8 379 Wed, 13 May 2015 16:28
By: John Watson
  Transpose/Pivot with all combination
By: jjxxs on Wed, 13 May 2015
2 278 Wed, 13 May 2015 08:20
By: Michel Cadot
  CREATE ANY PACKAGE alternative
Oracle 10g
By: Gnans on Wed, 13 May 2015
4 244 Wed, 13 May 2015 08:09
By: mnitu
  Temporary table space error
Oracle 8i
By: harshal_lagwankar on Tue, 12 May 2015
11 579 Wed, 13 May 2015 00:43
By: harshal_lagwankar
  Trigger associated with two Database
By: jknath on Mon, 11 May 2015
3 322 Tue, 12 May 2015 08:10
By: Bill B
  Oracle case statment solution
By: purnima1 on Mon, 11 May 2015
6 416 Tue, 12 May 2015 03:25
By: cookiemonster
  Pivoting Data
By: vpat on Mon, 11 May 2015
2 336 Tue, 12 May 2015 00:19
By: Michel Cadot
  ORA-01847 problem
oracle 10g windows 7 pro
By: bobghw on Thu, 07 May 2015
10 556 Mon, 11 May 2015 16:25
By: bobghw
  Finding positions of all 'X' in string?
By: Flyfishingninja on Mon, 11 May 2015
8 424 Mon, 11 May 2015 11:42
By: Solomon Yakobson
  PL/SQL Tables
Oracle 11g XE
By: Eric Langager on Mon, 09 February 2015
19 1296 Mon, 11 May 2015 04:05
By: Eric Langager
  Viewing Object values in select
11.2.0.1.0
By: OraFerro on Thu, 07 May 2015
13 592 Mon, 11 May 2015 01:10
By: OraFerro
  PRAGMA EXCEPTION_INIT not working as desired
O/S:Windows 7 PRO; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Sat, 09 May 2015
6 428 Sat, 09 May 2015 21:05
By: buggleboy007
  Wrong number of arguments being passed into child element
O/S:Windows 7 PRO; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Thu, 07 May 2015
4 418 Fri, 08 May 2015 10:23
By: Michel Cadot
  Frequency Distribution with future date place holders
SQL
By: fluffycone on Fri, 01 May 2015
6 463 Fri, 08 May 2015 01:15
By: Michel Cadot
  Processing Records in Cursor
By: rohit_shinez on Thu, 07 May 2015
4 319 Thu, 07 May 2015 13:41
By: John Watson
  View is not able to execute successfully because of using
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Thu, 07 May 2015
8 401 Thu, 07 May 2015 03:09
By: Roachcoach
  How to get count of character in the table
Oracle10g, Oracle11g
By: kumar0828 on Tue, 05 May 2015
5 445 Thu, 07 May 2015 01:01
By: Lalit Kumar B
  PL/SQL: ORA-00980: synonym translation is no longer valid
By: amit.sonar on Tue, 05 May 2015
5 403 Wed, 06 May 2015 17:19
By: BlackSwan
  How to get the right information suggested about Date
By: sbouhila on Mon, 04 May 2015
11 608 Wed, 06 May 2015 04:07
By: sbouhila
  How to convert CLOB(results of an SQL query) to XMLDocument
O/S:Windows 7 PRO; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Tue, 05 May 2015
5 287 Tue, 05 May 2015 21:56
By: BlackSwan
  How to avoid showing data on each row
Oracle 11g XE
By: kaz123 on Thu, 30 April 2015
12 622 Tue, 05 May 2015 11:32
By: flyboy
  need help in query
oracle 11i
By: moulivasireddy on Fri, 07 November 2014
6 555 Tue, 05 May 2015 06:35
By: Solomon Yakobson
  alignment of output in the dbms_output file
Oracle Database 11.1.0.7.0
By: mist598 on Tue, 05 May 2015
2 331 Tue, 05 May 2015 05:58
By: mist598
  list of columns of a table
By: hahaie on Mon, 10 November 2014
5 523 Tue, 05 May 2015 04:43
By: Lalit Kumar B
  Update record based on previous record
Oracle 11g
By: rohit_shinez on Sat, 02 May 2015
7 548 Mon, 04 May 2015 13:18
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: Tue Aug 04 11:25:11 CDT 2015

Total time taken to generate the page: 0.11113 seconds