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 45061 Mon, 05 September 2011 02:20
By: Littlefoot
  Export data into Excel Template
By: Sudha S Teki on Tue, 03 March 2015
6 284 Thu, 05 March 2015 09:35
By: CraigB
  Writing a Hierarchical Query without using the connect by prior
Oracle
By: sachinj on Wed, 04 March 2015
8 184 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 108 Thu, 05 March 2015 06:24
By: Roachcoach
  rowid and index
oracle 10g
By: asifkhan1990.cse on Thu, 05 March 2015
1 85 Thu, 05 March 2015 03:28
By: Michel Cadot
  rank
Developer 6i, Databse 11G R2,window 7 ultimate
By: milikiel on Wed, 04 March 2015
5 100 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 73 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 132 Wed, 04 March 2015 13:05
By: ecivgamer
  Varray to Columns with defaults
By: bharathram on Wed, 04 March 2015
7 131 Wed, 04 March 2015 11:22
By: Michel Cadot
  String Compress
11G
By: Yuvraaj on Tue, 03 March 2015
8 329 Wed, 04 March 2015 09:01
By: gazzag
  Regexp_Substr
Oracle 10g
By: Xandot on Wed, 04 March 2015
4 166 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 336 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 237 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 626 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 608 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 300 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 440 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 649 Sat, 28 February 2015 22:32
By: mazam
  need the out put based on max date
By: mist598 on Fri, 27 February 2015
12 338 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 220 Thu, 26 February 2015 11:29
By: suji6281
  Using oracle object
oracle 11g
By: manns on Wed, 18 February 2015
14 791 Thu, 26 February 2015 10:11
By: manns
  Nested table as in parameter
11g
By: manns on Wed, 18 February 2015
6 380 Thu, 26 February 2015 10:09
By: manns
  PL/SQL Tables
Oracle 11g XE
By: Eric Langager on Mon, 09 February 2015
18 983 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 284 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 186 Thu, 26 February 2015 05:31
By: sss111ind
  How to handle unknown number of variables
By: Nuggit on Thu, 19 February 2015
14 714 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 260 Wed, 25 February 2015 07:31
By: Kevin Meade
  Oracle dbms scheduler
Oracle 11g
By: veeraiahmannem on Tue, 24 February 2015
10 346 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 856 Wed, 25 February 2015 02:14
By: Michel Cadot
  using function in select statement giving same value ( 1 2)
By: mist598 on Tue, 24 February 2015
41 455 Tue, 24 February 2015 09:11
By: BlackSwan
  PL/SQL for Insert/Update ( 1 2)
By: aimy on Thu, 12 February 2015
40 951 Tue, 24 February 2015 03:50
By: Michel Cadot
  Table Updates
Oracle 11g
By: Genesys on Mon, 23 February 2015
15 503 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 431 Mon, 23 February 2015 12:34
By: Bill B
  ora-22288
11gR2 RHEL5.5
By: smunir362 on Thu, 19 February 2015
6 387 Sat, 21 February 2015 11:50
By: BlackSwan
  New to using Oracle. Need help!
By: jdmas on Thu, 19 February 2015
6 307 Thu, 19 February 2015 12:41
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: Thu Mar 05 10:58:23 CST 2015

Total time taken to generate the page: 0.12493 seconds