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
  Adding analytic function-based column changes another column result
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
By: lewap02 on Fri, 13 March 2015
11 681 Wed, 18 March 2015 02:45
By: Michel Cadot
  OCI8 ERROR
oracle 10g
By: asifkhan1990.cse on Wed, 18 March 2015
1 256 Wed, 18 March 2015 01:12
By: Michel Cadot
  create dynamic view based on metadata
Oracle 11gR2/12c
By: ravikanth_b on Mon, 16 March 2015
7 245 Mon, 16 March 2015 19:11
By: ravikanth_b
  rank
Developer 6i, Databse 11G R2,window 7 ultimate
By: kilimanjaro on Wed, 04 March 2015
8 369 Mon, 16 March 2015 15:22
By: Bill B
  Why "SQL command not properly ended" error on one and not on the other?
Oracle SQL
By: Adam Brave on Mon, 16 March 2015
5 264 Mon, 16 March 2015 06:49
By: Michel Cadot
  having clause is working before group by , why ?
oracle 10g
By: jgjeetu on Mon, 16 March 2015
2 266 Mon, 16 March 2015 06:08
By: jgjeetu
  Query execution changes in oracle 11.2.0.4.5 version
oracle 11.2.0.4.5
By: avineshr on Sun, 15 March 2015
14 545 Sun, 15 March 2015 03:45
By: John Watson
  Query the newest records
oracle11g
By: zhaoquer on Sat, 14 March 2015
3 292 Sat, 14 March 2015 07:06
By: Michel Cadot
  ORA-01427: single-row subquery returns more than one row
Oracle 11g
By: na.dharma@gmail.com on Fri, 13 March 2015
4 330 Fri, 13 March 2015 11:54
By: Solomon Yakobson
  2 count query results manipulation
By: ketangarg86 on Thu, 12 March 2015
5 374 Fri, 13 March 2015 07:38
By: Solomon Yakobson
  Reference Partitioning
Oracle 11g
By: srinivas.k2005 on Thu, 12 March 2015
2 324 Fri, 13 March 2015 02:53
By: srinivas.k2005
  How to Exclude Locked Rows from Select
11.2.0.3.0
By: supiash on Thu, 12 March 2015
11 431 Thu, 12 March 2015 20:17
By: cookiemonster
  Dynamic SQL - How to convert a varchar2 variable to use as a column name in a select statement
Oracle SQL
By: Adam Brave on Wed, 11 March 2015
13 354 Thu, 12 March 2015 10:04
By: gazzag
  NO COPY parameters
By: ppatel87 on Tue, 10 March 2015
5 366 Wed, 11 March 2015 20:33
By: Kevin Meade
  String Compress
11G
By: Yuvraaj on Tue, 03 March 2015
11 554 Wed, 11 March 2015 07:26
By: gazzag
  cursor and loop
oracle10g
By: asifkhan1990.cse on Mon, 09 March 2015
7 450 Wed, 11 March 2015 05:19
By: Michel Cadot
  Complex comparision query
10g
By: m.abdulhaq on Tue, 10 March 2015
6 456 Wed, 11 March 2015 00:08
By: m.abdulhaq
  How to remove the NULL values from SELECT clause
By: samiran_cts on Mon, 09 March 2015
16 559 Tue, 10 March 2015 05:25
By: samiran_cts
  How to restrict the inserting a record through a oracle trigger
oracle 10g
By: shivas1177 on Sat, 07 March 2015
17 718 Mon, 09 March 2015 04:10
By: Michel Cadot
  SQLPLUS PLS-00103 Encountered 'INSERT'
By: MiraclePlease on Thu, 05 March 2015
35 780 Sat, 07 March 2015 18:50
By: MiraclePlease
  How to perform a checksum to a table?
Oracle SQL 11
By: Adam Brave on Fri, 06 March 2015
3 381 Sat, 07 March 2015 16:04
By: EdStevens
  Datapump error inside SQL dev
11.2.0.1
By: oradba888 on Sat, 07 March 2015
4 256 Sat, 07 March 2015 15:33
By: BlackSwan
  Foreign Keys without supporting index
By: Kevin Meade on Thu, 05 March 2015
6 429 Sat, 07 March 2015 14:58
By: Solomon Yakobson
  rowid and index
oracle 10g
By: asifkhan1990.cse on Thu, 05 March 2015
3 445 Sat, 07 March 2015 01:58
By: asifkhan1990.cse
  How to use package dbms_sqlhash without privileges?
By: Adam Brave on Fri, 06 March 2015
4 341 Sat, 07 March 2015 01:48
By: John Watson
  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 253 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 262 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 419 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 289 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 134 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 362 Wed, 04 March 2015 13:05
By: ecivgamer
  Varray to Columns with defaults
By: bharathram on Wed, 04 March 2015
7 210 Wed, 04 March 2015 11:22
By: Michel Cadot
  Regexp_Substr
Oracle 10g
By: Xandot on Wed, 04 March 2015
4 269 Wed, 04 March 2015 08:23
By: Xandot
  Adding a row based on a value
By: system243trd on Tue, 03 March 2015
8 423 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 304 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 727 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 682 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 381 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 546 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 738 Sat, 28 February 2015 22:32
By: mazam
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 Apr 25 14:09:34 CDT 2015

Total time taken to generate the page: 0.10881 seconds