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 45746 Mon, 05 September 2011 02:20
By: Littlefoot
  JSON parsing?
12c
By: JDOaktown on Mon, 30 March 2015
1 74 Tue, 31 March 2015 00:25
By: Michel Cadot
  Need help in tablespace
Oracle 10g XE, Windows 7
By: dark_prince on Mon, 30 March 2015
9 138 Tue, 31 March 2015 00:25
By: Michel Cadot
icon5.gif Split CLOB column to multiple columns within a row
Oracle 11g
By: as1986 on Thu, 19 February 2015
23 947 Mon, 30 March 2015 23:43
By: as1986
Calculate Balance in Ledger Please help has been moved to Oracle Fusion Apps & E-Business Suite by the moderator.
  case
By: palpali on Mon, 30 March 2015
6 118 Mon, 30 March 2015 14:37
By: Bill B
  how to get unmatched record from emp and dept tables
oracle 10g
By: ursfriend77 on Sun, 29 March 2015
11 254 Mon, 30 March 2015 05:52
By: vippysharma
  sql 9I ,10G ,11GDIFFERENCE SQL LEVEL
9I,10G,11G
By: duttatarun on Mon, 30 March 2015
7 261 Mon, 30 March 2015 05:25
By: Michel Cadot
Import and create table from a text file has been moved to Server Utilities by the moderator.
  Query regarding Outer Join
Oracle 11g , Windows 7
By: rakeshramm on Wed, 25 March 2015
9 468 Sat, 28 March 2015 10:29
By: Kevin Meade
Oracle Database 11g has been moved to Forms by the moderator.
  SQL query (merged 3)
By: sunny1234 on Thu, 26 March 2015
13 522 Fri, 27 March 2015 06:21
By: Solomon Yakobson
  External Tables
Linux 5.5, Oracle 10g, Windows xp
By: ORA2015 on Wed, 25 March 2015
18 606 Thu, 26 March 2015 14:58
By: EdStevens
  Converting Prompt syntax into regular sql
Oracle IDE 4.0
By: haryshenoy on Thu, 26 March 2015
1 151 Thu, 26 March 2015 12:18
By: Michel Cadot
  insert statement w/o having unique constraint error
By: suji6281 on Thu, 26 March 2015
3 244 Thu, 26 March 2015 12:16
By: Michel Cadot
  pl sql error
oracle 11g,windows 7
By: hcdba on Thu, 26 March 2015
10 374 Thu, 26 March 2015 10:48
By: Solomon Yakobson
  Using TYPE within an SQL IN statement
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: Duane on Tue, 24 March 2015
19 680 Thu, 26 March 2015 01:28
By: Michel Cadot
  request for solution
By: pramodnawle on Wed, 25 March 2015
3 224 Wed, 25 March 2015 14:22
By: Littlefoot
  Enforcing a particular execution plan
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Wed, 25 March 2015
3 193 Wed, 25 March 2015 11:56
By: manubatham20
  need conditional quantity insert into table
oracle
By: niteshtet on Tue, 24 March 2015
6 364 Wed, 25 March 2015 06:32
By: niteshtet
  Query help
Oracle 11.2.0.4, Linux
By: sspn2010 on Tue, 24 March 2015
4 200 Tue, 24 March 2015 15:27
By: sspn2010
  merging two queries to create a table
sql
By: palpali on Mon, 23 March 2015
14 385 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 423 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 783 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 172 Thu, 19 March 2015 16:59
By: eastbay_oracle
  EXISTS SQL QUERY
By: palpali on Thu, 19 March 2015
15 421 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 221 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 304 Thu, 19 March 2015 11:05
By: EdStevens
  Result in same rows
plsql
By: mehboob110233 on Thu, 19 March 2015
8 351 Thu, 19 March 2015 09:24
By: Lalit Kumar B
  SQL date overlapping
By: sanodani on Wed, 18 March 2015
16 544 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 375 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 372 Wed, 18 March 2015 22:15
By: clementstore
  row to column convert
By: jaggy on Wed, 18 March 2015
3 220 Wed, 18 March 2015 13:17
By: Michel Cadot
  PRAGMA_INLINE (Overloading)
11g
By: vippysharma on Wed, 18 March 2015
2 201 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 258 Wed, 18 March 2015 10:08
By: manubatham20
  Query history and present table
Oracle 10g
By: sss111ind on Wed, 18 March 2015
8 237 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 232 Wed, 18 March 2015 07:58
By: Bill B
  CASE in WHERE Clause
sql
By: palpali on Wed, 18 March 2015
3 236 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 659 Wed, 18 March 2015 02:45
By: Michel Cadot
  OCI8 ERROR
oracle 10g
By: asifkhan1990.cse on Wed, 18 March 2015
1 232 Wed, 18 March 2015 01:12
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: Tue Mar 31 00:40:36 CDT 2015

Total time taken to generate the page: 0.12279 seconds