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
  Calculating values from two different tables by using SQL command.
Oracle 11g ver 11.2.0.1.0
By: faisal78 on Thu, 16 June 2016
5 427 Thu, 16 June 2016 08:39
By: Bill B
  Removing specific line from file using UTL_FILE
11g
By: harshadsp on Tue, 14 June 2016
6 569 Thu, 16 June 2016 02:33
By: harshadsp
  TO_NUMBER function not working
By: richard_oak on Wed, 15 June 2016
2 433 Wed, 15 June 2016 17:56
By: richard_oak
  "ORA-22813: operand value exceeds system limits" on executing sql returning XMLTYPE data
Oracle 11g
By: Nikita_01 on Tue, 14 June 2016
12 1083 Wed, 15 June 2016 13:01
By: Michel Cadot
  What is wrong with this sql code?
By: anticristo on Tue, 14 June 2016
3 541 Wed, 15 June 2016 07:34
By: EdStevens
  regexp replace
Oracle 11g, Win 7
By: rajivn786 on Tue, 14 June 2016
9 510 Tue, 14 June 2016 15:55
By: Bill B
  External Table and Blank spaces
Oracle 12C Windows NT
By: pstanand on Mon, 13 June 2016
14 7810 Tue, 14 June 2016 11:01
By: Michel Cadot
  order of geting value from sequence by trigger
Oracle 11g
By: miodas007 on Wed, 01 June 2016
6 3952 Mon, 13 June 2016 09:58
By: Bill B
icon5.gif Extract the most data after joining 3 tables
Oracle SQL
By: misy on Sat, 11 June 2016
8 618 Sat, 11 June 2016 16:47
By: Barbara Boehmer
  Query that gives many different values
By: Jdevil on Fri, 20 May 2016
22 1340 Sat, 11 June 2016 10:43
By: EdStevens
  error 04063 creating view
By: loginel on Fri, 10 June 2016
3 518 Fri, 10 June 2016 17:31
By: Barbara Boehmer
icon5.gif Listing individual average price
Oracle SQL
By: misy on Thu, 09 June 2016
3 444 Fri, 10 June 2016 12:00
By: misy
  Query Date Ranges with select statement (merged 3)
Oracle SQL
By: basitfaazal on Tue, 07 June 2016
12 833 Fri, 10 June 2016 08:36
By: Bill B
  RAISE_APPLICATION_ERROR to display multiple line
11g
By: harshadsp on Fri, 10 June 2016
1 317 Fri, 10 June 2016 08:35
By: Bill B
  Oracle Special character while dbms_output
11g
By: harshadsp on Thu, 09 June 2016
16 784 Fri, 10 June 2016 03:29
By: harshadsp
  Rebuild table contain partition
Oracle database 10g
By: dophuong_cs on Wed, 08 June 2016
3 524 Thu, 09 June 2016 01:01
By: Michel Cadot
  How To Update Encrypted Password for all user id's using Update Query
Oracle 11
By: ramraju20000 on Tue, 07 June 2016
13 610 Wed, 08 June 2016 18:30
By: Solomon Yakobson
  Read/write files from remote server using utl_file in oracle
oracle 11g
By: tolupuluri on Wed, 08 June 2016
3 620 Wed, 08 June 2016 09:52
By: tolupuluri
  behaviour of to_timestamp and time zones
Win10, Oracle 12c
By: GusGF on Mon, 06 June 2016
5 594 Wed, 08 June 2016 04:47
By: GusGF
  Collections in plsql - syntax
Oracle 11.2.0.4.0
By: adfnewbie on Mon, 06 June 2016
5 467 Tue, 07 June 2016 11:46
By: adfnewbie
  Number to words
pl sql
By: raghuramgupta on Tue, 07 June 2016
5 390 Tue, 07 June 2016 11:35
By: Bill B
  union all and sql*plus
By: Eugene on Thu, 26 December 2002
8 11427 Tue, 07 June 2016 06:38
By: EdStevens
  Convert Rows to Columns
Oracle 11g
By: arifs3738 on Sun, 05 June 2016
9 548 Mon, 06 June 2016 08:21
By: Michel Cadot
  Adding Cells from two different tables
12.1.0.2
By: bdtran on Thu, 02 June 2016
5 560 Sat, 04 June 2016 23:35
By: bdtran
  Pattern recognition problem
12.1.0.2
By: bdtran on Thu, 26 May 2016
11 657 Sat, 04 June 2016 13:10
By: bdtran
  Transpose rows to columns without aggregation
By: dancko on Sat, 04 June 2016
9 479 Sat, 04 June 2016 12:17
By: dancko
  try to insert data in to table using procedure
sql developer
By: nath123 on Thu, 02 June 2016
13 689 Fri, 03 June 2016 22:08
By: nath123
  Issue with UTL_FILE.INVALID_OPERATION
11g
By: namitanamburi on Wed, 01 June 2016
7 528 Fri, 03 June 2016 18:58
By: namitanamburi
  FIFO Algorithm to calculate Avg weighted value
Oracle 10g
By: anil029 on Thu, 02 June 2016
15 729 Fri, 03 June 2016 15:13
By: Michel Cadot
  transpose and insert the data
oracle 11g
By: tolupuluri on Fri, 27 May 2016
19 752 Thu, 02 June 2016 15:56
By: tolupuluri
  percentages of data population
Oracle 11.2.0.3
By: pointers on Tue, 31 May 2016
10 495 Thu, 02 June 2016 14:32
By: Bill B
  Data not inserted after MView creation
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0
By: smvmohan on Mon, 30 May 2016
14 582 Thu, 02 June 2016 14:28
By: Bill B
  encrypt and decrypt URL
Oracle Database 11.2.0.3
By: metal_navin on Wed, 01 June 2016
1 387 Thu, 02 June 2016 07:43
By: Bill B
  package error
By: narang_me12 on Wed, 01 June 2016
7 482 Thu, 02 June 2016 07:38
By: Bill B
  E-Mail sending issue from Oracle Database
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
By: Manoj.Gupta.91 on Fri, 12 December 2014
15 5758 Wed, 01 June 2016 02:54
By: Paul_A
  Chinese Characters not display in table
Oracle 12C UNIX
By: pstanand on Tue, 31 May 2016
19 617 Tue, 31 May 2016 22:14
By: pstanand
  Filler / Bound Filler in External tables
oracle 11g
By: ORAGENASHOK on Tue, 31 May 2016
2 367 Tue, 31 May 2016 08:28
By: Bill B
  Loops
oracle 11g
By: Satheesh.A on Tue, 31 May 2016
7 445 Tue, 31 May 2016 04:03
By: Satheesh.A
  DDL commands
oracle 11g
By: Satheesh.A on Tue, 31 May 2016
2 308 Tue, 31 May 2016 02:06
By: Michel Cadot
  Reverse row to column and column to row
Oracle 11
By: iliyan_84@abv.bg on Thu, 26 May 2016
14 719 Sat, 28 May 2016 14:08
By: Michel Cadot
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: Mon Apr 24 08:22:29 CDT 2017

Total time taken to generate the page: 0.05713 seconds