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
  External Table and Blank spaces
Oracle 12C Windows NT
By: pstanand on Mon, 13 June 2016
14 7632 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 3789 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 494 Sat, 11 June 2016 16:47
By: Barbara Boehmer
  Query that gives many different values
By: Jdevil on Fri, 20 May 2016
22 1151 Sat, 11 June 2016 10:43
By: EdStevens
  error 04063 creating view
By: loginel on Fri, 10 June 2016
3 357 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 334 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 606 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 220 Fri, 10 June 2016 08:35
By: Bill B
  Oracle Special character while dbms_output
11g
By: harshadsp on Thu, 09 June 2016
16 620 Fri, 10 June 2016 03:29
By: harshadsp
  Rebuild table contain partition
Oracle database 10g
By: dophuong_cs on Wed, 08 June 2016
3 318 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 471 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 285 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 386 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 329 Tue, 07 June 2016 11:46
By: adfnewbie
  Number to words
pl sql
By: raghuramgupta on Tue, 07 June 2016
5 267 Tue, 07 June 2016 11:35
By: Bill B
  union all and sql*plus
By: Eugene on Thu, 26 December 2002
8 9528 Tue, 07 June 2016 06:38
By: EdStevens
  query to write rows to column values
11.2.0.4
By: grpatwari on Tue, 31 May 2016
7 307 Mon, 06 June 2016 23:46
By: grpatwari
  Convert Rows to Columns
Oracle 11g
By: arifs3738 on Sun, 05 June 2016
9 381 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 407 Sat, 04 June 2016 23:35
By: bdtran
  Pattern recognition problem
12.1.0.2
By: bdtran on Thu, 26 May 2016
11 508 Sat, 04 June 2016 13:10
By: bdtran
  Transpose rows to columns without aggregation
By: dancko on Sat, 04 June 2016
9 324 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 508 Fri, 03 June 2016 22:08
By: nath123
  Issue with UTL_FILE.INVALID_OPERATION
11g
By: namitanamburi on Wed, 01 June 2016
7 332 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 511 Fri, 03 June 2016 15:13
By: Michel Cadot
  transpose and insert the data
oracle 11g
By: tolupuluri on Fri, 27 May 2016
19 603 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 361 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 481 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 263 Thu, 02 June 2016 07:43
By: Bill B
  package error
By: narang_me12 on Wed, 01 June 2016
7 370 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 5080 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 391 Tue, 31 May 2016 22:14
By: pstanand
  Filler / Bound Filler in External tables
oracle 11g
By: ORAGENASHOK on Tue, 31 May 2016
2 240 Tue, 31 May 2016 08:28
By: Bill B
  Loops
oracle 11g
By: Satheesh.A on Tue, 31 May 2016
7 306 Tue, 31 May 2016 04:03
By: Satheesh.A
  DDL commands
oracle 11g
By: Satheesh.A on Tue, 31 May 2016
2 211 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 533 Sat, 28 May 2016 14:08
By: Michel Cadot
icon2.gif Empolyees doesn't have any reportess
oracle 11 g
By: saipradyumn on Fri, 27 May 2016
9 452 Sat, 28 May 2016 08:53
By: Michel Cadot
  Last Record
oracle 11g, 11.2.0.4 , windows
By: Satheesh.A on Fri, 27 May 2016
13 589 Sat, 28 May 2016 06:37
By: Solomon Yakobson
  Indexes
oracle 11g
By: Satheesh.A on Fri, 27 May 2016
2 334 Fri, 27 May 2016 07:25
By: Satheesh.A
  Dynamic SQL Select query (merged)
PL/SQL
By: richard_oak on Thu, 26 May 2016
5 297 Thu, 26 May 2016 12:19
By: BlackSwan
  Different values of count(*) and num_rows of table
11g, 11.2.0.1, windows server 2008
By: ashishkumarmahanta80 on Thu, 26 May 2016
12 304 Thu, 26 May 2016 08:41
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: Fri Aug 26 09:06:17 CDT 2016

Total time taken to generate the page: 0.14046 seconds