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
  2 column values going inverse and how to display corresponding keys
11g
By: manikandan23 on Sat, 25 February 2017
14 974 Mon, 27 February 2017 16:13
By: Barbara Boehmer
  Avoiding 2 Group By clauses
By: manikandan23 on Mon, 27 February 2017
5 420 Mon, 27 February 2017 12:00
By: Michel Cadot
  can we use column alias in having clause
By: asliyanage on Sun, 26 February 2017
6 493 Mon, 27 February 2017 09:14
By: Bill B
  Deletes with respect to table sizes
11g
By: manikandan23 on Sat, 25 February 2017
6 520 Mon, 27 February 2017 09:11
By: Bill B
  Return all rows if no matching condition found
Oracle 12c
By: pratik4891 on Sun, 26 February 2017
4 460 Mon, 27 February 2017 07:21
By: Michel Cadot
  Why difference between count(*) and count(*)
By: asliyanage on Sat, 25 February 2017
15 1217 Sun, 26 February 2017 01:40
By: Michel Cadot
  How to find No of Entries per week For consecutive week
By: gspandian on Thu, 23 February 2017
30 973 Sat, 25 February 2017 05:59
By: Solomon Yakobson
  ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
12c
By: jaysorcale on Wed, 18 January 2017
14 7139 Sat, 25 February 2017 01:42
By: asliyanage
  Declare a cursor from the return of a procedure?
By: sdsmaster on Tue, 21 February 2017
8 716 Thu, 23 February 2017 15:07
By: Barbara Boehmer
  Update based on grouping
11.0.2.10
By: OraFerro on Mon, 20 February 2017
26 1096 Wed, 22 February 2017 05:24
By: Michel Cadot
  PLSQL - Update in Loop
Oracle 11g
By: wmpl on Mon, 20 February 2017
5 602 Tue, 21 February 2017 23:23
By: Barbara Boehmer
  Flashback techniues
By: Vijayarajan51 on Tue, 21 February 2017
2 513 Tue, 21 February 2017 10:26
By: Michel Cadot
  Loading techniques
By: Vijayarajan51 on Tue, 21 February 2017
3 398 Tue, 21 February 2017 10:10
By: Vijayarajan51
  unique result
Oracle 11g
By: rahul1982 on Tue, 21 February 2017
2 386 Tue, 21 February 2017 03:39
By: rahul1982
  Comma separate value with column value as column name
11.2.0.4
By: grpatwari on Sun, 19 February 2017
4 519 Mon, 20 February 2017 07:49
By: Michel Cadot
  Synonym switching
oracle 11g release 2
By: raj85844 on Thu, 16 February 2017
5 710 Thu, 16 February 2017 16:50
By: Caffeine+
  cumulative sum & product
oracle 11g release 2
By: varada on Wed, 15 February 2017
18 840 Thu, 16 February 2017 10:02
By: varada
  Create a Job to run Oracle Package stored procedure
11.0.2.10
By: OraFerro on Wed, 15 February 2017
4 633 Wed, 15 February 2017 23:05
By: OraFerro
  Oracle BLOB DATA
ORACLE,PLSQL
By: bkumar on Wed, 15 February 2017
5 347 Wed, 15 February 2017 14:11
By: BlackSwan
  Global Temporary table storage
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit
By: abhi_orcl on Tue, 14 February 2017
9 537 Wed, 15 February 2017 10:36
By: abhi_orcl
  Problem while using AUTHID CURRENT_USER
By: amit.sonar on Fri, 10 February 2017
4 453 Wed, 15 February 2017 09:26
By: cookiemonster
  natural join change table
By: asliyanage on Mon, 13 February 2017
7 476 Tue, 14 February 2017 15:41
By: Bill B
  REGEXP to find the comma position
Oracle 11.2.0.3
By: pointers on Tue, 14 February 2017
2 358 Tue, 14 February 2017 13:49
By: pointers
  How to identify one row from duplicate rows
By: asliyanage on Wed, 18 January 2017
6 801 Tue, 14 February 2017 01:57
By: Michel Cadot
  What is Unknown in logical operator
By: asliyanage on Mon, 16 January 2017
4 892 Tue, 14 February 2017 01:53
By: Michel Cadot
  PL/SQL: numeric or value error: character string buffer too small
11.2.0.4
By: grpatwari on Mon, 24 October 2016
23 3243 Tue, 14 February 2017 00:16
By: grpatwari
  Counting minutes in a date/time range
By: dale2k9 on Tue, 07 February 2017
12 915 Mon, 13 February 2017 10:18
By: Michel Cadot
  Full outer join with ZERO rows in Second table
10.2
By: bluetooth420 on Sat, 11 February 2017
11 670 Sun, 12 February 2017 13:05
By: bluetooth420
  Using Oracle UTL_MAIL to send email through Kerio email server
11.0.2.10 ( 1 2)
By: OraFerro on Mon, 06 February 2017
40 1842 Sun, 12 February 2017 09:56
By: Bill B
  WHERE Clause With A Range
By: jmltinc on Tue, 07 February 2017
18 928 Thu, 09 February 2017 08:41
By: cookiemonster
  generate dynamic query and avoiding recompiling query
Oracle 12.1.0.2
By: fabi88 on Wed, 08 February 2017
5 425 Wed, 08 February 2017 08:54
By: fabi88
  AND & OR Condition Usage
By: vharish006 on Tue, 07 February 2017
6 541 Wed, 08 February 2017 03:25
By: cookiemonster
  Display only 10 charecters from column
Oracle 11g Release 2 Linux
By: anil_mk on Mon, 06 February 2017
12 666 Tue, 07 February 2017 07:07
By: Bill B
  DBLinks stopped after wrongly changing domain name in sqlnet.ora
11.0.2.10
By: OraFerro on Tue, 07 February 2017
6 422 Tue, 07 February 2017 03:47
By: OraFerro
icon4.gif Cursor Program To Find Tax Amount
By: Hemanth319 on Sun, 05 February 2017
3 397 Mon, 06 February 2017 15:02
By: Bill B
  Function To Reverese The Phone Number
By: Hemanth319 on Sun, 05 February 2017
5 628 Mon, 06 February 2017 14:54
By: Bill B
  Writing multiple Files using UTL_FILE
11g, Windows XP
By: siva27 on Mon, 06 February 2017
6 531 Mon, 06 February 2017 08:00
By: Michel Cadot
  Performance tuning in delete operation
Oracle 11g
By: raj85844 on Tue, 31 January 2017
5 722 Fri, 03 February 2017 04:03
By: John Watson
  order of operations in the below statements
sql developer
By: M123 on Thu, 02 February 2017
3 570 Fri, 03 February 2017 03:25
By: cookiemonster
  constraint error
10g, win8.1,
By: rzkhan on Tue, 31 January 2017
28 1001 Wed, 01 February 2017 10:28
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 Feb 25 00:07:36 CST 2018

Total time taken to generate the page: 0.23415 seconds