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
How to use Row Generator Oracle 11g R2,RHEL 5.0 By: jimit_shaili on Tue, 16 April 2013	12	525	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	366	Wed, 17 April 2013 04:48 By: mkrish111
passing the char variable in cursors oracle 11g By: babashaik03 on Tue, 09 April 2013	9	500	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	373	Wed, 17 April 2013 04:36 By: babashaik03
PSP---PL/SQL Server Page By: shrinivas_talent on Wed, 17 April 2013	1	146	Wed, 17 April 2013 04:35 By: Michel Cadot
getting error ORA-04088 in trigger 11g By: babashaik03 on Thu, 11 April 2013	8	384	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	260	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	291	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	251	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	143	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	182	Tue, 16 April 2013 14:30 By: Michel Cadot
How to use pivot with parameters By: cornwall on Tue, 16 April 2013	4	277	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	170	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	182	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	253	Tue, 16 April 2013 09:22 By: Michel Cadot
Trigger By: ramanaapps on Tue, 16 April 2013	7	255	Tue, 16 April 2013 05:20 By: ramanaapps
Multiple Filter oracle 10g By: sss111ind on Tue, 02 April 2013	18	974	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	319	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	437	Mon, 15 April 2013 13:33 By: ashwani0301
passing column name to cursor at run time By: pankajdurve on Mon, 15 April 2013	2	281	Mon, 15 April 2013 11:44 By: Michel Cadot
Which join it is ????? Oracle 11g By: ashwani0301 on Mon, 15 April 2013	7	344	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	251	Mon, 15 April 2013 06:58 By: shivakm
Query for shift time By: urbanmojo on Fri, 12 April 2013	8	421	Mon, 15 April 2013 02:36 By: urbanmojo
duplicates issue - UNIQUE constraint orcale 11g By: JSKOBS on Fri, 12 April 2013	4	426	Mon, 15 April 2013 02:25 By: JSKOBS
Issue with Parallel Pipelined Oracle 11g By: Manoj.Gupta.91 on Tue, 09 April 2013	13	956	Mon, 15 April 2013 01:35 By: Manoj.Gupta.91
EXECUTE IMMEDIATE HELP By: ayomigs13 on Sun, 14 April 2013	3	680	Sun, 14 April 2013 14:08 By: ayomigs13
sql distinct row query oracle 10g By: pankajdurve on Sat, 13 April 2013	3	577	Sun, 14 April 2013 06:50 By: Amine
Print an update confirmation Oracle 11g By: mitpet123 on Sat, 13 April 2013	4	333	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	333	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	260	Sat, 13 April 2013 19:02 By: ammishra
Source code problem oracle 10g By: pankajdurve on Sat, 13 April 2013	2	184	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	262	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	166	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	346	Sat, 13 April 2013 08:04 By: Michel Cadot
Regular Expression in oracle 10g By: irfankundi786@yahoo.com on Sat, 13 April 2013	1	197	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	371	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	325	Fri, 12 April 2013 15:32 By: Not Easy
[Asking] What is the best practice to implement In Indexing oracle 11g, windows By: mei tambunan on Fri, 12 April 2013	9	213	Fri, 12 April 2013 12:27 By: joy_division
PL-00382 expression is of wrong type DB 11iR2 By: aceinc on Fri, 12 April 2013	1	146	Fri, 12 April 2013 12:19 By: Michel Cadot
Doubt sql query Oracle 11g By: YeisonSoto on Mon, 08 April 2013	10	584	Fri, 12 April 2013 09:03 By: flyboy