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
  Select max date in row of columns. . .
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: fluffycone on Thu, 21 May 2015
5 388 Thu, 21 May 2015 14:01
By: EdStevens
  string aggregation
oracle 11g
By: patneel on Thu, 21 May 2015
2 309 Thu, 21 May 2015 12:47
By: Michel Cadot
  date Format error
sql oracle
By: palpali on Thu, 21 May 2015
9 338 Thu, 21 May 2015 09:13
By: Bill B
  Error in execution of Trigger
oracle 10g
By: jgjeetu on Thu, 21 May 2015
11 371 Thu, 21 May 2015 08:49
By: Bill B
  does any one use oracle v12?
oracle v12
By: LargeHadronCollider on Thu, 21 May 2015
13 380 Thu, 21 May 2015 07:26
By: LargeHadronCollider
  Error using INTO clause in execute immediate
oracle 10g
By: jgjeetu on Thu, 21 May 2015
4 313 Thu, 21 May 2015 05:12
By: jgjeetu
  DELETING of RECORDS simultaneously.
By: saipavan.plsql on Wed, 20 May 2015
6 417 Thu, 21 May 2015 03:41
By: naga.oracle
  Date validation
11g
By: rohit_shinez on Sat, 16 May 2015
9 632 Wed, 20 May 2015 07:23
By: Lalit Kumar B
  Row length of table in Oracle
By: irfankundi786@yahoo.com on Mon, 18 May 2015
24 641 Wed, 20 May 2015 05:21
By: Michel Cadot
  ERROR-ORA-06533: Subscript beyond count
By: ritubhayana on Wed, 20 May 2015
2 405 Wed, 20 May 2015 03:28
By: Michel Cadot
  Round Robin implementaion through sql script
Oracle 10g
By: virmahi on Thu, 19 August 2010
22 3504 Wed, 20 May 2015 02:51
By: cookiemonster
  Subquery with multiple rows
oracle db 10g
By: aruntutor on Tue, 19 May 2015
3 381 Wed, 20 May 2015 01:00
By: flyboy
  Dirty read issues
By: raj_te on Fri, 15 May 2015
7 579 Tue, 19 May 2015 08:04
By: Bill B
  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 294 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 382 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 864 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 397 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 470 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 467 Sun, 17 May 2015 13:41
By: Barbara Boehmer
  Format check on varchar check!!
Oracle 11g
By: kaltiimaar on Sun, 17 May 2015
15 429 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 1353 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 363 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 360 Fri, 15 May 2015 01:54
By: Bilal Khan
  replace number in column
By: hassan08 on Wed, 13 May 2015
6 379 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 311 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 225 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 312 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 340 Thu, 14 May 2015 07:32
By: John Watson
  To take Previous date
Oracle 11g
By: rohit_shinez on Wed, 13 May 2015
8 400 Wed, 13 May 2015 16:28
By: John Watson
  Transpose/Pivot with all combination
By: jjxxs on Wed, 13 May 2015
2 300 Wed, 13 May 2015 08:20
By: Michel Cadot
  CREATE ANY PACKAGE alternative
Oracle 10g
By: Gnans on Wed, 13 May 2015
4 253 Wed, 13 May 2015 08:09
By: mnitu
  Temporary table space error
Oracle 8i
By: harshal_lagwankar on Tue, 12 May 2015
11 606 Wed, 13 May 2015 00:43
By: harshal_lagwankar
  Trigger associated with two Database
By: jknath on Mon, 11 May 2015
3 335 Tue, 12 May 2015 08:10
By: Bill B
  Oracle case statment solution
By: purnima1 on Mon, 11 May 2015
6 429 Tue, 12 May 2015 03:25
By: cookiemonster
  Pivoting Data
By: vpat on Mon, 11 May 2015
2 349 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 581 Mon, 11 May 2015 16:25
By: bobghw
  Finding positions of all 'X' in string?
By: Flyfishingninja on Mon, 11 May 2015
8 442 Mon, 11 May 2015 11:42
By: Solomon Yakobson
  PL/SQL Tables
Oracle 11g XE
By: Eric Langager on Mon, 09 February 2015
19 1311 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 613 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 461 Sat, 09 May 2015 21:05
By: buggleboy007
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: Fri Sep 04 20:48:02 CDT 2015

Total time taken to generate the page: 0.12669 seconds