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
  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 372 Fri, 06 March 2015 06:43
By: Solomon Yakobson
  Happy 2015 my dear friends! :D
Oracle form 6i - Oracle 11G
By: xebec on Thu, 05 March 2015
1 354 Thu, 05 March 2015 12:00
By: Michel Cadot
  Writing a Hierarchical Query without using the connect by prior
Oracle
By: sachinj on Wed, 04 March 2015
8 540 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 403 Thu, 05 March 2015 06:24
By: Roachcoach
  synonyms parameter
Developer 6i, Databse 11G R2,window 7 ultimate
By: kilimanjaro on Wed, 04 March 2015
4 230 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 490 Wed, 04 March 2015 13:05
By: ecivgamer
  Varray to Columns with defaults
By: bharathram on Wed, 04 March 2015
7 309 Wed, 04 March 2015 11:22
By: Michel Cadot
  Regexp_Substr
Oracle 10g
By: Xandot on Wed, 04 March 2015
4 377 Wed, 04 March 2015 08:23
By: Xandot
  Adding a row based on a value
By: system243trd on Tue, 03 March 2015
8 527 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 429 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 856 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 807 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 482 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 671 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 863 Sat, 28 February 2015 22:32
By: mazam
  need the out put based on max date
By: mist598 on Fri, 27 February 2015
12 502 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 385 Thu, 26 February 2015 11:29
By: suji6281
  Using oracle object
oracle 11g
By: manns on Wed, 18 February 2015
14 972 Thu, 26 February 2015 10:11
By: manns
  Nested table as in parameter
11g
By: manns on Wed, 18 February 2015
6 515 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 438 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 345 Thu, 26 February 2015 05:31
By: sss111ind
  How to handle unknown number of variables
By: Nuggit on Thu, 19 February 2015
14 910 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 413 Wed, 25 February 2015 07:31
By: Kevin Meade
  Oracle dbms scheduler
Oracle 11g
By: veeraiahmannem on Tue, 24 February 2015
10 520 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 653 Tue, 24 February 2015 09:11
By: BlackSwan
  PL/SQL for Insert/Update ( 1 2)
By: aimy on Thu, 12 February 2015
40 1626 Tue, 24 February 2015 03:50
By: Michel Cadot
  Table Updates
Oracle 11g
By: Genesys on Mon, 23 February 2015
15 671 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 591 Mon, 23 February 2015 12:34
By: Bill B
  ora-22288
11gR2 RHEL5.5
By: smunir362 on Thu, 19 February 2015
6 613 Sat, 21 February 2015 11:50
By: BlackSwan
  New to using Oracle. Need help!
By: jdmas on Thu, 19 February 2015
6 433 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 316 Thu, 19 February 2015 07:29
By: Littlefoot
  Oracle 11g
Query plan
By: ramya_162 on Thu, 19 February 2015
2 304 Thu, 19 February 2015 07:08
By: EdStevens
  Trunc Date
Oracle SQL
By: naga78 on Thu, 19 February 2015
2 339 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 550 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 659 Wed, 18 February 2015 06:43
By: Primordial
  how to grant database link to user
By: qanita786 on Tue, 17 February 2015
19 623 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 356 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 428 Tue, 17 February 2015 02:20
By: Lalit Kumar B
  "Client copy" with PL/SQL
By: wurmi on Thu, 12 February 2015
19 662 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 898 Sun, 15 February 2015 08:21
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: Mon Aug 31 10:25:47 CDT 2015

Total time taken to generate the page: 0.27007 seconds