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
  bulk collect
By: palpali on Wed, 21 January 2015
10 555 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 432 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 930 Thu, 22 January 2015 07:59
By: Michel Cadot
  Populate List from Java
Oracle 10g
By: Xandot on Thu, 22 January 2015
1 644 Thu, 22 January 2015 07:48
By: Michel Cadot
  status based use of SUM function
By: suji6281 on Thu, 22 January 2015
5 630 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 461 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 1059 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 1423 Wed, 21 January 2015 10:17
By: Solomon Yakobson
  display group name
By: sudeshna_bio08 on Tue, 20 January 2015
5 701 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 716 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 840 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 455 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 1137 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 1496 Fri, 16 January 2015 13:40
By: Duane
  XML Count rollup
Oracle 10g
By: zpele on Fri, 16 January 2015
4 793 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 1228 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 2455 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 1991 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 3923 Wed, 14 January 2015 13:25
By: Amine
  Handle duplicate Configurations (merged)
By: jg5111 on Mon, 12 January 2015
21 1343 Wed, 14 January 2015 05:14
By: Lalit Kumar B
  rownum query
Oracle 10g
By: sss111ind on Wed, 14 January 2015
10 1017 Wed, 14 January 2015 02:22
By: sss111ind
  Table Access Full
Oracle 9i
By: fairdaus on Tue, 13 January 2015
3 621 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 525 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 322 Mon, 12 January 2015 14:22
By: Solomon Yakobson
  LOB
By: manishdba007 on Sun, 11 January 2015
3 969 Sun, 11 January 2015 12:15
By: Michel Cadot
  How to count working day
By: aaditya321 on Wed, 03 September 2014
17 2136 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 1586 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 3036 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 284 Fri, 09 January 2015 17:35
By: BlackSwan
  Table design help
By: gorants on Fri, 09 January 2015
12 838 Fri, 09 January 2015 14:51
By: gorants
  calling proc with packag giving no output
By: mist598 on Thu, 08 January 2015
5 1908 Fri, 09 January 2015 01:48
By: flyboy
  how to loop and duplicate a string
11G
By: kmmchan on Thu, 08 January 2015
2 1920 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 1152 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 2090 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 3039 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 1261 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 408 Tue, 06 January 2015 10:14
By: Michel Cadot
  Delete using a CTE
By: system243trd on Tue, 06 January 2015
6 649 Tue, 06 January 2015 07:21
By: Lalit Kumar B
  Sql querry needed for scenario
By: asbh123 on Tue, 06 January 2015
16 2367 Tue, 06 January 2015 05:56
By: Michel Cadot
  Check for missing records in 75 million records per day
Oracle 11g R2 (11.2.0.3.0), OS: Red Hat Enterprice Linux
By: bgraupe on Mon, 05 January 2015
20 2485 Tue, 06 January 2015 04:21
By: bgraupe
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: Sat Apr 18 10:31:29 CDT 2015

Total time taken to generate the page: 0.12478 seconds