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
  Using debug in EBS r12 database with SQL Developer
ORACLE EBS R12
By: annu-agi on Wed, 01 March 2017
4 312 Thu, 02 March 2017 09:53
By: Michel Cadot
  {} in SQL
Oracle 11g
By: rahul1982 on Thu, 02 March 2017
5 247 Thu, 02 March 2017 08:13
By: cookiemonster
  How to query and not include weekend or Bankholidays
SQL
By: timppap on Thu, 02 March 2017
2 205 Thu, 02 March 2017 02:17
By: Barbara Boehmer
  Carriage return in column data for spool
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: abhi_orcl on Tue, 28 February 2017
12 422 Wed, 01 March 2017 12:08
By: Michel Cadot
  Today I came across different space issue in 12c DB (merged 2)
PL/SQL Release 12.1.0.2.0 - Production
By: saini006 on Wed, 01 March 2017
5 245 Wed, 01 March 2017 09:18
By: Flyby
  Complex date differences - Bet you can't figure this one out.
By: ertweety on Mon, 27 February 2017
11 415 Tue, 28 February 2017 09:27
By: Michel Cadot
  online table structure changes without affecting the user
11g
By: manikandan23 on Sat, 25 February 2017
22 484 Tue, 28 February 2017 06:49
By: EdStevens
  Execute Immediate with Dynamic From table
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Tue, 28 February 2017
2 209 Tue, 28 February 2017 01:51
By: saipradyumn
  2 column values going inverse and how to display corresponding keys
11g
By: manikandan23 on Sat, 25 February 2017
14 433 Mon, 27 February 2017 16:13
By: Barbara Boehmer
  Avoiding 2 Group By clauses
By: manikandan23 on Mon, 27 February 2017
5 198 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 262 Mon, 27 February 2017 09:14
By: Bill B
  Deletes with respect to table sizes
11g
By: manikandan23 on Sat, 25 February 2017
6 209 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 210 Mon, 27 February 2017 07:21
By: Michel Cadot
  Why difference between count(*) and count(*)
By: asliyanage on Sat, 25 February 2017
15 385 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 551 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 763 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 377 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 662 Wed, 22 February 2017 05:24
By: Michel Cadot
  PLSQL - Update in Loop
Oracle 11g
By: wmpl on Mon, 20 February 2017
5 374 Tue, 21 February 2017 23:23
By: Barbara Boehmer
  Flashback techniues
By: Vijayarajan51 on Tue, 21 February 2017
2 274 Tue, 21 February 2017 10:26
By: Michel Cadot
  Loading techniques
By: Vijayarajan51 on Tue, 21 February 2017
3 230 Tue, 21 February 2017 10:10
By: Vijayarajan51
  unique result
Oracle 11g
By: rahul1982 on Tue, 21 February 2017
2 191 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 288 Mon, 20 February 2017 07:49
By: Michel Cadot
  Synonym switching
oracle 11g release 2
By: raj85844 on Thu, 16 February 2017
5 220 Thu, 16 February 2017 16:50
By: Caffeine+
  cumulative sum & product
oracle 11g release 2
By: varada on Wed, 15 February 2017
18 466 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 265 Wed, 15 February 2017 23:05
By: OraFerro
  Oracle BLOB DATA
ORACLE,PLSQL
By: bkumar on Wed, 15 February 2017
5 148 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 252 Wed, 15 February 2017 10:36
By: abhi_orcl
  Problem while using AUTHID CURRENT_USER
By: amit.sonar on Fri, 10 February 2017
4 229 Wed, 15 February 2017 09:26
By: cookiemonster
  natural join change table
By: asliyanage on Mon, 13 February 2017
7 199 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 173 Tue, 14 February 2017 13:49
By: pointers
  How to identify one row from duplicate rows
By: asliyanage on Wed, 18 January 2017
6 507 Tue, 14 February 2017 01:57
By: Michel Cadot
  What is Unknown in logical operator
By: asliyanage on Mon, 16 January 2017
4 578 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 1590 Tue, 14 February 2017 00:16
By: grpatwari
  Counting minutes in a date/time range
By: dale2k9 on Tue, 07 February 2017
12 392 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 308 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 917 Sun, 12 February 2017 09:56
By: Bill B
  WHERE Clause With A Range
By: jmltinc on Tue, 07 February 2017
18 483 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 185 Wed, 08 February 2017 08:54
By: fabi88
  AND & OR Condition Usage
By: vharish006 on Tue, 07 February 2017
6 240 Wed, 08 February 2017 03:25
By: cookiemonster
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 Mar 23 19:05:57 CDT 2017

Total time taken to generate the page: 0.13851 seconds