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
icon5.gif Invalid characters, but have correct sql??
Oracle SQL
By: 7oak_ on Thu, 12 December 2013
14 651 Fri, 13 December 2013 07:54
By: EdStevens
  Global variable in Oracle Object (Super/Sub) Types?
11g
By: wmgonzalbo on Wed, 11 December 2013
7 435 Thu, 12 December 2013 23:39
By: wmgonzalbo
  Query to find tables/views with cross referencing foreign keys
Oracle 8.1.7.4.1, Windows server 2003 R2
By: oraclebabe on Thu, 12 December 2013
4 476 Thu, 12 December 2013 09:01
By: Solomon Yakobson
  Case Statement
Oracle 11g
By: srinivas.k2005 on Thu, 12 December 2013
14 822 Thu, 12 December 2013 03:11
By: srinivas.k2005
  Fetch data with no rows in a table
By: vishnupn on Fri, 06 December 2013
7 472 Thu, 12 December 2013 02:24
By: vishnupn
  Problem In Accessing The value of Outer Cursor in inner Cursor ?
oracle, 11g r2, windows 7 64 bit
By: jalal-rasooly on Sat, 07 December 2013
22 1039 Thu, 12 December 2013 01:54
By: jalal-rasooly
  To get Last week ?
By: malli123 on Tue, 10 December 2013
11 648 Thu, 12 December 2013 01:44
By: Lalit Kumar B
  UPDATE table insert characters into a VARCHAR2 row
Oracle 10g
By: JimmyBob on Sat, 07 December 2013
23 993 Wed, 11 December 2013 16:11
By: JimmyBob
  Can I use global variable in dynamic sql and outside of sql statment
Oracle 11g
By: na.dharma@gmail.com on Wed, 11 December 2013
5 406 Wed, 11 December 2013 11:58
By: Solomon Yakobson
  dbms_lob.append raising error.
oracle 11g
By: Jothish on Sun, 24 November 2013
14 716 Wed, 11 December 2013 08:23
By: Solomon Yakobson
  external table
oracle 10g
By: karthik7narla on Tue, 10 December 2013
7 422 Wed, 11 December 2013 07:27
By: EdStevens
  shortest way to concatenate multiple messages based on column multiple values.
Oracle 11g
By: ajaykumarkona on Wed, 11 December 2013
7 351 Wed, 11 December 2013 05:45
By: Michel Cadot
  ora-20000: unable to analyze table
11.2.0.1.0
By: grpatwari on Wed, 11 December 2013
5 399 Wed, 11 December 2013 05:45
By: Michel Cadot
  Accessing data from MS Access into Oracle using Oracle procedure
Oracle 10G, MS Access 2003
By: athar.fitfd@hotmail.com on Wed, 11 December 2013
4 311 Wed, 11 December 2013 00:44
By: martijn
  object type
sql command line
By: aravindreddy.akiti on Tue, 10 December 2013
11 252 Tue, 10 December 2013 12:47
By: joy_division
  dbms_output.put_line
By: nataliafoster26 on Tue, 10 December 2013
2 221 Tue, 10 December 2013 12:30
By: nataliafoster26
  object type
sql command line
By: aravindreddy.akiti on Tue, 10 December 2013
8 308 Tue, 10 December 2013 10:14
By: cookiemonster
  need Regular expression query
oracle 11g
By: mvrkr44 on Mon, 09 December 2013
12 582 Tue, 10 December 2013 09:10
By: Michel Cadot
  Pipe Separated Child record Query
Oracle10gR2
By: weekend79 on Tue, 10 December 2013
3 336 Tue, 10 December 2013 07:31
By: Solomon Yakobson
  Find number of consecutive days from a table
By: pratik4891 on Mon, 09 December 2013
15 787 Tue, 10 December 2013 02:51
By: pratik4891
  Sql Help
Oracle 11g, Xp
By: bharathi89 on Mon, 09 December 2013
6 284 Mon, 09 December 2013 12:12
By: Lalit Kumar B
  Please help me how concatenate all the error messages and display using OUT parameter value.
Oracle 11g
By: ramya_162 on Mon, 09 December 2013
1 275 Mon, 09 December 2013 08:18
By: EdStevens
  getting last logon datetime
Oracle 10g
By: sss111ind on Mon, 09 December 2013
13 679 Mon, 09 December 2013 05:54
By: Lalit Kumar B
  Missing employees table
Oracle 11g
By: Robs58 on Sun, 08 December 2013
5 458 Mon, 09 December 2013 04:49
By: martijn
  Insert value from one table to 2nd table
By: haider_1pk on Mon, 09 December 2013
4 365 Mon, 09 December 2013 01:49
By: pablolee
  What should be the XML format for this code.
Oracle 11g
By: ramya_162 on Fri, 06 December 2013
7 416 Mon, 09 December 2013 01:26
By: _jum
  Need procedure logic
oracle 11g
By: mvrkr44 on Sun, 08 December 2013
8 380 Sun, 08 December 2013 11:16
By: Michel Cadot
  Mutating Error
By: chat2raj.s on Sun, 08 December 2013
1 229 Sun, 08 December 2013 07:58
By: ThomasG
  Need package
By: mvrkr44 on Sun, 08 December 2013
1 183 Sun, 08 December 2013 04:52
By: cookiemonster
  Retrieve data from string column
Oracle 11g
By: srinivas.k2005 on Sun, 08 December 2013
2 223 Sun, 08 December 2013 03:19
By: srinivas.k2005
  need sql query
oracle 11g
By: mvrkr44 on Fri, 06 December 2013
5 389 Fri, 06 December 2013 10:49
By: manubatham20
  anything better than substr comparison?
By: lijok on Thu, 05 December 2013
4 460 Fri, 06 December 2013 08:48
By: Solomon Yakobson
  Difference in the execution plans
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: gupta27 on Thu, 05 December 2013
3 335 Fri, 06 December 2013 04:55
By: John Watson
  update
oracle 10g
By: thelearner on Thu, 05 December 2013
4 375 Fri, 06 December 2013 02:32
By: pablolee
icon5.gif gettin ip addres and user name
database oracle 11g
By: otto_paiz@hotmail.com on Thu, 05 December 2013
5 386 Fri, 06 December 2013 01:53
By: Michel Cadot
  Retrieve font name available in OS using sql plus
Windows 7, Oracle 10g XE
By: lock_heart on Wed, 04 December 2013
16 797 Fri, 06 December 2013 01:07
By: karthik7narla
  Excel attachment by utl_smtp
Oracle 11g, windows xp 32 bit
By: sudeshna_bio08 on Wed, 04 December 2013
12 950 Thu, 05 December 2013 23:15
By: BlackSwan
  How to populate data from an Excel file to Oracle table's LOB column
Oracle 9i, Linux 9
By: sonudev on Wed, 27 November 2013
2 309 Thu, 05 December 2013 11:55
By: shahzad-ul-hasan
  PL/SQL Package/Procedure Question
11g Release 2 Windows
By: Duane on Wed, 04 December 2013
5 322 Thu, 05 December 2013 09:25
By: Duane
  Need Fuzzy logic with Regular expression query
oracle 11g
By: mvrkr44 on Thu, 05 December 2013
1 259 Thu, 05 December 2013 09:15
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: Sat Apr 19 03:56:45 CDT 2014

Total time taken to generate the page: 0.31780 seconds