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
  Query on pagination Query
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
By: gopal.biswal on Sat, 17 January 2015
2 897 Thu, 22 January 2015 21:44
By: gopal.biswal
  Need help on hierarchial query
Oracle 11.2.0.4, Linus
By: sspn2010 on Thu, 22 January 2015
5 209 Thu, 22 January 2015 13:11
By: sspn2010
  Need help on a query
Oracle 10G
By: bahubcd on Thu, 22 January 2015
4 197 Thu, 22 January 2015 11:44
By: John Watson
  bulk collect
By: palpali on Wed, 21 January 2015
10 500 Thu, 22 January 2015 09:11
By: palpali
  Distributing a total amount (payment) according to individual records (requests)
11.2.0.1.0
By: OraFerro on Thu, 22 January 2015
4 407 Thu, 22 January 2015 08:23
By: Solomon Yakobson
  How to trim the last matching string using regexp_substr
By: oracleso on Wed, 21 January 2015
9 904 Thu, 22 January 2015 07:59
By: Michel Cadot
  Populate List from Java
Oracle 10g
By: Xandot on Thu, 22 January 2015
1 607 Thu, 22 January 2015 07:48
By: Michel Cadot
  status based use of SUM function
By: suji6281 on Thu, 22 January 2015
5 613 Thu, 22 January 2015 05:00
By: Michel Cadot
  Confusion about data length in CLOB type variable in PL/SQL
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
By: mokarem on Tue, 20 January 2015
5 430 Wed, 21 January 2015 21:59
By: mokarem
  Want to split value based on space if no space want to show null in second column
11g
By: cplusplus1 on Mon, 19 January 2015
4 1028 Wed, 21 January 2015 18:30
By: cplusplus1
  How to control the inserting the new records when it cross the limits
11g, Window 8
By: Bilal Khan on Tue, 09 December 2014
21 1272 Wed, 21 January 2015 10:17
By: Solomon Yakobson
  display group name
By: sudeshna_bio08 on Tue, 20 January 2015
5 676 Tue, 20 January 2015 09:22
By: Lalit Kumar B
  Finding SQL Query ...
Oracle 11.2.0.1 on Linux
By: suddhasatwa_oracle on Tue, 20 January 2015
5 690 Tue, 20 January 2015 06:26
By: Michel Cadot
  How to get right side value after comma
11g
By: cplusplus1 on Mon, 19 January 2015
7 802 Tue, 20 January 2015 00:18
By: Michel Cadot
  issue with a select query using row_number
oracle pl/sql
By: marouene.lm on Thu, 15 January 2015
12 412 Mon, 19 January 2015 21:28
By: Barbara Boehmer
  Logic to create new column in Oracle database - Multiple conditions making it more challenging
By: tableaudev2010 on Fri, 16 January 2015
11 1078 Sat, 17 January 2015 06:39
By: EdStevens
  CR/LR in column
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: Duane on Fri, 16 January 2015
34 1316 Fri, 16 January 2015 13:40
By: Duane
  XML Count rollup
Oracle 10g
By: zpele on Fri, 16 January 2015
4 738 Fri, 16 January 2015 12:36
By: BlackSwan
  cursor_for_loop allows PL/SQL SELECT..INTO statement
By: Lalit Kumar B on Mon, 12 January 2015
9 1171 Fri, 16 January 2015 10:04
By: Michel Cadot
  How to calculate in percent in sql query?
By: aaditya321 on Tue, 13 January 2015
31 2268 Thu, 15 January 2015 06:21
By: Lalit Kumar B
  pl sql to XML conversion
11g ( 1 2)
By: saniya on Tue, 13 January 2015
44 1944 Thu, 15 January 2015 01:03
By: Michel Cadot
  SQL query for a project scheduler
11.2.0.3
By: Amine on Fri, 09 January 2015
21 3868 Wed, 14 January 2015 13:25
By: Amine
  Handle duplicate Configurations (merged)
By: jg5111 on Mon, 12 January 2015
21 1245 Wed, 14 January 2015 05:14
By: Lalit Kumar B
  rownum query
Oracle 10g
By: sss111ind on Wed, 14 January 2015
10 986 Wed, 14 January 2015 02:22
By: sss111ind
  Table Access Full
Oracle 9i
By: fairdaus on Tue, 13 January 2015
3 588 Tue, 13 January 2015 07:55
By: BlackSwan
  Rollback in DBMS_PARALLEL_EXECUTE
ORACLE 11G
By: aravind.peddola@gmail.com on Tue, 13 January 2015
1 496 Tue, 13 January 2015 02:47
By: Michel Cadot
  convert comma separated string to IN clause
Oracle version 11g R2
By: robh0502 on Mon, 12 January 2015
5 294 Mon, 12 January 2015 14:22
By: Solomon Yakobson
  LOB
By: manishdba007 on Sun, 11 January 2015
3 928 Sun, 11 January 2015 12:15
By: Michel Cadot
  How to count working day
By: aaditya321 on Wed, 03 September 2014
17 2003 Sat, 10 January 2015 09:17
By: Lalit Kumar B
  how to run PLSQL procedure in foreground in SQL command prompt
By: victoryhendry on Fri, 09 January 2015
17 1549 Sat, 10 January 2015 08:20
By: BlackSwan
  How to find Nth weekday from current date?
Oracle 11g
By: Oracle_Walker on Thu, 08 January 2015
8 2987 Sat, 10 January 2015 00:30
By: Michel Cadot
  Generate flat file size more than 32767
oracle 11g
By: gbpatelin on Fri, 09 January 2015
1 233 Fri, 09 January 2015 17:35
By: BlackSwan
  Table design help
By: gorants on Fri, 09 January 2015
12 812 Fri, 09 January 2015 14:51
By: gorants
  calling proc with packag giving no output
By: mist598 on Thu, 08 January 2015
5 1857 Fri, 09 January 2015 01:48
By: flyboy
  how to loop and duplicate a string
11G
By: kmmchan on Thu, 08 January 2015
2 1880 Fri, 09 January 2015 00:37
By: Michel Cadot
  different outputs on same parameter (datatype date) while using 'like' and '='
oracle 10g
By: jgjeetu on Thu, 08 January 2015
11 1122 Thu, 08 January 2015 09:42
By: Solomon Yakobson
  Need to get only decimal values upto 2 digits if we have nothing in decimal points that has to be 0
oracle 11g R2
By: suramsmanu on Sun, 04 January 2015
6 2052 Thu, 08 January 2015 02:37
By: Lalit Kumar B
  creation of view by passing the values dynamically
11.2.0.1
By: grpatwari on Wed, 07 January 2015
10 3000 Thu, 08 January 2015 00:58
By: grpatwari
  How to find tables with nullable Unique Keys
Oracle 11.2.0.4
By: testoli on Wed, 07 January 2015
1 1231 Wed, 07 January 2015 04:47
By: Michel Cadot
  SYS_CONTEXT('USERENV','TERMINAL') gives "unknown" result in SQL Developer tool[split]
By: prejib on Mon, 05 January 2015
9 330 Tue, 06 January 2015 10:14
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: Fri Mar 06 20:20:49 CST 2015

Total time taken to generate the page: 0.10740 seconds