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
replace string with hyphens Oracle 10g By: m.abdulhaq on Wed, 29 October 2014	8	342	Wed, 29 October 2014 06:06 By: Lalit Kumar B
dblink - stored proc By: lijjumathew on Mon, 27 October 2014	3	371	Tue, 28 October 2014 15:08 By: Bill B
Loading Multi line columns using external table Oracle 11g,OEL By: Jay1 on Sun, 26 October 2014	4	471	Tue, 28 October 2014 15:04 By: Bill B
Create partitioned table By: Malakay79 on Mon, 27 October 2014	10	675	Tue, 28 October 2014 15:02 By: Bill B
Sequence ora-8002 error for every connection. Oracle 12, Linux By: pradies on Tue, 28 October 2014	2	299	Tue, 28 October 2014 03:32 By: Michel Cadot
SQL Query Optimization Oracle 11g By: raj_te on Fri, 17 October 2014	27	971	Mon, 27 October 2014 10:46 By: raj_te
Merging Data from three sources and identifying duplicates PL/SQL By: mohammed.mca09@gmail.com on Sun, 26 October 2014	6	565	Sun, 26 October 2014 22:03 By: Barbara Boehmer
Merging two tables based on child table FK 11.2.0.1.0 By: OraFerro on Sun, 26 October 2014	1	304	Sun, 26 October 2014 05:34 By: Solomon Yakobson
REMOVE DUPLICATES IN ROWS TO COLUMN Oracle 10G r2 By: mmohsinaziz on Thu, 23 October 2014	11	564	Sat, 25 October 2014 10:35 By: Lalit Kumar B
how to write return in the function By: mist598 on Fri, 24 October 2014	7	402	Fri, 24 October 2014 09:45 By: Michel Cadot
Insert Hangs Oracle 10.0.2 By: nnr420 on Thu, 09 October 2014	24	869	Fri, 24 October 2014 03:11 By: Michel Cadot
SET Autocommit XXXX oracle 11g Release 2, Linux By: azeem87 on Wed, 22 October 2014	2	298	Wed, 22 October 2014 14:50 By: azeem87
FractionalAgents Oracle 11G By: samrams on Wed, 22 October 2014	3	283	Wed, 22 October 2014 12:35 By: Bill B
need sql query 11g By: mvrkr44 on Wed, 22 October 2014	3	340	Wed, 22 October 2014 10:31 By: John Watson
problem with case statement Oracle 10g By: bobghw on Mon, 20 October 2014	15	591	Tue, 21 October 2014 14:42 By: Michel Cadot
CREATE TABLE AS vs CREATE TABLE then INSERT PL/SQL Developer 10.0.5.1710 By: techiesue83 on Mon, 20 October 2014	13	657	Tue, 21 October 2014 13:30 By: knw15pwr
What is wrong with this trigger? Oracle, 10g, windows By: wzfoto on Fri, 17 October 2014	4	524	Mon, 20 October 2014 08:50 By: wzfoto
ORA-06502: PL/SQL: numeric or value error: character string buffer too small By: mist598 on Wed, 15 October 2014	13	997	Mon, 20 October 2014 00:05 By: Michel Cadot
How to Find Duplicate Groups (group of records) in Oracle Oracle 11g By: dhakanes@gmail.com on Fri, 26 September 2014	30	1586	Sun, 19 October 2014 19:14 By: Solomon Yakobson
to_date error By: irfankundi786@yahoo.com on Sat, 18 October 2014	4	669	Sun, 19 October 2014 07:39 By: Lalit Kumar B
How to calculate time variation between same day times. Oracle 10g R2, Windows Server 2008 64 bit By: mdsirajoddin on Wed, 15 October 2014	6	558	Sat, 18 October 2014 13:43 By: Lalit Kumar B
Generating Numbers between given ranges Oracle By: manubatham20 on Fri, 17 October 2014	8	413	Fri, 17 October 2014 15:05 By: BlackSwan
Need query Oracle Database 11g Enterprise Edition Release By: akash.nathile on Thu, 16 October 2014	7	432	Fri, 17 October 2014 08:54 By: Bill B
How to calculate age between timestamp ? By: tondapi on Fri, 17 October 2014	3	333	Fri, 17 October 2014 06:57 By: Michel Cadot
substring instr query SQL Oracle By: incrediblek on Fri, 17 October 2014	2	361	Fri, 17 October 2014 04:46 By: Lalit Kumar B
oracle By: shwetha naren on Thu, 16 October 2014	1	275	Thu, 16 October 2014 15:00 By: Michel Cadot
Need a hand finding the script Oracle 9i By: dmellobruce1987 on Thu, 16 October 2014	2	281	Thu, 16 October 2014 13:12 By: Michel Cadot
Replace every even number occurance of comma with # in a String Oracle 11g R2 By: javed.khan on Thu, 16 October 2014	5	370	Thu, 16 October 2014 05:24 By: javed.khan
Merge collections ? By: lijjumathew on Wed, 15 October 2014	2	272	Wed, 15 October 2014 22:50 By: Lalit Kumar B
DBMS_SCHEDULER and perl script Oracle 11.2, linux By: rrk1 on Wed, 15 October 2014	9	576	Wed, 15 October 2014 15:28 By: BlackSwan
complex view oracle By: mukulpratap43 on Wed, 15 October 2014	1	372	Wed, 15 October 2014 08:13 By: Michel Cadot
Please help in this problem TOAD By: praveen9728 on Wed, 15 October 2014	7	491	Wed, 15 October 2014 03:18 By: Lalit Kumar B
DBMS_SCHEDULER.Create_Job related Error Oracle 11g, Linux By: expertsudhir on Tue, 14 October 2014	4	595	Wed, 15 October 2014 02:30 By: John Watson
dbms_stats and bind variables enterprise 11.2.0.4 pl/sql By: projob66 on Mon, 13 October 2014	6	475	Tue, 14 October 2014 07:41 By: John Watson
PLS-00497:cannot mix between single row and multi-row (BULK) in INTO LIST Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production By: jhonnappier2007 on Mon, 13 October 2014	6	586	Tue, 14 October 2014 03:46 By: jhonnappier2007
Convert a string to a date using TO_DATE Function in after insert trigger? By: mattfriend on Mon, 13 October 2014	11	501	Tue, 14 October 2014 03:43 By: cookiemonster
The optimal approach to this search By: hahaie on Tue, 14 October 2014	3	354	Tue, 14 October 2014 02:26 By: hahaie
Select distinct rows before special character Oracle 11g By: abhayman on Mon, 13 October 2014	4	327	Mon, 13 October 2014 13:53 By: Michel Cadot
Merge data to a table based on criteria Oracle 11 By: Member2014 on Thu, 18 September 2014	13	758	Mon, 13 October 2014 11:51 By: Member2014
query to quit after repeating values By: chatwidravi on Sun, 12 October 2014	3	359	Sun, 12 October 2014 14:14 By: Solomon Yakobson