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
  RAISE_APPLICATION_ERROR to display multiple line
11g
By: harshadsp on Fri, 10 June 2016
1 239 Fri, 10 June 2016 08:35
By: Bill B
  Oracle Special character while dbms_output
11g
By: harshadsp on Thu, 09 June 2016
16 645 Fri, 10 June 2016 03:29
By: harshadsp
  Rebuild table contain partition
Oracle database 10g
By: dophuong_cs on Wed, 08 June 2016
3 336 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 487 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 315 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 403 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 366 Tue, 07 June 2016 11:46
By: adfnewbie
  Number to words
pl sql
By: raghuramgupta on Tue, 07 June 2016
5 277 Tue, 07 June 2016 11:35
By: Bill B
  union all and sql*plus
By: Eugene on Thu, 26 December 2002
8 9800 Tue, 07 June 2016 06:38
By: EdStevens
  Convert Rows to Columns
Oracle 11g
By: arifs3738 on Sun, 05 June 2016
9 412 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 428 Sat, 04 June 2016 23:35
By: bdtran
  Pattern recognition problem
12.1.0.2
By: bdtran on Thu, 26 May 2016
11 522 Sat, 04 June 2016 13:10
By: bdtran
  Transpose rows to columns without aggregation
By: dancko on Sat, 04 June 2016
9 355 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 533 Fri, 03 June 2016 22:08
By: nath123
  Issue with UTL_FILE.INVALID_OPERATION
11g
By: namitanamburi on Wed, 01 June 2016
7 369 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 533 Fri, 03 June 2016 15:13
By: Michel Cadot
  transpose and insert the data
oracle 11g
By: tolupuluri on Fri, 27 May 2016
19 619 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 377 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 496 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 279 Thu, 02 June 2016 07:43
By: Bill B
  package error
By: narang_me12 on Wed, 01 June 2016
7 390 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 5203 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 415 Tue, 31 May 2016 22:14
By: pstanand
  Filler / Bound Filler in External tables
oracle 11g
By: ORAGENASHOK on Tue, 31 May 2016
2 257 Tue, 31 May 2016 08:28
By: Bill B
  Loops
oracle 11g
By: Satheesh.A on Tue, 31 May 2016
7 325 Tue, 31 May 2016 04:03
By: Satheesh.A
  DDL commands
oracle 11g
By: Satheesh.A on Tue, 31 May 2016
2 226 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 560 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 476 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 634 Sat, 28 May 2016 06:37
By: Solomon Yakobson
  Indexes
oracle 11g
By: Satheesh.A on Fri, 27 May 2016
2 359 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 310 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 308 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 349 Thu, 26 May 2016 00:08
By: Michel Cadot
  function is not giving correct output
By: AmarendraSahoo2016 on Tue, 24 May 2016
4 298 Wed, 25 May 2016 02:54
By: Michel Cadot
  Need to populate two more columns
Oracle 11g
By: arifs3738 on Tue, 24 May 2016
7 294 Tue, 24 May 2016 21:35
By: arifs3738
  Problem while inserting data in unix env
By: amit.sonar on Mon, 23 May 2016
34 726 Tue, 24 May 2016 09:33
By: Michel Cadot
  first tuesday of every month ?
sql developer
By: nath123 on Fri, 20 May 2016
5 565 Tue, 24 May 2016 08:46
By: Bill B
  Difference between Global Temporary Table and Collections in PLSQL
By: msyogi on Mon, 23 May 2016
6 411 Tue, 24 May 2016 08:30
By: Bill B
  Moving data older than 2 years in all fact tables to respective archive tables & purging data
Oracle 11g , SQL Developer, Windows
By: krisc2499 on Sat, 21 May 2016
10 620 Mon, 23 May 2016 07:56
By: BlackSwan
  IN (or) Equality Operator
SQL
By: kirankumarmutte on Fri, 20 May 2016
9 1437 Fri, 20 May 2016 16:16
By: John Watson
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: Sun Sep 25 14:12:07 CDT 2016

Total time taken to generate the page: 0.13416 seconds