OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
Anonymous PLSQL - need output with 0. Oracle 10g By: srinivas.k2005 on Wed, 17 April 2013	2	204	Wed, 17 April 2013 07:07 By: Solomon Yakobson
Functions within a Package Oracle Database 11g, Win 7 By: SQLer on Tue, 16 April 2013	4	324	Wed, 17 April 2013 05:41 By: SQLer
how to update column value with out using sequences oracle 11g By: mkrish111 on Wed, 17 April 2013	2	186	Wed, 17 April 2013 05:28 By: Michel Cadot
How to use Row Generator Oracle 11g R2,RHEL 5.0 By: jimit_shaili on Tue, 16 April 2013	12	496	Wed, 17 April 2013 05:26 By: Michel Cadot
updating the old values in trigger oracle 11g By: mkrish111 on Tue, 16 April 2013	4	343	Wed, 17 April 2013 04:48 By: mkrish111
passing the char variable in cursors oracle 11g By: babashaik03 on Tue, 09 April 2013	9	476	Wed, 17 April 2013 04:40 By: babashaik03
Is it possible to create a sequence in dml trigger? 11g By: babashaik03 on Fri, 12 April 2013	4	348	Wed, 17 April 2013 04:36 By: babashaik03
PSP---PL/SQL Server Page By: shrinivas_talent on Wed, 17 April 2013	1	137	Wed, 17 April 2013 04:35 By: Michel Cadot
getting error ORA-04088 in trigger 11g By: babashaik03 on Thu, 11 April 2013	8	346	Wed, 17 April 2013 04:34 By: babashaik03
Unable to insert Hindi language characters in Oracle 9i Oracle9i Enterprise Edition Release 9.2.0.8.0 By: mandark on Wed, 17 April 2013	1	227	Wed, 17 April 2013 02:14 By: Michel Cadot
updating the column with unique values with out using sequences By: babashaik03 on Wed, 17 April 2013	1	265	Wed, 17 April 2013 01:32 By: Michel Cadot
Retrieve the private package procedures information Oracle 10g, Oracle 11g By: paulito.santana on Tue, 16 April 2013	2	219	Wed, 17 April 2013 00:36 By: Michel Cadot
Table Data into a file. 10.1.0.3.0 By: yuvraaj on Tue, 16 April 2013	1	123	Tue, 16 April 2013 20:07 By: BlackSwan
table rows keep erasing themselves after I exit the session Oracle 11g, Toad for Oracle By: ApacheOmega on Tue, 16 April 2013	3	170	Tue, 16 April 2013 14:30 By: Michel Cadot
How to use pivot with parameters By: cornwall on Tue, 16 April 2013	4	240	Tue, 16 April 2013 14:23 By: Solomon Yakobson
Help with poor query 11.2.0.1 By: deepa_balu on Tue, 16 April 2013	1	159	Tue, 16 April 2013 12:53 By: Michel Cadot
Indexing in partition table oracle 11g, windows By: mei tambunan on Tue, 16 April 2013	2	166	Tue, 16 April 2013 09:23 By: Michel Cadot
Triggers, Procedures, Functions used as prompts to update and modify my Database Oracle 11g, Toad for Oracle By: ApacheOmega on Tue, 16 April 2013	9	231	Tue, 16 April 2013 09:22 By: Michel Cadot
Trigger By: ramanaapps on Tue, 16 April 2013	7	247	Tue, 16 April 2013 05:20 By: ramanaapps
Multiple Filter oracle 10g By: sss111ind on Tue, 02 April 2013	18	955	Tue, 16 April 2013 02:36 By: sss111ind
How to give Username and password when calling HTTP page? Oracle 11g,PL/SQL By: manikandank719 on Tue, 16 April 2013	1	303	Tue, 16 April 2013 01:25 By: Michel Cadot
how to select column at run time oracle 10g By: pankajdurve on Sat, 13 April 2013	9	403	Mon, 15 April 2013 13:33 By: ashwani0301
passing column name to cursor at run time By: pankajdurve on Mon, 15 April 2013	2	244	Mon, 15 April 2013 11:44 By: Michel Cadot
Which join it is ????? Oracle 11g By: ashwani0301 on Mon, 15 April 2013	7	325	Mon, 15 April 2013 09:29 By: BlackSwan
How make the complete schema public synonym..... Oracle, 11.2.0.1, Windows Sever 2008 R2. By: shivakm on Mon, 15 April 2013	2	228	Mon, 15 April 2013 06:58 By: shivakm
Query for shift time By: urbanmojo on Fri, 12 April 2013	8	404	Mon, 15 April 2013 02:36 By: urbanmojo
duplicates issue - UNIQUE constraint orcale 11g By: JSKOBS on Fri, 12 April 2013	4	401	Mon, 15 April 2013 02:25 By: JSKOBS
Issue with Parallel Pipelined Oracle 11g By: Manoj.Gupta.91 on Tue, 09 April 2013	13	905	Mon, 15 April 2013 01:35 By: Manoj.Gupta.91
EXECUTE IMMEDIATE HELP By: ayomigs13 on Sun, 14 April 2013	3	641	Sun, 14 April 2013 14:08 By: ayomigs13
sql distinct row query oracle 10g By: pankajdurve on Sat, 13 April 2013	3	541	Sun, 14 April 2013 06:50 By: Amine
Print an update confirmation Oracle 11g By: mitpet123 on Sat, 13 April 2013	4	320	Sun, 14 April 2013 04:43 By: Michel Cadot
A more elegant/flexible solution to sum five numbers Oracle 11g Express, Windows 8 By: Kimberlicious on Sat, 13 April 2013	7	304	Sat, 13 April 2013 20:11 By: rleishman
row modify in table oracle,11.2.0.2,unix By: ammishra on Fri, 12 April 2013	5	244	Sat, 13 April 2013 19:02 By: ammishra
Source code problem oracle 10g By: pankajdurve on Sat, 13 April 2013	2	154	Sat, 13 April 2013 09:43 By: BlackSwan
Function to Return Double Number - OUTPUT LOOKS WRONG Oracle 11g Express, Windows 8 By: Kimberlicious on Sat, 13 April 2013	3	222	Sat, 13 April 2013 09:26 By: Kimberlicious
Can I display a value (derived from calc) from a query into a new Row Oracle Database 10g Release 10.2.0.1.0 - Production By: ashora on Sat, 13 April 2013	1	153	Sat, 13 April 2013 08:06 By: Michel Cadot
Replacing vowels in a string Oracle 11g Express, Windows 8 By: Kimberlicious on Sat, 13 April 2013	5	299	Sat, 13 April 2013 08:04 By: Michel Cadot
Regular Expression in oracle 10g By: irfankundi786@yahoo.com on Sat, 13 April 2013	1	177	Sat, 13 April 2013 07:54 By: Michel Cadot
Need help with query Oracle 11g , Window 7 using Toad By: jxh461 on Thu, 11 April 2013	7	357	Fri, 12 April 2013 18:16 By: jxh461
Using VSIZE in a procedure 11g Express, Windows 8 By: Not Easy on Fri, 12 April 2013	6	250	Fri, 12 April 2013 15:32 By: Not Easy