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
  How to generate JSON
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: Manoj.Gupta.91 on Wed, 21 June 2017
4 1052 Thu, 29 June 2017 11:36
By: Manoj.Gupta.91
  ORA-01830 in XMLTABLE for DATE conversion
11g and 12c
By: hamsterbacke on Thu, 22 June 2017
17 2914 Wed, 28 June 2017 01:29
By: Michel Cadot
  not gettting output for showplanfrpspreadsheetcode11g
Oracle 12c, Solaris SPARC
By: Gurubalan on Mon, 26 June 2017
3 693 Wed, 28 June 2017 00:05
By: Gurubalan
  help needed with SQL code
Oracle, 11, windows
By: aadebayo on Fri, 23 June 2017
7 3777 Fri, 23 June 2017 09:13
By: aadebayo
  PRMDB-0933-1
PRIMAVERA 16.2.1, WIN2K7 64BIT
By: hiper on Thu, 22 June 2017
1 614 Thu, 22 June 2017 03:16
By: Michel Cadot
  how to calculate column value dynamically
oracle 11g 11.2.0.4.0 release
By: harishankar_kar on Wed, 21 June 2017
3 658 Wed, 21 June 2017 08:25
By: Michel Cadot
  Sending List to Oracle Stored Procedure
By: anandneema on Mon, 19 June 2017
3 753 Mon, 19 June 2017 09:45
By: Michel Cadot
  grouping of records
Oracle 11.2.0.3
By: pointers on Sat, 17 June 2017
1 692 Sat, 17 June 2017 01:51
By: Michel Cadot
  stored proc execution based on selected value from a column
Oracle 11.2.0.4
By: veepee on Fri, 16 June 2017
5 829 Fri, 16 June 2017 10:39
By: BlackSwan
  Oracle database link performance cum security issue
Oracle 10G R2
By: arpankumarmisra on Fri, 26 May 2017
9 1590 Thu, 15 June 2017 12:20
By: joy_division
  Locked object in gv$locked_object without transaction in gv$transaction
Oracle 11g r2 , Red Had RAC
By: Andrey_R on Sat, 27 May 2017
4 1102 Thu, 15 June 2017 10:25
By: Caffeine+
  Help the newbie to do my first procedure
By: TonyDu94 on Wed, 14 June 2017
8 4108 Thu, 15 June 2017 00:26
By: flyboy
  [Error] Execution (64: 64): ORA-32034: unsupported use of WITH clause for materilized view
CORE 11.2.0.4.0 Production
By: JEWEL78 on Wed, 14 June 2017
7 1509 Wed, 14 June 2017 13:54
By: Bill B
  ORA-00922: missing or invalid option - PROCEDURE with SPOOL
By: freis_bcf on Tue, 06 June 2017
14 79471 Mon, 12 June 2017 03:02
By: cookiemonster
  Trigger to fill foreign key from another table
11.0.2.10
By: OraFerro on Sun, 11 June 2017
2 521 Sun, 11 June 2017 03:40
By: Michel Cadot
  Update values "in groups"
Oracle 12c, 12.1.0.2.0, MS Windows 7
By: Littlefoot on Fri, 09 June 2017
5 662 Fri, 09 June 2017 07:33
By: Solomon Yakobson
  Handling invalid identifier exception in plsql
oracle 11g
By: ynkr999 on Wed, 07 June 2017
6 11193 Fri, 09 June 2017 00:54
By: Michel Cadot
  Different result when using FOR UPDATE
Oracle 11
By: hundsmiachn on Tue, 06 June 2017
4 630 Tue, 06 June 2017 09:56
By: Michel Cadot
  dbms_output.put_line for dynamic sql query
SQL*Plus: Release 11.2.0.3.0 Production
By: shawaj on Tue, 30 May 2017
4 1030 Sat, 03 June 2017 03:28
By: shawaj
  oracle external table issue
oracle 11g , pl/sql, sql
By: POGAKU_SANTHOSH on Wed, 31 May 2017
5 925 Fri, 02 June 2017 19:03
By: Barbara Boehmer
  Sequence generation for Parallel Processing
ORACLE 11g, Windows
By: lokimisc on Fri, 12 May 2017
21 2449 Fri, 02 June 2017 15:08
By: Bill B
  Package to include a sleep inside a procedure
Linux 2.6.39-400.286.3.el6uek.x86_64 - Oracle 11.2.0.4.0
By: Nagesh1985 on Thu, 01 June 2017
9 1169 Fri, 02 June 2017 13:33
By: Bill B
  Passing value from one cursor to the other one.
By: AkilaSubramanian on Tue, 24 May 2011
6 71444 Fri, 02 June 2017 09:34
By: Bill B
  Creating foreign key constraints for nested tables of user defined types oracle
Oracle
By: Hatik on Thu, 01 June 2017
7 949 Thu, 01 June 2017 22:35
By: Hatik
  Query Db table with Key Value
Oracle
By: hippylou2u on Fri, 26 May 2017
10 1402 Wed, 31 May 2017 11:11
By: Solomon Yakobson
  Armstrong numbers
By: sridhar.sangubhatla on Tue, 03 July 2007
12 9386 Tue, 30 May 2017 08:20
By: ynkr999
  Dependent Objects recursively
Oracle 11.2.0.3
By: pointers on Mon, 29 May 2017
4 701 Tue, 30 May 2017 00:09
By: Michel Cadot
  Using loop with a variable table name
10G
By: shahid17 on Tue, 23 May 2017
8 1270 Mon, 29 May 2017 07:06
By: EdStevens
  Help in Query to achieve output?
Oracle 11g
By: arifs3738 on Thu, 25 May 2017
8 1170 Sat, 27 May 2017 08:46
By: Solomon Yakobson
  Create Year and week partition automatically
11.2.0.4
By: grpatwari on Mon, 22 May 2017
13 1577 Wed, 24 May 2017 08:25
By: Bill B
  Improve Spool Performance
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit, AIX OS
By: abhi_orcl on Mon, 22 May 2017
2 734 Tue, 23 May 2017 03:19
By: cookiemonster
  Multiple rows based on column
Oracle 10g
By: sss111ind on Thu, 27 April 2017
9 1856 Mon, 22 May 2017 10:51
By: Michel Cadot
  Oracle Sequences
DB 11g, Forms 10
By: mbudzi2017 on Mon, 22 May 2017
11 1262 Mon, 22 May 2017 08:25
By: mbudzi2017
  need help in rectifying error
sql,oracle 11g
By: sowk on Mon, 15 May 2017
11 1510 Mon, 22 May 2017 07:35
By: Bill B
icon5.gif Working of stored procedure
Oracle 11g R2 version(11.2.0.1), pl1sql
By: kaos.tissue on Sat, 20 May 2017
1 536 Sat, 20 May 2017 11:35
By: BlackSwan
  Percentage of occurrences of a row
Oracle 11g 11.2.0.2.0
By: Cirov on Wed, 17 May 2017
6 938 Sat, 20 May 2017 03:55
By: Michel Cadot
icon5.gif listagg function in oracle
Oracle 11g R2, pl/sql
By: kaos.tissue on Thu, 18 May 2017
8 997 Thu, 18 May 2017 14:54
By: Michel Cadot
  Use ":NEW" in Dynamic SQL in Trigger?
By: whdyck on Tue, 16 May 2017
16 1443 Thu, 18 May 2017 08:00
By: BlackSwan
icon5.gif Procedure not functioning properly
Oracle 11g R2, pl/sql
By: kaos.tissue on Thu, 18 May 2017
14 1319 Thu, 18 May 2017 07:41
By: Bill B
  Operating with columns within a table
Oracle 11g 11.2.0.2.0
By: Cirov on Sun, 14 May 2017
27 1982 Thu, 18 May 2017 06:41
By: EdStevens
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: Mon Jun 25 08:50:46 CDT 2018