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
  Announcement: How to use [code] tags and make your code easier to read?
Other people will appreciate it
By: Littlefoot on Mon, 05 September 2011
0 45088 Mon, 05 September 2011 02:20
By: Littlefoot
log in script has been moved to Forms by the moderator.
  Foreign Keys without supporting index
By: Kevin Meade on Thu, 05 March 2015
4 146 Fri, 06 March 2015 08:24
By: Kevin Meade
SQL Developer - access to AS400 iSeries has been moved to Client Tools by the moderator.
  datatype conversion --- INTERVAL DAY(9) TO SECOND(6) ---> HH24:MI
Oracle 11.2.0.4/ Redhad 6.3
By: sbmk_design on Fri, 06 March 2015
1 91 Fri, 06 March 2015 06:43
By: Solomon Yakobson
  SQLPLUS PLS-00103 Encountered 'INSERT'
By: MiraclePlease on Thu, 05 March 2015
22 257 Fri, 06 March 2015 00:37
By: MiraclePlease
  rowid and index
oracle 10g
By: asifkhan1990.cse on Thu, 05 March 2015
2 207 Thu, 05 March 2015 15:43
By: EdStevens
  Happy 2015 my dear friends! :D
Oracle form 6i - Oracle 11G
By: xebec on Thu, 05 March 2015
1 170 Thu, 05 March 2015 12:00
By: Michel Cadot
Export data into Excel Template has been moved to Forms by the moderator.
  Writing a Hierarchical Query without using the connect by prior
Oracle
By: sachinj on Wed, 04 March 2015
8 298 Thu, 05 March 2015 07:38
By: Michel Cadot
  Which system table I can check these grants available in my database or not?
Oracle 11g
By: na.dharma@gmail.com on Thu, 05 March 2015
5 224 Thu, 05 March 2015 06:24
By: Roachcoach
  rank
Developer 6i, Databse 11G R2,window 7 ultimate
By: milikiel on Wed, 04 March 2015
5 107 Wed, 04 March 2015 15:29
By: joy_division
BACKUP and RECOVERY has been moved to Backup & Recovery by the moderator.
SQLLDR has been moved to Forms by the moderator.
dynamic menus has been moved to Forms by the moderator.
script cutting off has been moved to Client Tools by the moderator.
  synonyms parameter
Developer 6i, Databse 11G R2,window 7 ultimate
By: milikiel on Wed, 04 March 2015
4 82 Wed, 04 March 2015 13:52
By: Michel Cadot
  complete refresh of materialized view works fine, but non-complete doesn't
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: ecivgamer on Wed, 04 March 2015
0 169 Wed, 04 March 2015 13:05
By: ecivgamer
  Varray to Columns with defaults
By: bharathram on Wed, 04 March 2015
7 143 Wed, 04 March 2015 11:22
By: Michel Cadot
  String Compress
11G
By: Yuvraaj on Tue, 03 March 2015
8 341 Wed, 04 March 2015 09:01
By: gazzag
  Regexp_Substr
Oracle 10g
By: Xandot on Wed, 04 March 2015
4 175 Wed, 04 March 2015 08:23
By: Xandot
How to Access files in a Server through a Local system in oracle has been moved to Windows by the moderator.
  Adding a row based on a value
By: system243trd on Tue, 03 March 2015
8 341 Wed, 04 March 2015 00:44
By: Michel Cadot
  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 241 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 635 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 614 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 302 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 443 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 652 Sat, 28 February 2015 22:32
By: mazam
  need the out put based on max date
By: mist598 on Fri, 27 February 2015
12 341 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 222 Thu, 26 February 2015 11:29
By: suji6281
  Using oracle object
oracle 11g
By: manns on Wed, 18 February 2015
14 794 Thu, 26 February 2015 10:11
By: manns
  Nested table as in parameter
11g
By: manns on Wed, 18 February 2015
6 382 Thu, 26 February 2015 10:09
By: manns
  PL/SQL Tables
Oracle 11g XE
By: Eric Langager on Mon, 09 February 2015
18 984 Thu, 26 February 2015 07:17
By: John Watson
  How do I use SQL column values as column names
11.2.0.4.0
By: grpatwari on Wed, 25 February 2015
3 288 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 190 Thu, 26 February 2015 05:31
By: sss111ind
  How to handle unknown number of variables
By: Nuggit on Thu, 19 February 2015
14 717 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 263 Wed, 25 February 2015 07:31
By: Kevin Meade
  Oracle dbms scheduler
Oracle 11g
By: veeraiahmannem on Tue, 24 February 2015
10 349 Wed, 25 February 2015 07:13
By: sss111ind
icon5.gif Split CLOB column to multiple columns within a row
Oracle 11g
By: as1986 on Thu, 19 February 2015
22 858 Wed, 25 February 2015 02: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 11:55:14 CST 2015

Total time taken to generate the page: 0.13606 seconds