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
  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 478 Tue, 23 May 2017 03:19
By: cookiemonster
  Multiple rows based on column
Oracle 10g
By: sss111ind on Thu, 27 April 2017
9 1559 Mon, 22 May 2017 10:51
By: Michel Cadot
  Oracle Sequences
DB 11g, Forms 10
By: mbudzi2017 on Mon, 22 May 2017
11 686 Mon, 22 May 2017 08:25
By: mbudzi2017
  need help in rectifying error
sql,oracle 11g
By: sowk on Mon, 15 May 2017
11 858 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 396 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 657 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 578 Thu, 18 May 2017 14:54
By: Michel Cadot
  Use ":NEW" in Dynamic SQL in Trigger?
By: whdyck on Tue, 16 May 2017
16 831 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 633 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 1041 Thu, 18 May 2017 06:41
By: EdStevens
  snapshot too old
PLSQL 11g
By: kmnainani on Thu, 11 May 2017
22 1775 Wed, 17 May 2017 07:02
By: cookiemonster
  ListAgg results
11.2
By: lott42 on Fri, 12 May 2017
9 799 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 933 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 636 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 423 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 390 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 606 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 21958 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 1359 Fri, 12 May 2017 07:17
By: EdStevens
  Pass two or more value
Microsoft Visual Studio
By: jen888 on Wed, 10 May 2017
3 420 Fri, 12 May 2017 06:40
By: cookiemonster
  Using REGEXP_LIKE
Oracle 12c
By: GusGF on Fri, 12 May 2017
1 348 Fri, 12 May 2017 05:48
By: flyboy
  PL/SQL: ORA-04053: error occurred when validating remote object
oracle12c
By: shrinika on Thu, 11 May 2017
1 610 Thu, 11 May 2017 15:11
By: Michel Cadot
  Loop SP out cursor inside a stored procedure
11.0.2.10
By: OraFerro on Wed, 10 May 2017
9 1764 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 459 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 1629 Wed, 10 May 2017 06:52
By: spd800c
  problem with FLOOR function
oracle
By: omidsm on Wed, 10 May 2017
4 1830 Wed, 10 May 2017 03:38
By: omidsm
  Decode and To_date
By: SamP17 on Mon, 08 May 2017
13 2030 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 2386 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 1355 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 38530 Tue, 09 May 2017 10:37
By: Olivier Comte
  Outer Join on Table
Forms 6i
By: syedferhat on Mon, 08 May 2017
8 668 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 781 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 388 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 624 Sat, 06 May 2017 07:20
By: Solomon Yakobson
  Get Return Value from Function without SELECT
By: whdyck on Thu, 04 May 2017
8 556 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 594 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 478 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 977 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 835 Mon, 01 May 2017 03:05
By: arpit0508
  COnditional change Serial
Oracle 11G, Windows 2003
By: mmohsinaziz on Thu, 27 April 2017
2 509 Thu, 27 April 2017 02:23
By: mmohsinaziz
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: Thu Feb 22 19:23:42 CST 2018

Total time taken to generate the page: 0.01636 seconds