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
  Trigger to fill foreign key from another table
11.0.2.10
By: OraFerro on Sun, 11 June 2017
2 662 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 824 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 14699 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 794 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 1259 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 1236 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 2994 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 1589 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 75504 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 1231 Thu, 01 June 2017 22:35
By: Hatik
  Query Db table with Key Value
Oracle
By: hippylou2u on Fri, 26 May 2017
10 1820 Wed, 31 May 2017 11:11
By: Solomon Yakobson
  Armstrong numbers
By: sridhar.sangubhatla on Tue, 03 July 2007
12 9936 Tue, 30 May 2017 08:20
By: ynkr999
  Dependent Objects recursively
Oracle 11.2.0.3
By: pointers on Mon, 29 May 2017
4 852 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 1596 Mon, 29 May 2017 07:06
By: EdStevens
  Help in Query to achieve output?
Oracle 11g
By: arifs3738 on Thu, 25 May 2017
8 1427 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 1968 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 917 Tue, 23 May 2017 03:19
By: cookiemonster
  Multiple rows based on column
Oracle 10g
By: sss111ind on Thu, 27 April 2017
9 2065 Mon, 22 May 2017 10:51
By: Michel Cadot
  Oracle Sequences
DB 11g, Forms 10
By: mbudzi2017 on Mon, 22 May 2017
11 1577 Mon, 22 May 2017 08:25
By: mbudzi2017
  need help in rectifying error
sql,oracle 11g
By: sowk on Mon, 15 May 2017
11 1869 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 663 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 1127 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 1283 Thu, 18 May 2017 14:54
By: Michel Cadot
  Use ":NEW" in Dynamic SQL in Trigger?
By: whdyck on Tue, 16 May 2017
16 1950 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 1692 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 2520 Thu, 18 May 2017 06:41
By: EdStevens
  snapshot too old
PLSQL 11g
By: kmnainani on Thu, 11 May 2017
22 3164 Wed, 17 May 2017 07:02
By: cookiemonster
  ListAgg results
11.2
By: lott42 on Fri, 12 May 2017
9 1382 Mon, 15 May 2017 11:41
By: lott42
icon5.gif Loading Data into multiple tables
Oracle 11g R2, pl/sql
By: kaos.tissue on Fri, 12 May 2017
18 2161 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 1010 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 787 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 746 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 1366 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 23388 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 3151 Fri, 12 May 2017 07:17
By: EdStevens
  Pass two or more value
Microsoft Visual Studio
By: jen888 on Wed, 10 May 2017
3 760 Fri, 12 May 2017 06:40
By: cookiemonster
  Using REGEXP_LIKE
Oracle 12c
By: GusGF on Fri, 12 May 2017
1 668 Fri, 12 May 2017 05:48
By: flyboy
  Loop SP out cursor inside a stored procedure
11.0.2.10
By: OraFerro on Wed, 10 May 2017
9 2617 Thu, 11 May 2017 07:43
By: Michel Cadot
  SP2-0552: Bind variable "LIMIT" not declared.
Oracle database 11.2.04 on Linux
By: youngb912 on Wed, 10 May 2017
2 841 Wed, 10 May 2017 19:24
By: youngb912
icon5.gif Using CHECK constraint to validate two types of telephone formatted insert data
Oracle 11g Enterprise Ed. Release 11.2.0.1.0 - 64bit, Win 10 Home 64 bit Ed
By: spd800c on Wed, 10 May 2017
4 1991 Wed, 10 May 2017 06:52
By: spd800c
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 Sep 18 18:52:02 CDT 2018