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 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 1492 Wed, 10 May 2017 06:52
By: spd800c
  problem with FLOOR function
oracle
By: omidsm on Wed, 10 May 2017
4 1622 Wed, 10 May 2017 03:38
By: omidsm
  Decode and To_date
By: SamP17 on Mon, 08 May 2017
13 1722 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 1916 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 1226 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 10430 Tue, 09 May 2017 10:37
By: Olivier Comte
  Outer Join on Table
Forms 6i
By: syedferhat on Mon, 08 May 2017
8 360 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 563 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 223 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 378 Sat, 06 May 2017 07:20
By: Solomon Yakobson
  Get Return Value from Function without SELECT
By: whdyck on Thu, 04 May 2017
8 357 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 363 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 261 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 683 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 636 Mon, 01 May 2017 03:05
By: arpit0508
  COnditional change Serial
Oracle 11G, Windows 2003
By: mmohsinaziz on Thu, 27 April 2017
2 383 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 1023 Wed, 26 April 2017 10:47
By: Bill B
  Issue with DATE
By: rajkumar561991 on Tue, 25 April 2017
5 553 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 659 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 17967 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 261 Mon, 24 April 2017 10:50
By: Michel Cadot
  Taking Sum of Similar Tables
Oracle 11g
By: gobi21 on Sun, 23 April 2017
13 442 Mon, 24 April 2017 07:45
By: gobi21
  Pivot result using "Pivot" keyword
11.2
By: lott42 on Thu, 20 April 2017
4 344 Fri, 21 April 2017 12:22
By: lott42
  LIKE vs NOT LIKE operator
Oracle 12c
By: srinivas.k2005 on Fri, 21 April 2017
4 283 Fri, 21 April 2017 08:47
By: srinivas.k2005
  DEFINE_COLUMN in DBMS_SQL
Oracle 11.2.0.3
By: pointers on Thu, 20 April 2017
2 194 Fri, 21 April 2017 02:09
By: pointers
  Need help to form Query to split count into multiple rows
By: rakesh281214 on Wed, 19 April 2017
5 363 Thu, 20 April 2017 14:30
By: Barbara Boehmer
  merge issue
By: JEWEL78 on Tue, 18 April 2017
11 411 Thu, 20 April 2017 03:55
By: cookiemonster
  Regexp magic ! (I hope)
11.2.0.3.0
By: Amine on Fri, 14 April 2017
6 387 Wed, 19 April 2017 01:47
By: Michel Cadot
  pl/sql procedure using cursors
oracle 11g
By: POGAKU_SANTHOSH on Mon, 17 April 2017
3 208 Mon, 17 April 2017 16:03
By: BlackSwan
  Help required in SQL Analytic Function lag()
Oracle 11gR2 11.2.0.1.0
By: jimit_shaili on Sat, 15 April 2017
5 343 Mon, 17 April 2017 12:31
By: Michel Cadot
  Partition tablespace name does not change after moving subpartition
oracle12c
By: shrinika on Sat, 15 April 2017
2 259 Sat, 15 April 2017 12:59
By: shrinika
  cursors
windows
By: jay12 on Tue, 04 April 2017
3 264 Fri, 14 April 2017 15:49
By: Bill B
  testing rollback
12.1.0.1
By: jinga on Fri, 07 April 2017
2 352 Tue, 11 April 2017 12:56
By: Bill B
  Hierarchical Queries
Oracle 11.2.0.3
By: pointers on Thu, 06 April 2017
2 499 Sat, 08 April 2017 07:42
By: pointers
  UNION and dependent LOV
Oracle R12
By: umamagi on Fri, 07 April 2017
3 388 Sat, 08 April 2017 03:20
By: Littlefoot
  Pre Insert logic in Trigger
Oracle 11.2.0.3
By: pointers on Wed, 05 April 2017
10 480 Thu, 06 April 2017 21:09
By: pointers
  Avoid Distinct
Oracle 11g
By: manikandan23 on Wed, 05 April 2017
6 355 Thu, 06 April 2017 03:33
By: cookiemonster
  package
By: jay12 on Wed, 05 April 2017
3 257 Thu, 06 April 2017 03:30
By: cookiemonster
  Split clob data and store in table
Oracle 11g
By: Roots_ct5 on Tue, 04 April 2017
3 296 Tue, 04 April 2017 10:30
By: Roots_ct5
  Need a help with SQL
Oracle 12C
By: mangeshbhasme on Sun, 02 April 2017
10 452 Tue, 04 April 2017 06:59
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: Fri Aug 18 13:22:06 CDT 2017

Total time taken to generate the page: 0.07344 seconds