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
  Select query given ORA-01722 error message
ora 11g
By: Tlg13team on Mon, 16 December 2013
3 383 Wed, 18 December 2013 02:44
By: Maaher
  How to add and multiply values in columns
APEX 4.2
By: brijeshgupta on Tue, 17 December 2013
2 440 Tue, 17 December 2013 14:58
By: Michel Cadot
icon5.gif help me please to migrate from MS SQL to Oracle
Oracle 11.2.0.2.0
By: ecivgamer on Tue, 17 December 2013
15 644 Tue, 17 December 2013 06:19
By: mokarem
  update the date column
11g
By: kekanap on Tue, 17 December 2013
6 510 Tue, 17 December 2013 05:13
By: pablolee
  Not getting head or tails
Oracle R12;PL/SQL;SQL Developer
By: megamind on Tue, 10 December 2013
12 866 Tue, 17 December 2013 04:41
By: John Watson
  how to get last week end date ?
By: malli123 on Mon, 16 December 2013
7 596 Mon, 16 December 2013 14:47
By: Bill B
  Get ovelap
Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro
By: shumail on Mon, 16 December 2013
4 418 Mon, 16 December 2013 14:25
By: shumail
  Materialized View on Remote DB
Oracle 11g Release2
By: feroze on Mon, 09 December 2013
5 490 Mon, 16 December 2013 11:56
By: feroze
  Right Outer Join - ORA-01719
Oracle 10.2.0.5
By: praveenramaswamy on Mon, 16 December 2013
5 540 Mon, 16 December 2013 11:53
By: Michel Cadot
  PLS-00103: Encountered the symbol "end-of-file" ...
By: krishnapb66 on Mon, 16 December 2013
1 379 Mon, 16 December 2013 10:00
By: BlackSwan
  ORA-20120:ORA-01405:fetched column value is null
toad
By: sravanim on Fri, 13 December 2013
3 463 Fri, 13 December 2013 10:10
By: Michel Cadot
  num_rows blank
11g
By: jbm417 on Thu, 12 December 2013
5 469 Fri, 13 December 2013 09:44
By: jbm417
icon5.gif Invalid characters, but have correct sql??
Oracle SQL
By: 7oak_ on Thu, 12 December 2013
14 747 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 515 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 544 Thu, 12 December 2013 09:01
By: Solomon Yakobson
  Case Statement
Oracle 11g
By: srinivas.k2005 on Thu, 12 December 2013
14 869 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 522 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 1113 Thu, 12 December 2013 01:54
By: jalal-rasooly
  To get Last week ?
By: malli123 on Tue, 10 December 2013
11 727 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 1073 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 466 Wed, 11 December 2013 11:58
By: Solomon Yakobson
  dbms_lob.append raising error.
oracle 11g
By: Jothish on Sun, 24 November 2013
14 842 Wed, 11 December 2013 08:23
By: Solomon Yakobson
  external table
oracle 10g
By: karthik7narla on Tue, 10 December 2013
7 484 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 387 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 502 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 354 Wed, 11 December 2013 00:44
By: martijn
  object type
sql command line
By: aravindreddy.akiti on Tue, 10 December 2013
11 312 Tue, 10 December 2013 12:47
By: joy_division
  dbms_output.put_line
By: nataliafoster26 on Tue, 10 December 2013
2 255 Tue, 10 December 2013 12:30
By: nataliafoster26
  object type
sql command line
By: aravindreddy.akiti on Tue, 10 December 2013
8 339 Tue, 10 December 2013 10:14
By: cookiemonster
  need Regular expression query
oracle 11g
By: mvrkr44 on Mon, 09 December 2013
12 634 Tue, 10 December 2013 09:10
By: Michel Cadot
  Pipe Separated Child record Query
Oracle10gR2
By: weekend79 on Tue, 10 December 2013
3 424 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 966 Tue, 10 December 2013 02:51
By: pratik4891
  Sql Help
Oracle 11g, Xp
By: bharathi89 on Mon, 09 December 2013
6 308 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 344 Mon, 09 December 2013 08:18
By: EdStevens
  getting last logon datetime
Oracle 10g
By: sss111ind on Mon, 09 December 2013
13 768 Mon, 09 December 2013 05:54
By: Lalit Kumar B
  Missing employees table
Oracle 11g
By: Robs58 on Sun, 08 December 2013
5 517 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 418 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 469 Mon, 09 December 2013 01:26
By: _jum
  Mutating Error
By: chat2raj.s on Sun, 08 December 2013
1 266 Sun, 08 December 2013 07:58
By: ThomasG
  Need package
By: mvrkr44 on Sun, 08 December 2013
1 218 Sun, 08 December 2013 04:52
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: Fri Aug 01 12:04:28 CDT 2014

Total time taken to generate the page: 0.10669 seconds