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
  order of geting value from sequence by trigger
Oracle 11g
By: miodas007 on Wed, 01 June 2016
6 3762 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 470 Sat, 11 June 2016 16:47
By: Barbara Boehmer
  Query that gives many different values
By: Jdevil on Fri, 20 May 2016
22 1116 Sat, 11 June 2016 10:43
By: EdStevens
  error 04063 creating view
By: loginel on Fri, 10 June 2016
3 339 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 322 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 570 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 204 Fri, 10 June 2016 08:35
By: Bill B
  Oracle Special character while dbms_output
11g
By: harshadsp on Thu, 09 June 2016
16 584 Fri, 10 June 2016 03:29
By: harshadsp
  Rebuild table contain partition
Oracle database 10g
By: dophuong_cs on Wed, 08 June 2016
3 298 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 452 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 255 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 366 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 312 Tue, 07 June 2016 11:46
By: adfnewbie
  Number to words
pl sql
By: raghuramgupta on Tue, 07 June 2016
5 255 Tue, 07 June 2016 11:35
By: Bill B
  union all and sql*plus
By: Eugene on Thu, 26 December 2002
8 9313 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 296 Mon, 06 June 2016 23:46
By: grpatwari
  Convert Rows to Columns
Oracle 11g
By: arifs3738 on Sun, 05 June 2016
9 352 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 377 Sat, 04 June 2016 23:35
By: bdtran
  Pattern recognition problem
12.1.0.2
By: bdtran on Thu, 26 May 2016
11 492 Sat, 04 June 2016 13:10
By: bdtran
  Transpose rows to columns without aggregation
By: dancko on Sat, 04 June 2016
9 310 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 481 Fri, 03 June 2016 22:08
By: nath123
  Issue with UTL_FILE.INVALID_OPERATION
11g
By: namitanamburi on Wed, 01 June 2016
7 316 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 486 Fri, 03 June 2016 15:13
By: Michel Cadot
  transpose and insert the data
oracle 11g
By: tolupuluri on Fri, 27 May 2016
19 581 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 348 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 459 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 247 Thu, 02 June 2016 07:43
By: Bill B
  package error
By: narang_me12 on Wed, 01 June 2016
7 351 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 4978 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 361 Tue, 31 May 2016 22:14
By: pstanand
  Filler / Bound Filler in External tables
oracle 11g
By: ORAGENASHOK on Tue, 31 May 2016
2 234 Tue, 31 May 2016 08:28
By: Bill B
  Loops
oracle 11g
By: Satheesh.A on Tue, 31 May 2016
7 279 Tue, 31 May 2016 04:03
By: Satheesh.A
  DDL commands
oracle 11g
By: Satheesh.A on Tue, 31 May 2016
2 199 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 511 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 424 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 562 Sat, 28 May 2016 06:37
By: Solomon Yakobson
  Indexes
oracle 11g
By: Satheesh.A on Fri, 27 May 2016
2 316 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 277 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 287 Thu, 26 May 2016 08:41
By: BlackSwan
  join table for top 5 and bottom 5
sql developer
By: nath123 on Wed, 25 May 2016
5 334 Thu, 26 May 2016 00: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: Thu Jul 28 05:44:07 CDT 2016

Total time taken to generate the page: 0.10218 seconds