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
  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 566 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 370 Thu, 02 June 2016 07:43
By: Bill B
  package error
By: narang_me12 on Wed, 01 June 2016
7 468 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 5695 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 588 Tue, 31 May 2016 22:14
By: pstanand
  Filler / Bound Filler in External tables
oracle 11g
By: ORAGENASHOK on Tue, 31 May 2016
2 351 Tue, 31 May 2016 08:28
By: Bill B
  Loops
oracle 11g
By: Satheesh.A on Tue, 31 May 2016
7 427 Tue, 31 May 2016 04:03
By: Satheesh.A
  DDL commands
oracle 11g
By: Satheesh.A on Tue, 31 May 2016
2 292 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 695 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 558 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 749 Sat, 28 May 2016 06:37
By: Solomon Yakobson
  Indexes
oracle 11g
By: Satheesh.A on Fri, 27 May 2016
2 420 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 408 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 377 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 429 Thu, 26 May 2016 00:08
By: Michel Cadot
  function is not giving correct output
By: AmarendraSahoo2016 on Tue, 24 May 2016
4 351 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 407 Tue, 24 May 2016 21:35
By: arifs3738
  Problem while inserting data in unix env
By: amit.sonar on Mon, 23 May 2016
34 833 Tue, 24 May 2016 09:33
By: Michel Cadot
  first tuesday of every month ?
sql developer
By: nath123 on Fri, 20 May 2016
5 712 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 529 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 731 Mon, 23 May 2016 07:56
By: BlackSwan
  IN (or) Equality Operator
SQL
By: kirankumarmutte on Fri, 20 May 2016
9 1546 Fri, 20 May 2016 16:16
By: John Watson
  Display the columns of a table into rows delimited by comma
11.2.0.4
By: grpatwari on Wed, 18 May 2016
19 1504 Fri, 20 May 2016 09:54
By: Michel Cadot
  Pattern Matching for Multivalue
Oracle 11g R2
By: javed.khan on Tue, 03 May 2016
11 606 Fri, 20 May 2016 09:48
By: Bill B
  sysdate in the pivot in clause
Oracle 11.2.0.3
By: pointers on Thu, 19 May 2016
6 582 Fri, 20 May 2016 02:01
By: pointers
  Transpose Columns to Row group by
Oracle
By: dimveg on Thu, 19 May 2016
3 368 Fri, 20 May 2016 01:30
By: Barbara Boehmer
  Run dbms_scheduler.create_job with arguments
Oracle 11.2.0.1.0
By: dansrnt on Fri, 13 May 2016
9 484 Thu, 19 May 2016 20:35
By: dansrnt
  Query reporting
Oracle 11g
By: srinivas.k2005 on Thu, 19 May 2016
4 318 Thu, 19 May 2016 14:18
By: Barbara Boehmer
  Accessing Sub directory under Oracle directory
11g
By: harshadsp on Thu, 19 May 2016
6 707 Thu, 19 May 2016 13:08
By: Bill B
  split from Update 7% basic Salary by bb
By: Salehin on Thu, 19 May 2016
2 207 Thu, 19 May 2016 07:16
By: EdStevens
  Missing number in series of numbers
Oracle 11g, windows
By: Vijay55 on Wed, 18 May 2016
4 461 Thu, 19 May 2016 05:04
By: flyboy
  timestamp question
By: desmond30 on Tue, 17 May 2016
4 469 Wed, 18 May 2016 10:04
By: desmond30
  MEMBER OF condition across DB Link
11g2
By: mjm22 on Tue, 17 May 2016
7 448 Wed, 18 May 2016 04:32
By: mjm22
  Not a group by expression (but not in sqlplus)
VBA Windows 7
By: oteixeira on Tue, 17 May 2016
4 386 Tue, 17 May 2016 12:13
By: Michel Cadot
icon5.gif Compare 2 tables and upadte 1
pl sql
By: Helen_86 on Mon, 16 May 2016
13 595 Tue, 17 May 2016 12:10
By: Michel Cadot
  oracle server CPU spikes
oracle 12c
By: gorants on Sun, 15 May 2016
4 372 Tue, 17 May 2016 08:10
By: javed.khan
  Batch file to run sql script
11g
By: harshadsp on Fri, 13 May 2016
33 1524 Tue, 17 May 2016 05:51
By: harshadsp
  NUMBER to HEX, HEX to NUMBER
Oracle 11gR2, Oracle Linux
By: madhuridara on Tue, 10 May 2016
2 543 Mon, 16 May 2016 10:28
By: madhuridara
  oracle session leak
oracle 12c
By: gorants on Sun, 15 May 2016
3 374 Sun, 15 May 2016 22:35
By: BlackSwan
  Regular expression: letter category?
Any version supporting regular expressions
By: Michel Cadot on Sun, 15 May 2016
5 418 Sun, 15 May 2016 14:32
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: Sat Mar 25 20:39:48 CDT 2017

Total time taken to generate the page: 0.11133 seconds