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
  GRANTS to user to insert data in table with procedure
By: Alexey.Samoilov on Wed, 02 April 2014
2 242 Wed, 02 April 2014 02:27
By: Alexey.Samoilov
  Change by query widt
Change by query without group operation
By: Alexey.Samoilov on Tue, 01 April 2014
2 225 Wed, 02 April 2014 01:45
By: Alexey.Samoilov
  Grant Create Table On few tables
Oracle 11g Release 2
By: azeem87 on Tue, 01 April 2014
4 256 Tue, 01 April 2014 18:29
By: EdStevens
  Query that will compare two tables row by row and returns distinct rows from both tables
By: Alexey.Samoilov on Tue, 01 April 2014
4 348 Tue, 01 April 2014 15:00
By: Solomon Yakobson
  raise error propagation
oracle 11g2, windows os
By: anncao on Tue, 01 April 2014
1 155 Tue, 01 April 2014 12:07
By: BlackSwan
  VIEW with Global Variables - help needed
By: oralover2006 on Tue, 01 April 2014
2 295 Tue, 01 April 2014 07:04
By: oralover2006
  creating oracle tablespace and quotasize dynamically
ORACLE 11g
By: santhosha4db on Tue, 01 April 2014
17 814 Tue, 01 April 2014 04:59
By: Michel Cadot
  Longest word PL SQL
By: Ben892 on Mon, 31 March 2014
3 353 Tue, 01 April 2014 01:16
By: John Watson
  30 minute Time Interval
By: ertweety11 on Wed, 26 March 2014
17 1021 Mon, 31 March 2014 05:37
By: oralover2006
  Case statement with null in where clause
oracle 10g, Toad, xp
By: Crimzon on Sun, 30 March 2014
2 417 Sun, 30 March 2014 12:07
By: Solomon Yakobson
  How to store GMT timestamp in Database from SQL Developer import excelsheet
Oracle 11g R2
By: cpadesur on Sun, 30 March 2014
3 444 Sun, 30 March 2014 07:45
By: Solomon Yakobson
  ORA-00904: "CNT": invalid identifier error
Oralce 11g
By: na.dharma@gmail.com on Sat, 29 March 2014
2 338 Sat, 29 March 2014 07:28
By: na.dharma@gmail.com
  How to handle error in 5th counting on cursor
By: aaditya321 on Sat, 29 March 2014
4 380 Sat, 29 March 2014 04:00
By: dariyoosh
  Union??? or Merge of tables
By: ertweety11 on Fri, 28 March 2014
3 306 Fri, 28 March 2014 15:43
By: BlackSwan
  how to use substr if the error ORA-01403: no data found.
By: mist598 on Fri, 28 March 2014
3 293 Fri, 28 March 2014 09:07
By: cookiemonster
  Nested Select for summary
11g
By: andysam23586 on Fri, 28 March 2014
3 286 Fri, 28 March 2014 08:54
By: BlackSwan
icon5.gif Sorting Issue
ORACLE 9i
By: Sandeep321 on Thu, 27 March 2014
18 602 Fri, 28 March 2014 05:37
By: Solomon Yakobson
  Unable to update a table at remote db in named pl/sql procedure
By: sonalpatel_cse on Thu, 27 March 2014
2 199 Thu, 27 March 2014 13:27
By: Solomon Yakobson
  use of EXTEND in Collection in NESTED TABLES
By: mist598 on Thu, 27 March 2014
7 487 Thu, 27 March 2014 03:56
By: mist598
  One more condition in this script
Oracle,8.1.7.0.0,Windows 2003 Server
By: kumarvk on Wed, 26 March 2014
8 480 Thu, 27 March 2014 03:35
By: cookiemonster
  where can i call the procedure in the procedure in the package
By: mist598 on Wed, 26 March 2014
11 539 Wed, 26 March 2014 08:18
By: cookiemonster
  Please help - comma separated values
Oracle Database 11g Release 11.2.0.3.0
By: oralover2006 on Wed, 26 March 2014
6 383 Wed, 26 March 2014 05:50
By: oralover2006
  Oracle transpose rows into columns
Oracle 11g
By: developer12 on Mon, 24 March 2014
12 849 Wed, 26 March 2014 03:13
By: Michel Cadot
  if in field value "Delete", then don't join other table
Oracle 10g
By: rc3d on Mon, 24 March 2014
5 443 Tue, 25 March 2014 05:56
By: cookiemonster
  Insufficient privileges in DBMS_SESSION.SET_CONTEXT
Oracle 11.2.0.1.0 on OEL 5.7
By: Andrey_R on Sun, 23 March 2014
4 705 Tue, 25 March 2014 04:57
By: Andrey_R
  Dynamic column selection
11g
By: okela_vp on Tue, 10 December 2013
6 612 Tue, 25 March 2014 00:14
By: Barbara Boehmer
  Problem in external table ( 1 2)
By: aaditya321 on Tue, 11 March 2014
65 3029 Mon, 24 March 2014 13:10
By: aaditya321
  Insert statements
Oracle 11g
By: srinivas.k2005 on Wed, 12 March 2014
4 388 Mon, 24 March 2014 12:38
By: Michel Cadot
  generate xls file through pl/sql
By: tisekofti on Sat, 22 March 2014
7 602 Mon, 24 March 2014 08:27
By: cookiemonster
  computing statistics at the schema level
11g
By: ashwanth77 on Mon, 24 March 2014
2 249 Mon, 24 March 2014 07:40
By: EdStevens
  comparing the result of multiple SELECT statements
Oracle 11g, Win7
By: nischalinn on Mon, 24 March 2014
5 255 Mon, 24 March 2014 07:10
By: Michel Cadot
icon4.gif How? - Create Check constraint - field must contain @ symbol
Oracle llg Apex
By: Oracleuser14 on Mon, 24 March 2014
2 225 Mon, 24 March 2014 06:52
By: Michel Cadot
  Error while executing the plsql block for mview refresh
oracle 11g
By: narendra.treddi on Thu, 20 March 2014
10 457 Mon, 24 March 2014 06:46
By: Michel Cadot
  Please help for ORA-01416: two tables cannot be outer-joined to each other
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Mon, 24 March 2014
4 281 Mon, 24 March 2014 04:39
By: msol25
  How to display Last Day In Week Indicate As Y or N as input is start date and end date
Windows
By: spatil522@gmail.com on Mon, 24 March 2014
1 174 Mon, 24 March 2014 03:44
By: Littlefoot
  Time Elapsed
By: mist598 on Wed, 19 March 2014
9 632 Mon, 24 March 2014 01:49
By: vslabs
  update rows based on column values
oracle 10g
By: m.abdulhaq on Sun, 23 March 2014
11 720 Sun, 23 March 2014 09:27
By: m.abdulhaq
  sql query logic
oracle 10g
By: cvasi555 on Sat, 22 March 2014
7 440 Sun, 23 March 2014 01:04
By: Littlefoot
  count rows grouped by column name
By: carswelljr on Fri, 21 March 2014
5 452 Sat, 22 March 2014 01:41
By: Michel Cadot
  assign variable a calculated value in pl/sql
sql plus , windows 7
By: kevinb85 on Thu, 20 March 2014
12 740 Fri, 21 March 2014 04:57
By: cookiemonster
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 Sep 20 09:39:58 CDT 2014

Total time taken to generate the page: 0.06945 seconds