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
  Query help
Oracle 11.2.0.4, Linux
By: sspn2010 on Tue, 24 March 2015
4 310 Tue, 24 March 2015 15:27
By: sspn2010
  merging two queries to create a table
sql
By: palpali on Mon, 23 March 2015
14 521 Tue, 24 March 2015 07:12
By: palpali
  DBMS_JOB TO run every saturday starting next saturday
oracle 11g Release2
By: azeem87 on Wed, 18 March 2015
6 543 Mon, 23 March 2015 09:35
By: azeem87
  synonyms
Developer 6i, Databse 11G R2,window 7 ultimate
By: kilimanjaro on Thu, 19 March 2015
13 906 Sun, 22 March 2015 07:37
By: EdStevens
  REGEXP_REPLACE Help NEEDED....
Oracle, 11.2.3, AIX
By: eastbay_oracle on Thu, 19 March 2015
3 255 Thu, 19 March 2015 16:59
By: eastbay_oracle
  EXISTS SQL QUERY
By: palpali on Thu, 19 March 2015
15 517 Thu, 19 March 2015 14:48
By: Michel Cadot
  need query based on the below requirement
Oracle 10g
By: vasu.bods703 on Thu, 19 March 2015
5 331 Thu, 19 March 2015 13:34
By: joy_division
  Need to identify columns not referenced in UPDATE SET clause.
By: gajini on Wed, 18 March 2015
4 388 Thu, 19 March 2015 11:05
By: EdStevens
  Result in same rows
plsql
By: mehboob110233 on Thu, 19 March 2015
8 465 Thu, 19 March 2015 09:24
By: Lalit Kumar B
  SQL date overlapping
By: sanodani on Wed, 18 March 2015
16 647 Thu, 19 March 2015 08:45
By: Michel Cadot
  Handle duplicates during direct load path in SQL LOADER
By: hemantakhandare@gmail.com on Wed, 18 March 2015
5 458 Thu, 19 March 2015 01:20
By: Michel Cadot
  Optimization ideas in view creation of subselect
10g R2 x64 , windows 2008 enterprise
By: clementstore on Tue, 17 March 2015
12 459 Wed, 18 March 2015 22:15
By: clementstore
  row to column convert
By: jaggy on Wed, 18 March 2015
3 341 Wed, 18 March 2015 13:17
By: Michel Cadot
  PRAGMA_INLINE (Overloading)
11g
By: vippysharma on Wed, 18 March 2015
2 302 Wed, 18 March 2015 11:01
By: Solomon Yakobson
  Cumulative agreegating strings
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Tue, 17 March 2015
12 351 Wed, 18 March 2015 10:08
By: manubatham20
  Query history and present table
Oracle 10g
By: sss111ind on Wed, 18 March 2015
8 335 Wed, 18 March 2015 07:59
By: sss111ind
  Use ALter table in PL/SQL block
Oracle 11g
By: vmehta on Tue, 17 March 2015
2 380 Wed, 18 March 2015 07:58
By: Bill B
  CASE in WHERE Clause
sql
By: palpali on Wed, 18 March 2015
3 371 Wed, 18 March 2015 03:03
By: Michel Cadot
  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 757 Wed, 18 March 2015 02:45
By: Michel Cadot
  OCI8 ERROR
oracle 10g
By: asifkhan1990.cse on Wed, 18 March 2015
1 298 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 303 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 428 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 321 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 307 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 641 Sun, 15 March 2015 03:45
By: John Watson
  Query the newest records
oracle11g
By: zhaoquer on Sat, 14 March 2015
3 347 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 402 Fri, 13 March 2015 11:54
By: Solomon Yakobson
  2 count query results manipulation
By: ketangarg86 on Thu, 12 March 2015
5 440 Fri, 13 March 2015 07:38
By: Solomon Yakobson
  Reference Partitioning
Oracle 11g
By: srinivas.k2005 on Thu, 12 March 2015
2 363 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 508 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 437 Thu, 12 March 2015 10:04
By: gazzag
  NO COPY parameters
By: ppatel87 on Tue, 10 March 2015
5 430 Wed, 11 March 2015 20:33
By: Kevin Meade
  String Compress
11G
By: Yuvraaj on Tue, 03 March 2015
11 633 Wed, 11 March 2015 07:26
By: gazzag
  cursor and loop
oracle10g
By: asifkhan1990.cse on Mon, 09 March 2015
7 507 Wed, 11 March 2015 05:19
By: Michel Cadot
  Complex comparision query
10g
By: m.abdulhaq on Tue, 10 March 2015
6 514 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 645 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 773 Mon, 09 March 2015 04:10
By: Michel Cadot
  SQLPLUS PLS-00103 Encountered 'INSERT'
By: MiraclePlease on Thu, 05 March 2015
35 931 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 453 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 316 Sat, 07 March 2015 15:33
By: BlackSwan
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: Wed Jul 01 23:32:28 CDT 2015

Total time taken to generate the page: 0.13120 seconds