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
icon4.gif What is SELECT?
Oracle
By: nskrishnab on Wed, 04 December 2013
11 691 Wed, 04 December 2013 10:32
By: ThomasG
  priority along with overlapping dates query
11.2.0.3
By: sasisan09 on Tue, 03 December 2013
1 335 Wed, 04 December 2013 10:10
By: sasisan09
  DBMS_CDC find only the columns that are changed along with the primary key in the table
oracle 10.2.0.4
By: novice1 on Wed, 04 December 2013
6 333 Wed, 04 December 2013 07:49
By: John Watson
  Order by some columns
11g
By: yuvipoy on Thu, 21 November 2013
12 807 Wed, 04 December 2013 07:13
By: EdStevens
  Query Help
By: mist598 on Mon, 02 December 2013
10 685 Wed, 04 December 2013 02:56
By: cookiemonster
  How to Refresh User_tables
oracle 11gR1 OEL 5.5
By: 9390512774 on Tue, 03 December 2013
2 322 Wed, 04 December 2013 00:48
By: pablolee
  Reading Particular Line in UTL_FILE
oracle 11.2.0.3.0 - Windows server 2003 R2
By: muktha_22 on Mon, 02 December 2013
7 659 Wed, 04 December 2013 00:30
By: Michel Cadot
  How to use list of selected values on the body of procedure
Oracle 10g, PL/SQL
By: lemune on Sat, 30 November 2013
9 669 Tue, 03 December 2013 05:41
By: lemune
  split long string
sql 11g
By: mahnazzz on Tue, 19 February 2013
13 1500 Tue, 03 December 2013 04:18
By: mahnazzz
  query to work fast
oracle 9i
By: DUTTA@TARUN on Mon, 02 December 2013
8 575 Mon, 02 December 2013 17:35
By: pablolee
  How to get ddls for objects in DB and write them to a file
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: gupta27 on Mon, 25 November 2013
15 770 Mon, 02 December 2013 16:07
By: gupta27
  Comma Delimited String
PL SQL
By: yesh on Mon, 02 December 2013
10 556 Mon, 02 December 2013 07:35
By: dariyoosh
  ORGANIZATION_CODE must be declared
By: mist598 on Mon, 02 December 2013
2 331 Mon, 02 December 2013 02:11
By: mist598
  ORA-00935: group function is nested too deeply
Oracle Acadamy
By: mjpowers01606 on Sat, 30 November 2013
2 411 Sun, 01 December 2013 10:20
By: mjpowers01606
  Please help with multiple update
By: envision2005 on Thu, 28 November 2013
23 992 Sun, 01 December 2013 09:22
By: envision2005
  Error in reading XML message and inserting data into another DB using DB link
Oracle 11g
By: ramya_162 on Fri, 29 November 2013
4 375 Sat, 30 November 2013 10:58
By: ramya_162
  Multiple groupings in SQL
Oracle 11.2.0.3, Linux
By: sspn2010 on Wed, 20 November 2013
13 861 Sat, 30 November 2013 04:09
By: Lalit Kumar B
  Query to PIVOT
oracle 11g
By: srinivas.k2005 on Fri, 29 November 2013
3 356 Sat, 30 November 2013 02:43
By: pablolee
  how to write this update query?
By: jalal-rasooly on Fri, 29 November 2013
3 321 Fri, 29 November 2013 15:41
By: Littlefoot
  Run same procedure parallely in different sessions with diff parameter value
Oracle 11g
By: srinivas.k2005 on Fri, 29 November 2013
1 207 Fri, 29 November 2013 14:06
By: Michel Cadot
  not able to execute the explain plan in development in TOAD
Oracle 11g
By: na.dharma@gmail.com on Fri, 29 November 2013
2 292 Fri, 29 November 2013 13:12
By: Lalit Kumar B
  translate
Oracle 10g
By: m.abdulhaq on Tue, 26 November 2013
3 440 Fri, 29 November 2013 11:28
By: m.abdulhaq
  Fetching results using intermediate table
Oracle 10g
By: sss111ind on Fri, 29 November 2013
8 403 Fri, 29 November 2013 06:11
By: cookiemonster
  Need code
By: megamind on Fri, 29 November 2013
6 458 Fri, 29 November 2013 05:05
By: pablolee
  need to understand syntax
Oracle R12,SQL developer
By: megamind on Fri, 29 November 2013
3 535 Fri, 29 November 2013 03:24
By: megamind
  Using oracle wallets to move data from Oracle to teradata
By: Ankita06666 on Fri, 29 November 2013
0 694 Fri, 29 November 2013 01:40
By: Ankita06666
  Insert Script for Inserting values from Excel file
Oracle 10g Forms, WinXP
By: stalin4d on Thu, 28 November 2013
2 337 Thu, 28 November 2013 23:45
By: stalin4d
  Please help me to implement this procedure
Oracle 11g
By: ajaykumarkona on Tue, 26 November 2013
8 657 Thu, 28 November 2013 06:04
By: ajaykumarkona
  trim or remove data and spaces
Oracle 10 and 11g
By: imransi17@gmail.com on Wed, 27 November 2013
13 732 Thu, 28 November 2013 04:51
By: pablolee
  constraints error
sql command line
By: aravindreddy.akiti on Wed, 27 November 2013
7 405 Thu, 28 November 2013 01:03
By: Lalit Kumar B
  Error In Function
Oracle 10g
By: Rasol_57 on Wed, 27 November 2013
2 196 Wed, 27 November 2013 14:34
By: John Watson
  how to create local user in Database 12c
Oracle Database 12c
By: irsathahamed on Tue, 26 November 2013
2 247 Tue, 26 November 2013 12:42
By: Solomon Yakobson
icon14.gif Tools to learn to Become PL/SQL Developer
Oracle 10g
By: masthan.anthati@gmail.com on Tue, 26 November 2013
16 598 Tue, 26 November 2013 10:13
By: masthan.anthati@gmail.com
  get data from column name with "รถ" (M$ SQL, JDBC) and import it with sqlldr to Oracle
Oracle 10g and M$ SQL Server
By: rc3d on Tue, 26 November 2013
4 227 Tue, 26 November 2013 04:40
By: rc3d
  would i be able to run this query
By: nataliafoster26 on Mon, 25 November 2013
2 388 Tue, 26 November 2013 00:16
By: Littlefoot
  ORA-01001: invalid cursor
By: mist598 on Mon, 25 November 2013
5 339 Tue, 26 November 2013 00:14
By: Littlefoot
  unix time to date
Oracle 11g, Solaris
By: apenkov on Sun, 24 November 2013
2 451 Mon, 25 November 2013 11:15
By: apenkov
  constraints
sql command line
By: aravindreddy.akiti on Mon, 25 November 2013
2 205 Mon, 25 November 2013 10:19
By: ThomasG
  DBMS_LDAP Search filter
By: sse-studi@web.de on Mon, 25 November 2013
2 312 Mon, 25 November 2013 07:22
By: sse-studi@web.de
  get the value of FOR loop outside the loop
Oracle 11g, Win7
By: nischalinn on Mon, 25 November 2013
6 363 Mon, 25 November 2013 06:56
By: cookiemonster
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 19 06:11:10 CDT 2014

Total time taken to generate the page: 0.08331 seconds