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
  {} in SQL
Oracle 11g
By: rahul1982 on Thu, 02 March 2017
5 353 Thu, 02 March 2017 08:13
By: cookiemonster
  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 343 Wed, 01 March 2017 09:18
By: Flyby
  How to query and not include weekend or Bankholidays
SQL
By: timppap on Thu, 02 March 2017
2 317 Thu, 02 March 2017 02:17
By: Barbara Boehmer
  Analytical query
Oracle 11g
By: srinivas.k2005 on Mon, 06 March 2017
3 305 Mon, 06 March 2017 09:46
By: cookiemonster
  Using debug in EBS r12 database with SQL Developer
ORACLE EBS R12
By: annu-agi on Wed, 01 March 2017
4 458 Thu, 02 March 2017 09:53
By: Michel Cadot
  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 544 Wed, 01 March 2017 12:08
By: Michel Cadot
  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 311 Tue, 28 February 2017 01:51
By: saipradyumn
  Bitmap index for nullable timestamp column ?
Oracle 11gR2 / Linux
By: kevinz on Mon, 27 February 2017
19 819 Thu, 02 March 2017 20:08
By: Bill B
  Complex date differences - Bet you can't figure this one out.
By: ertweety on Mon, 27 February 2017
11 532 Tue, 28 February 2017 09:27
By: Michel Cadot
  Avoiding 2 Group By clauses
By: manikandan23 on Mon, 27 February 2017
5 288 Mon, 27 February 2017 12:00
By: Michel Cadot
  How to find highest salary ?
By: asliyanage on Sun, 26 February 2017
37 1192 Tue, 14 March 2017 05:49
By: asliyanage
  Return all rows if no matching condition found
Oracle 12c
By: pratik4891 on Sun, 26 February 2017
4 310 Mon, 27 February 2017 07:21
By: Michel Cadot
  can we use column alias in having clause
By: asliyanage on Sun, 26 February 2017
6 354 Mon, 27 February 2017 09:14
By: Bill B
  online table structure changes without affecting the user
11g
By: manikandan23 on Sat, 25 February 2017
22 712 Tue, 28 February 2017 06:49
By: EdStevens
  Deletes with respect to table sizes
11g
By: manikandan23 on Sat, 25 February 2017
6 348 Mon, 27 February 2017 09:11
By: Bill B
  2 column values going inverse and how to display corresponding keys
11g
By: manikandan23 on Sat, 25 February 2017
14 739 Mon, 27 February 2017 16:13
By: Barbara Boehmer
  Why difference between count(*) and count(*)
By: asliyanage on Sat, 25 February 2017
15 636 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 699 Sat, 25 February 2017 05:59
By: Solomon Yakobson
  Loading techniques
By: Vijayarajan51 on Tue, 21 February 2017
3 283 Tue, 21 February 2017 10:10
By: Vijayarajan51
  UTL_FILE.Put_Line carriage return.
11g R2
By: Manoj.Gupta.91 on Tue, 21 February 2017
6 771 Sat, 11 March 2017 02:43
By: Manoj.Gupta.91
  unique result
Oracle 11g
By: rahul1982 on Tue, 21 February 2017
2 268 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 403 Mon, 20 February 2017 07:49
By: Michel Cadot
  Declare a cursor from the return of a procedure?
By: sdsmaster on Tue, 21 February 2017
8 499 Thu, 23 February 2017 15:07
By: Barbara Boehmer
  Synonym switching
oracle 11g release 2
By: raj85844 on Thu, 16 February 2017
5 402 Thu, 16 February 2017 16:50
By: Caffeine+
  Oracle BLOB DATA
ORACLE,PLSQL
By: bkumar on Wed, 15 February 2017
5 209 Wed, 15 February 2017 14:11
By: BlackSwan
  cumulative sum & product
oracle 11g release 2
By: varada on Wed, 15 February 2017
18 602 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 466 Wed, 15 February 2017 23:05
By: OraFerro
  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 356 Wed, 15 February 2017 10:36
By: abhi_orcl
  PLSQL - Update in Loop
Oracle 11g
By: wmpl on Mon, 20 February 2017
5 452 Tue, 21 February 2017 23:23
By: Barbara Boehmer
  Update based on grouping
11.0.2.10
By: OraFerro on Mon, 20 February 2017
26 818 Wed, 22 February 2017 05:24
By: Michel Cadot
  REGEXP to find the comma position
Oracle 11.2.0.3
By: pointers on Tue, 14 February 2017
2 236 Tue, 14 February 2017 13:49
By: pointers
  natural join change table
By: asliyanage on Mon, 13 February 2017
7 304 Tue, 14 February 2017 15:41
By: Bill B
  Flashback techniues
By: Vijayarajan51 on Tue, 21 February 2017
2 389 Tue, 21 February 2017 10:26
By: Michel Cadot
  Problem while using AUTHID CURRENT_USER
By: amit.sonar on Fri, 10 February 2017
4 308 Wed, 15 February 2017 09:26
By: cookiemonster
  generate dynamic query and avoiding recompiling query
Oracle 12.1.0.2
By: fabi88 on Wed, 08 February 2017
5 280 Wed, 08 February 2017 08:54
By: fabi88
  Counting minutes in a date/time range
By: dale2k9 on Tue, 07 February 2017
12 699 Mon, 13 February 2017 10:18
By: Michel Cadot
  WHERE Clause With A Range
By: jmltinc on Tue, 07 February 2017
18 689 Thu, 09 February 2017 08:41
By: cookiemonster
  AND & OR Condition Usage
By: vharish006 on Tue, 07 February 2017
6 355 Wed, 08 February 2017 03:25
By: cookiemonster
  DBLinks stopped after wrongly changing domain name in sqlnet.ora
11.0.2.10
By: OraFerro on Tue, 07 February 2017
6 261 Tue, 07 February 2017 03:47
By: OraFerro
  Display only 10 charecters from column
Oracle 11g Release 2 Linux
By: anil_mk on Mon, 06 February 2017
12 434 Tue, 07 February 2017 07:07
By: Bill B
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 Aug 24 04:00:57 CDT 2017

Total time taken to generate the page: 0.01735 seconds