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
  Merge data to a table based on criteria
Oracle 11
By: Member2014 on Thu, 18 September 2014
13 661 Mon, 13 October 2014 11:51
By: Member2014
  query to quit after repeating values
By: chatwidravi on Sun, 12 October 2014
3 317 Sun, 12 October 2014 14:14
By: Solomon Yakobson
  ORA-02291: how to assign value to varchar2 variable depending on specific input?
By: Silently_Quiet_Logic on Sun, 12 October 2014
2 295 Sun, 12 October 2014 08:59
By: John Watson
  CASE STATEMENT IN DDL
Oracle 11g
By: kiwinz on Tue, 23 September 2014
10 553 Sun, 12 October 2014 04:02
By: kiwinz
  Analytic Function
11g
By: kiwinz on Sun, 12 October 2014
5 315 Sun, 12 October 2014 02:38
By: Michel Cadot
  ORDER BY 'constant' oracle partition
By: kiwinz on Thu, 25 September 2014
8 445 Sun, 12 October 2014 02:13
By: kiwinz
  PL/SQL home test
11g
By: dailyumm on Fri, 10 October 2014
3 364 Fri, 10 October 2014 10:08
By: EdStevens
  replace a letter '
Oracle 11g
By: rohan10k on Wed, 08 October 2014
9 390 Wed, 08 October 2014 09:17
By: Lalit Kumar B
  FORALL BULK COLLECT
Oracle 10g
By: ORAGENASHOK on Wed, 08 October 2014
21 465 Wed, 08 October 2014 08:25
By: joy_division
  Send email from DB server to mail server.
Postgresql
By: waheguru on Wed, 08 October 2014
4 295 Wed, 08 October 2014 05:26
By: waheguru
  Session specific data using gtt
Oracle 10g
By: ind!@2020 on Sat, 04 October 2014
13 567 Tue, 07 October 2014 04:29
By: cookiemonster
  How to avoid OR condition in the below scenario, how we can write in different ways
Oracle 11g
By: na.dharma@gmail.com on Fri, 03 October 2014
23 946 Tue, 07 October 2014 04:24
By: Lalit Kumar B
  Outer Join on Values
By: mayur.shinde511@gmail.com on Tue, 23 September 2014
8 486 Mon, 06 October 2014 22:49
By: mayur.shinde511@gmail.com
  how can i secure some row from my table
oracle database 10g, windows 7
By: x-oracle on Wed, 24 September 2014
16 611 Mon, 06 October 2014 11:46
By: Lalit Kumar B
  Please tell me use of DBMS_SCHEDULER ( 1 2)
By: aaditya321 on Tue, 23 September 2014
41 949 Mon, 06 October 2014 09:44
By: Lalit Kumar B
  XML to Oracle data import
By: babar82 on Mon, 06 October 2014
1 280 Mon, 06 October 2014 06:15
By: pablolee
  Strange Error 04021 timeout occurred while waiting to lock object <DIRECTORY>
Oracle 10g
By: donato on Wed, 01 October 2014
9 599 Mon, 06 October 2014 05:14
By: Michel Cadot
  Include row with out group by
Oracle 10g
By: ind!@2020 on Sat, 04 October 2014
5 441 Mon, 06 October 2014 03:41
By: Michel Cadot
  Question on LONG datatype
11g
By: andrewscharles89 on Sat, 04 October 2014
10 419 Sun, 05 October 2014 06:42
By: Solomon Yakobson
  New developer and facing trouble with a store procedure
Oracle 11g
By: new_techie_14 on Thu, 02 October 2014
7 420 Fri, 03 October 2014 07:40
By: EdStevens
  Re: Update trigger
Form 6i window 7 ultimate(32)
By: milikiel on Wed, 01 October 2014
3 414 Thu, 02 October 2014 08:49
By: CraigB
  table Data
6i
By: shahzad-ul-hasan on Tue, 30 September 2014
8 397 Wed, 01 October 2014 22:25
By: shahzad-ul-hasan
  SQL Query
Oracle 11g
By: srinivas.k2005 on Wed, 01 October 2014
7 375 Wed, 01 October 2014 10:59
By: Lalit Kumar B
  How to upload images into Oracle Table
Window7
By: Nasir.azeem on Tue, 30 September 2014
7 383 Wed, 01 October 2014 06:45
By: Nasir.azeem
  Help with pre 9i Join to ANSI standard
11, UNIX
By: sucheta on Tue, 30 September 2014
14 421 Wed, 01 October 2014 03:45
By: cookiemonster
  group by to_char resulting in Exception: ORA-00979: not a GROUP BY expression
OEM 12C
By: vjeedigunta on Mon, 29 September 2014
4 293 Tue, 30 September 2014 02:22
By: Lalit Kumar B
  ORA-12704: character set mismatch
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit, MS WINDOWS Server 2008
By: shahrir83 on Tue, 30 September 2014
1 241 Tue, 30 September 2014 02:20
By: Michel Cadot
  distribute grp_cd equally among the data
By: rkhatiwala on Fri, 26 September 2014
3 320 Mon, 29 September 2014 22:49
By: Lalit Kumar B
  Help WIth Fixing Errors In SQL Script
SQL Plus
By: Mckenzo101 on Sat, 27 September 2014
6 429 Mon, 29 September 2014 13:18
By: Bill B
  Regexp Replace - Replacement Problem
By: wintech on Sun, 28 September 2014
2 261 Sun, 28 September 2014 13:51
By: wintech
  Error with multi-dimenssional array.
By: amit.sonar on Thu, 25 September 2014
3 274 Sun, 28 September 2014 13:31
By: amit.sonar
  PLS-00306: wrong number or types of arguments in call to 'PR_4552'
Oralce 11g
By: na.dharma@gmail.com on Wed, 30 April 2014
11 680 Sat, 27 September 2014 13:39
By: pablolee
  Package of Analyze Partitions
Oracle 11R2
By: loupstr on Thu, 25 September 2014
6 353 Fri, 26 September 2014 16:12
By: CraigB
  Question about v$version
Oracle 10,11
By: lott42 on Fri, 26 September 2014
6 318 Fri, 26 September 2014 15:30
By: lott42
  stored procedure
oracle 10g
By: simplesanju on Fri, 26 September 2014
2 274 Fri, 26 September 2014 06:08
By: simplesanju
  Add # of days and then pass it as a variable
Oracle 11g release 2
By: azeem87 on Thu, 25 September 2014
5 300 Thu, 25 September 2014 14:56
By: azeem87
  order by query in sql
11g
By: haadiya on Thu, 25 September 2014
16 492 Thu, 25 September 2014 14:55
By: Bill B
  Unique constraint error
Oracle 11.2.0.2 G
By: aishvarya.singh on Thu, 25 September 2014
7 292 Thu, 25 September 2014 10:41
By: flyboy
  FOR UPDATE clause
ERP
By: chat2raj.s on Thu, 25 September 2014
4 280 Thu, 25 September 2014 10:41
By: sandeep_orafaq
  Need Sql query
By: mvrkr44 on Thu, 25 September 2014
9 358 Thu, 25 September 2014 05:58
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: Fri Nov 28 21:38:47 CST 2014

Total time taken to generate the page: 0.11306 seconds