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
  need query syntax
Oracle10g xe ,win xp
By: rnemkul on Thu, 23 January 2014
2 229 Thu, 23 January 2014 10:13
By: Michel Cadot
  Second max
Oracle 10g, windows xp
By: Lynn321 on Thu, 23 January 2014
4 375 Thu, 23 January 2014 07:28
By: Michel Cadot
  PL/SQL statement
Oracle 11g 11.1.0.7.0
By: SteveShephard on Wed, 22 January 2014
7 665 Thu, 23 January 2014 07:24
By: Michel Cadot
  How to use bind variables in cursors?
By: adityalsr89 on Wed, 22 January 2014
9 597 Thu, 23 January 2014 02:31
By: cookiemonster
  Concatenate issue
11.2.0.3
By: rishwinger on Thu, 23 January 2014
3 302 Thu, 23 January 2014 02:14
By: Michel Cadot
  TO_DATE conversion issue
By: mist598 on Wed, 22 January 2014
9 646 Wed, 22 January 2014 13:34
By: joy_division
  how to improve sql & Skills
oracle 10g
By: thelearner on Wed, 22 January 2014
3 415 Wed, 22 January 2014 13:11
By: Michel Cadot
  default type of null column in explicit cursor
Oracle 11g
By: orsoghu on Wed, 22 January 2014
6 459 Wed, 22 January 2014 10:13
By: orsoghu
  Explain how these errors are coming? is it due to raise_application_error??
By: sampathkore4444@gmail.com on Wed, 22 January 2014
1 272 Wed, 22 January 2014 02:39
By: cookiemonster
  Number of Primary Key Columns
Oracle 10g
By: mamalik on Mon, 20 January 2014
22 1118 Tue, 21 January 2014 23:34
By: Kevin Meade
  Why Commit is not allowed in a trigger in oracle??
By: sampathkore4444@gmail.com on Tue, 21 January 2014
5 360 Tue, 21 January 2014 22:56
By: Kevin Meade
  Passing bind variables to a VIEW
Oracle 11g
By: ora4me on Tue, 21 January 2014
2 276 Tue, 21 January 2014 22:27
By: Kevin Meade
  UTL_SMTP
By: Aydin on Tue, 21 January 2014
8 441 Tue, 21 January 2014 08:05
By: Michel Cadot
  Issue in Database Link
Oracle Database 11g Enterprise Edition 11.2.0.1.0 - 64bit
By: Manoj.Gupta.91 on Mon, 20 January 2014
4 386 Tue, 21 January 2014 01:14
By: Michel Cadot
  The INTO clause of a SELECT statement of PL/SQL block
By: dancko on Mon, 20 January 2014
4 348 Tue, 21 January 2014 01:02
By: dancko
  Rank without analytical function
11.2.0.3
By: rishwinger on Mon, 20 January 2014
7 612 Mon, 20 January 2014 06:13
By: Solomon Yakobson
  SQL query
SQL developer, Oracle Clinical
By: draroda on Mon, 20 January 2014
4 438 Mon, 20 January 2014 01:54
By: Michel Cadot
  / (slash) character after END keyword
By: dancko on Sun, 19 January 2014
2 365 Sun, 19 January 2014 04:54
By: dancko
  how to find last updated date
By: preethia on Fri, 17 January 2014
9 764 Fri, 17 January 2014 11:40
By: Michel Cadot
  update with aggregate value
11.2.0.2.0
By: yuko on Thu, 16 January 2014
8 569 Fri, 17 January 2014 09:35
By: ThomasG
  Is this possible to drop the virtual column from table
Oracle 11g
By: na.dharma@gmail.com on Fri, 17 January 2014
3 399 Fri, 17 January 2014 06:44
By: pablolee
  Add a new column on first position of table in existing table.
Oracle 11g
By: na.dharma@gmail.com on Thu, 16 January 2014
8 871 Fri, 17 January 2014 01:18
By: Michel Cadot
  Primary Key in another Index
Oracle 11g, 11.2.0.2 Linux 64b
By: sujitm30 on Thu, 16 January 2014
3 339 Fri, 17 January 2014 01:15
By: evivek
  cursor loop
oracle 11 g
By: simplesanju on Wed, 15 January 2014
2 363 Thu, 16 January 2014 03:35
By: simplesanju
  Time out error in JAVA application when backend package is calling
By: na.dharma@gmail.com on Thu, 16 January 2014
5 339 Thu, 16 January 2014 01:16
By: Michel Cadot
  why would this query return three rows?
By: nataliafoster26 on Wed, 15 January 2014
2 325 Wed, 15 January 2014 15:11
By: Michel Cadot
  SQL to generate sequential numbers for each repeating row and reset upon new key
Oracle 9i R2
By: yasar2002 on Wed, 11 December 2013
4 820 Wed, 15 January 2014 08:01
By: Michel Cadot
  Want to use date variable value in select query
11g
By: cplusplus1 on Tue, 14 January 2014
7 1053 Tue, 14 January 2014 09:44
By: cookiemonster
  ORA-01481: invalid number format model
By: jackxu on Tue, 14 January 2014
4 967 Tue, 14 January 2014 09:43
By: BlackSwan
  How to find last sunday of month
By: aaditya321 on Tue, 14 January 2014
5 489 Tue, 14 January 2014 07:52
By: Solomon Yakobson
  ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired while gathering stats
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
By: athensromania on Mon, 13 January 2014
8 974 Tue, 14 January 2014 04:03
By: ThomasG
  Search String
oracle 10g,win xp
By: Xandot on Tue, 14 January 2014
2 346 Tue, 14 January 2014 02:47
By: Xandot
  Syntax for similar Pattern between the tables
Oracle 10 and 11g
By: imransi17@gmail.com on Mon, 13 January 2014
2 307 Tue, 14 January 2014 00:15
By: Michel Cadot
  Can someone help me with this
By: pingiliarjun on Thu, 09 January 2014
6 448 Mon, 13 January 2014 15:56
By: Bill B
  Re: XML issue (split from hijacked thread http://www.orafaq.com/forum/t/189540/)
By: KimberlyDeborah on Sat, 11 January 2014
2 302 Mon, 13 January 2014 04:45
By: KimberlyDeborah
  correct week number
oracle 11g
By: guddu_12 on Fri, 10 January 2014
5 472 Mon, 13 January 2014 04:38
By: guddu_12
  Find the last process in string
oracle 10g,win xp
By: Xandot on Fri, 10 January 2014
2 316 Sun, 12 January 2014 11:50
By: Xandot
  Permutation combination
ORACLE PL/SQL
By: banyan_sg on Wed, 08 January 2014
18 1115 Sun, 12 January 2014 04:34
By: Solomon Yakobson
  Case statement not working
Oracle 11g
By: kumaran22 on Fri, 10 January 2014
2 265 Fri, 10 January 2014 15:23
By: Michel Cadot
  i wanto to return One single row into column.
Oracle 11g
By: na.dharma@gmail.com on Fri, 10 January 2014
5 568 Fri, 10 January 2014 12:54
By: pablolee
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: Thu Aug 28 22:22:02 CDT 2014

Total time taken to generate the page: 0.72196 seconds