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
  variable declaration in procedure if we are calling the procedure within itself
By: chavva.kiru@gmail.com on Sun, 25 January 2015
1 370 Sun, 25 January 2015 16:52
By: Solomon Yakobson
  Updating a table with group by
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
By: wantmannu on Sat, 24 January 2015
6 603 Sun, 25 January 2015 11:29
By: wantmannu
  sql query to get avg value
Oracle 11g
By: thelearner on Fri, 23 January 2015
11 1094 Sun, 25 January 2015 04:36
By: John Watson
  REG:Variable declaration in procedure
By: chavva.kiru@gmail.com on Sat, 24 January 2015
2 491 Sun, 25 January 2015 01:06
By: Michel Cadot
  error while running procedure
By: chavva.kiru@gmail.com on Sun, 18 January 2015
3 589 Sat, 24 January 2015 23:43
By: chavva.kiru@gmail.com
  need to get perfect query
oracle database
By: Ganesha on Sat, 24 January 2015
2 431 Sat, 24 January 2015 14:48
By: Michel Cadot
  Subtracting Years from As_Of_Date
PL/SQL, Version 9.0.6.1665
By: jburdell on Fri, 23 January 2015
6 397 Fri, 23 January 2015 16:10
By: Bill B
  How to find first prior number from current date
By: aaditya321 on Thu, 15 January 2015
36 3722 Fri, 23 January 2015 09:27
By: Lalit Kumar B
  Error While Fetching Data Through Database Link In Oracle
By: qanita786 on Fri, 23 January 2015
8 635 Fri, 23 January 2015 06:32
By: EdStevens
  Special character issues
By: raopatwariyahoocom on Thu, 22 January 2015
6 715 Fri, 23 January 2015 03:00
By: Michel Cadot
  Help with REGEXP
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0
By: mokarem on Wed, 14 January 2015
25 3195 Fri, 23 January 2015 01:08
By: m.abdulhaq
  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 1059 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 323 Thu, 22 January 2015 13:11
By: sspn2010
  Need help on a query
Oracle 10G
By: bahubcd on Thu, 22 January 2015
4 292 Thu, 22 January 2015 11:44
By: John Watson
  bulk collect
By: palpali on Wed, 21 January 2015
10 695 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 496 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 1015 Thu, 22 January 2015 07:59
By: Michel Cadot
  Populate List from Java
Oracle 10g
By: Xandot on Thu, 22 January 2015
1 742 Thu, 22 January 2015 07:48
By: Michel Cadot
  status based use of SUM function
By: suji6281 on Thu, 22 January 2015
5 709 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 570 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 1143 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 1642 Wed, 21 January 2015 10:17
By: Solomon Yakobson
  display group name
By: sudeshna_bio08 on Tue, 20 January 2015
5 801 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 802 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 943 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 537 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 1230 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 1898 Fri, 16 January 2015 13:40
By: Duane
  XML Count rollup
Oracle 10g
By: zpele on Fri, 16 January 2015
4 893 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 1394 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 2916 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 2108 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 4043 Wed, 14 January 2015 13:25
By: Amine
  Handle duplicate Configurations (merged)
By: jg5111 on Mon, 12 January 2015
21 1606 Wed, 14 January 2015 05:14
By: Lalit Kumar B
  rownum query
Oracle 10g
By: sss111ind on Wed, 14 January 2015
10 1123 Wed, 14 January 2015 02:22
By: sss111ind
  Table Access Full
Oracle 9i
By: fairdaus on Tue, 13 January 2015
3 701 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 617 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 422 Mon, 12 January 2015 14:22
By: Solomon Yakobson
  LOB
By: manishdba007 on Sun, 11 January 2015
3 1092 Sun, 11 January 2015 12:15
By: Michel Cadot
  How to count working day
By: aaditya321 on Wed, 03 September 2014
17 2455 Sat, 10 January 2015 09:17
By: Lalit Kumar 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: Sun Aug 02 08:02:30 CDT 2015

Total time taken to generate the page: 0.11326 seconds