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
  Oracle database link performance cum security issue
Oracle 10G R2
By: arpankumarmisra on Fri, 26 May 2017
9 2650 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 1648 Thu, 15 June 2017 10:25
By: Caffeine+
  Help the newbie to do my first procedure
By: TonyDu94 on Wed, 14 June 2017
8 6160 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 2470 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 109333 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 846 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 1022 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 15578 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 1015 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 1566 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 1610 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 3761 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 2024 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 81682 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 1584 Thu, 01 June 2017 22:35
By: Hatik
  Query Db table with Key Value
Oracle
By: hippylou2u on Fri, 26 May 2017
10 2393 Wed, 31 May 2017 11:11
By: Solomon Yakobson
  Armstrong numbers
By: sridhar.sangubhatla on Tue, 03 July 2007
12 10739 Tue, 30 May 2017 08:20
By: ynkr999
  Dependent Objects recursively
Oracle 11.2.0.3
By: pointers on Mon, 29 May 2017
4 1057 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 2004 Mon, 29 May 2017 07:06
By: EdStevens
  Help in Query to achieve output?
Oracle 11g
By: arifs3738 on Thu, 25 May 2017
8 1734 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 2548 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 1175 Tue, 23 May 2017 03:19
By: cookiemonster
  Multiple rows based on column
Oracle 10g
By: sss111ind on Thu, 27 April 2017
9 2306 Mon, 22 May 2017 10:51
By: Michel Cadot
  Oracle Sequences
DB 11g, Forms 10
By: mbudzi2017 on Mon, 22 May 2017
11 1998 Mon, 22 May 2017 08:25
By: mbudzi2017
  need help in rectifying error
sql,oracle 11g
By: sowk on Mon, 15 May 2017
11 2418 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 842 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 1346 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 1691 Thu, 18 May 2017 14:54
By: Michel Cadot
  Use ":NEW" in Dynamic SQL in Trigger?
By: whdyck on Tue, 16 May 2017
16 2548 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 2244 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 3496 Thu, 18 May 2017 06:41
By: EdStevens
  snapshot too old
PLSQL 11g
By: kmnainani on Thu, 11 May 2017
22 3974 Wed, 17 May 2017 07:02
By: cookiemonster
  ListAgg results
11.2
By: lott42_gmail on Fri, 12 May 2017
9 1719 Mon, 15 May 2017 11:41
By: lott42_gmail
icon5.gif Loading Data into multiple tables
Oracle 11g R2, pl/sql
By: kaos.tissue on Fri, 12 May 2017
18 2870 Mon, 15 May 2017 06:56
By: EdStevens
  filesystem_like_logging is not in ddl of table
oracle 12.1.0.2,Windows Server 2014
By: chad_2000 on Mon, 15 May 2017
5 1227 Mon, 15 May 2017 06:48
By: chad_2000
  Taking time from current day/month/year 06:00:00 to sysdate(Current Time)
Oracle 10 g
By: baranwalb on Sat, 13 May 2017
3 1022 Sat, 13 May 2017 06:38
By: Michel Cadot
icon5.gif Multiple values in one-many relationship
Oracle 11g R2, pl/sql
By: kaos.tissue on Sat, 13 May 2017
2 950 Sat, 13 May 2017 02:51
By: kaos.tissue
  Error SQL: ORA-02270: no matching unique or primary key for this column-list
Oracle 11g
By: Cirov on Fri, 12 May 2017
3 1750 Fri, 12 May 2017 10:51
By: Michel Cadot
icon5.gif Instead of Trigger
Oracle 11g R2, pl/sql
By: kaos.tissue on Sat, 06 May 2017
23 24076 Fri, 12 May 2017 10:13
By: Michel Cadot
icon5.gif Trigger to join and insert data into table.
Oracle 11g R2, pl/sql
By: kaos.tissue on Thu, 11 May 2017
39 4189 Fri, 12 May 2017 07:17
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: Sun Dec 16 15:44:51 CST 2018