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
  Fetching table sql inside code
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Mon, 02 March 2015
4 399 Tue, 03 March 2015 11:42
By: manubatham20
  Creating a salary report. Having trouble calculating previous salary.
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
By: rappaj on Fri, 27 February 2015
12 818 Tue, 03 March 2015 03:45
By: cookiemonster
  Storing varying number of columns in table
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Tue, 24 February 2015
28 771 Mon, 02 March 2015 22:46
By: BlackSwan
  How to get the connect string from the data base
Oracle 11g
By: saipradyumn on Mon, 02 March 2015
9 460 Mon, 02 March 2015 07:10
By: Michel Cadot
  SQL or PL/SQL method required to fill up the values based on other table values
10.2.0.1.0
By: bluetooth420 on Sat, 28 February 2015
11 639 Sun, 01 March 2015 12:12
By: bluetooth420
  Need to calculate a Set No. from a Data set
Oracle Database, 10g Rel.2, Windows-7
By: mazam on Wed, 25 February 2015
14 835 Sat, 28 February 2015 22:32
By: mazam
  need the out put based on max date
By: mist598 on Fri, 27 February 2015
12 478 Fri, 27 February 2015 08:34
By: BlackSwan
  how to return a row based on count using multiple tables
SQL Query
By: suji6281 on Thu, 26 February 2015
7 362 Thu, 26 February 2015 11:29
By: suji6281
  Using oracle object
oracle 11g
By: manns on Wed, 18 February 2015
14 956 Thu, 26 February 2015 10:11
By: manns
  Nested table as in parameter
11g
By: manns on Wed, 18 February 2015
6 492 Thu, 26 February 2015 10:09
By: manns
  How do I use SQL column values as column names
11.2.0.4.0
By: grpatwari on Wed, 25 February 2015
3 419 Thu, 26 February 2015 05:51
By: Lalit Kumar B
  Order by with WITH clause
Oracle 10g
By: sss111ind on Thu, 26 February 2015
3 321 Thu, 26 February 2015 05:31
By: sss111ind
  How to handle unknown number of variables
By: Nuggit on Thu, 19 February 2015
14 895 Thu, 26 February 2015 02:34
By: mnitu
  creation of records with respect to the delimited data from a column of base table
By: saralay on Tue, 24 February 2015
5 393 Wed, 25 February 2015 07:31
By: Kevin Meade
  Oracle dbms scheduler
Oracle 11g
By: veeraiahmannem on Tue, 24 February 2015
10 494 Wed, 25 February 2015 07:13
By: sss111ind
  using function in select statement giving same value ( 1 2)
By: mist598 on Tue, 24 February 2015
41 621 Tue, 24 February 2015 09:11
By: BlackSwan
  PL/SQL for Insert/Update ( 1 2)
By: aimy on Thu, 12 February 2015
40 1605 Tue, 24 February 2015 03:50
By: Michel Cadot
  Table Updates
Oracle 11g
By: Genesys on Mon, 23 February 2015
15 645 Tue, 24 February 2015 00:39
By: Genesys
  How to delete data from all the tables with one Query?
10g
By: manisngpl on Mon, 23 February 2015
9 577 Mon, 23 February 2015 12:34
By: Bill B
  ora-22288
11gR2 RHEL5.5
By: smunir362 on Thu, 19 February 2015
6 589 Sat, 21 February 2015 11:50
By: BlackSwan
  New to using Oracle. Need help!
By: jdmas on Thu, 19 February 2015
6 418 Thu, 19 February 2015 12:41
By: Michel Cadot
  To determine if the column value is decreasing
Oracle 11g
By: roblvl on Thu, 19 February 2015
2 304 Thu, 19 February 2015 07:29
By: Littlefoot
  Oracle 11g
Query plan
By: ramya_162 on Thu, 19 February 2015
2 296 Thu, 19 February 2015 07:08
By: EdStevens
  Trunc Date
Oracle SQL
By: naga78 on Thu, 19 February 2015
2 325 Thu, 19 February 2015 05:35
By: Lalit Kumar B
  Outer join restricts a condition
RDBMS : 11.1.0.7.0 Oracle Applications : 12.1.2
By: mmasoomansari on Wed, 18 February 2015
3 524 Thu, 19 February 2015 05:16
By: mmasoomansari
  Duplicating Excel "RATE" function in Oracle
Oracle 11.2
By: Primordial on Wed, 18 February 2015
2 571 Wed, 18 February 2015 06:43
By: Primordial
  how to grant database link to user
By: qanita786 on Tue, 17 February 2015
19 587 Wed, 18 February 2015 02:41
By: gazzag
  Concatenating numbers in virtual column expression throws ORA-12899: value too large for column
Oracle database, 12.1.0.1
By: Lalit Kumar B on Tue, 17 February 2015
2 336 Tue, 17 February 2015 02:29
By: Lalit Kumar B
  Identity column inserts duplicates with Insert All statement, unique constraint violation
Oracle database, 12.1.0.2, Any OS
By: Lalit Kumar B on Tue, 17 February 2015
4 400 Tue, 17 February 2015 02:20
By: Lalit Kumar B
  "Client copy" with PL/SQL
By: wurmi on Thu, 12 February 2015
19 634 Sun, 15 February 2015 09:29
By: wurmi
  fetch the same value with & without using the trunc ??
By: mist598 on Tue, 03 February 2015
24 881 Sun, 15 February 2015 08:21
By: Lalit Kumar B
  Split row into two or more rows
Oracle 10G r2
By: mmohsinaziz on Thu, 12 February 2015
3 366 Thu, 12 February 2015 23:48
By: Lalit Kumar B
icon4.gif Assign the SQL statement to a variable
Oracle 9.1
By: mikelala on Tue, 10 February 2015
17 1053 Thu, 12 February 2015 22:55
By: BlackSwan
  Need help on using regexp_substr in SQL
Oracle 11g
By: 3183h on Thu, 12 February 2015
2 257 Thu, 12 February 2015 19:27
By: Barbara Boehmer
  PLS-00597: PLSQL Record and Nested
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production, Windows 7
By: ninan on Wed, 11 February 2015
10 672 Thu, 12 February 2015 10:42
By: Solomon Yakobson
  convert string values into rows
oracle11
By: oracle_Raj on Wed, 11 February 2015
6 434 Thu, 12 February 2015 10:03
By: oracle_Raj
  blog image display in utl_mail
Oracle 10g
By: m.abdulhaq on Thu, 12 February 2015
6 456 Thu, 12 February 2015 05:15
By: m.abdulhaq
  SQL output to HTML table in email notification - possible?
By: RGall320 on Wed, 11 February 2015
1 359 Wed, 11 February 2015 12:21
By: Mahesh Rajendran
  Spliting of String
Oracle 10g
By: sss111ind on Thu, 05 February 2015
26 1029 Wed, 11 February 2015 07:36
By: BlackSwan
  how do I produce columns based on values within a column
By: Mr CPT on Wed, 11 February 2015
2 413 Wed, 11 February 2015 07:25
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: Sat Aug 01 19:21:23 CDT 2015

Total time taken to generate the page: 0.11661 seconds