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
icon5.gif Working of stored procedure
Oracle 11g R2 version(11.2.0.1), pl1sql
By: kaos.tissue on Sat, 20 May 2017
1 2260 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 3338 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 4526 Thu, 18 May 2017 14:54
By: Michel Cadot
  Use ":NEW" in Dynamic SQL in Trigger?
By: whdyck on Tue, 16 May 2017
16 5925 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 5443 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 9455 Thu, 18 May 2017 06:41
By: EdStevens
  snapshot too old
PLSQL 11g
By: kmnainani on Thu, 11 May 2017
22 11121 Wed, 17 May 2017 07:02
By: cookiemonster
  ListAgg results
11.2
By: lott42_gmail on Fri, 12 May 2017
9 4853 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 8869 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 3243 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 3160 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 2253 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 6715 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 29546 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 11696 Fri, 12 May 2017 07:17
By: EdStevens
  Pass two or more value
Microsoft Visual Studio
By: jen888 on Wed, 10 May 2017
3 2676 Fri, 12 May 2017 06:40
By: cookiemonster
  Using REGEXP_LIKE
Oracle 12c
By: GusGF on Fri, 12 May 2017
1 2367 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 6207 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 3657 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 4187 Wed, 10 May 2017 06:52
By: spd800c
  problem with FLOOR function
oracle
By: omidsm on Wed, 10 May 2017
4 3709 Wed, 10 May 2017 03:38
By: omidsm
  Decode and To_date
By: SamP17 on Mon, 08 May 2017
13 7732 Wed, 10 May 2017 03:24
By: cookiemonster
icon5.gif invalid file operation
Oracle 12C , IBM AIX
By: Durai_1 on Tue, 09 May 2017
5 5033 Tue, 09 May 2017 11:08
By: BlackSwan
  Produce output not having any or all inputs (products)
By: ganesh_jadhav0509 on Tue, 09 May 2017
1 3056 Tue, 09 May 2017 11:06
By: Michel Cadot
  Returning Old value during update
Oracle 10g
By: mani_rbs on Mon, 02 January 2012
12 47942 Tue, 09 May 2017 10:37
By: Olivier Comte
  Outer Join on Table
Forms 6i
By: syedferhat on Mon, 08 May 2017
8 3726 Tue, 09 May 2017 03:27
By: cookiemonster
  Dynamic array as SP input
11.0.2.10
By: OraFerro on Sun, 23 April 2017
12 6358 Tue, 09 May 2017 01:58
By: OraFerro
  how to add to the right side of my table, the colums and data of 2 other tables .
Oracle 12c
By: mpniel on Mon, 08 May 2017
5 2545 Mon, 08 May 2017 10:50
By: mpniel
icon5.gif Adding missing values in external table
Oracle 11g R2, pl/sql
By: kaos.tissue on Fri, 05 May 2017
7 3110 Sat, 06 May 2017 07:20
By: Solomon Yakobson
  Get Return Value from Function without SELECT
By: whdyck on Thu, 04 May 2017
8 4232 Fri, 05 May 2017 12:00
By: Michel Cadot
icon5.gif Using Virtual Column
Oracle 11g R2, pl/sql
By: kaos.tissue on Fri, 05 May 2017
18 6056 Fri, 05 May 2017 05:06
By: kaos.tissue
  ORA-14097
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: scottwmackey on Thu, 04 May 2017
2 2837 Thu, 04 May 2017 15:53
By: scottwmackey
  Inserting data in multiple tables
Oracle 11g R2, pl/sql
By: kaos.tissue on Tue, 02 May 2017
27 8667 Thu, 04 May 2017 08:34
By: Bill B
  Need to get the top 3 employees whose salary increased in three consecutive year
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Product ,window
By: arpit0508 on Thu, 27 April 2017
6 3790 Mon, 01 May 2017 03:05
By: arpit0508
  COnditional change Serial
Oracle 11G, Windows 2003
By: mmohsinaziz on Thu, 27 April 2017
2 2273 Thu, 27 April 2017 02:23
By: mmohsinaziz
  NOT LIKE operation on the numbers columns
Oracle 12c
By: ora_newbie111 on Sun, 16 April 2017
20 8866 Wed, 26 April 2017 10:47
By: Bill B
  Issue with DATE
By: rajkumar561991 on Tue, 25 April 2017
5 3407 Wed, 26 April 2017 06:49
By: EdStevens
  SQL Tunning - Please Help Me
Oracle 10g
By: parthaspaul@gmail.com on Mon, 17 April 2017
21 7197 Mon, 24 April 2017 18:21
By: mikek
  PLS-00497: cannot mix between single row and multi-row (BULK) in
oracle 10.2.0.4.0 - 64bi linux
By: sundarfaq on Thu, 08 March 2012
6 39980 Mon, 24 April 2017 15:40
By: Barbara Boehmer
  ORA-00054 RESOURCE BUSY AND ACQUIRE WITH NOWAIT
By: mskphani on Mon, 24 April 2017
4 2773 Mon, 24 April 2017 10:50
By: Michel Cadot
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 May 19 22:03:48 CDT 2024