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 transfer data from non-partitioning table to partitioning table(2 Merged) oracle 11g in windows 7 profesional By: mei tambunan on Thu, 04 April 2013	10	268	Fri, 05 April 2013 01:25 By: Littlefoot
decode function TOAD 8.5.3.4 By: bhawnakaamra on Thu, 04 April 2013	3	363	Fri, 05 April 2013 00:04 By: bhawnakaamra
Please help me to build the query. oracle 10g By: ajaykumarkona on Thu, 28 March 2013	8	611	Wed, 03 April 2013 14:11 By: Bill B
multiple outer join oracle 11g By: miroconnect@yahoo.com on Wed, 03 April 2013	8	312	Wed, 03 April 2013 13:52 By: Michel Cadot
Query result more row return in oracle By: irfankundi786@yahoo.com on Wed, 03 April 2013	5	452	Wed, 03 April 2013 12:54 By: BlackSwan
partition of table - error in materialized view 10g, 10.2.0.4, windows Xp By: ishika_20 on Wed, 03 April 2013	2	382	Wed, 03 April 2013 06:19 By: ishika_20
How to find Currently running jobs? Oracle 9i By: bsm.java on Wed, 03 April 2013	8	561	Wed, 03 April 2013 06:13 By: delna.sexy
ReDefintion Oracle 11G By: elaiyavel on Wed, 03 April 2013	2	286	Wed, 03 April 2013 03:29 By: Michel Cadot
HOW TO COUNT NUMBER OF WORKING DAYS [merged 2 by jd] By: pankajdurve on Tue, 02 April 2013	5	531	Wed, 03 April 2013 01:14 By: delna.sexy
execute dynamic sql (2 Merged) 11g sql By: mahnazzz on Sat, 30 March 2013	6	454	Tue, 02 April 2013 22:16 By: BlackSwan
Wierd Behaviour of dates with Time zone oracle 11gR1 By: srinivas.k2005 on Mon, 12 March 2012	12	2005	Tue, 02 April 2013 13:45 By: cookiemonster
From with conditions pl-sql By: rtutus on Tue, 02 April 2013	1	280	Tue, 02 April 2013 10:18 By: flyboy
Analytics Vs. Aggregate Oracle 9i R2 By: Amine on Tue, 02 April 2013	4	438	Tue, 02 April 2013 08:10 By: flyboy
Materialized View Problem 9i By: emadnabil on Tue, 02 April 2013	6	449	Tue, 02 April 2013 07:22 By: John Watson
HANDLING INVALID_CURSOR ERROR By: pankajdurve on Tue, 02 April 2013	4	338	Tue, 02 April 2013 05:47 By: cookiemonster
case_not_found exception error oracle 10g By: pankajdurve on Tue, 02 April 2013	4	370	Tue, 02 April 2013 04:01 By: Michel Cadot
Finding Numeric , aplhanumeric , character oracle 11g By: ashwani0301 on Fri, 29 March 2013	7	409	Tue, 02 April 2013 04:01 By: Littlefoot
Database Trigger database 10.2 By: skamransajjad on Tue, 02 April 2013	1	390	Tue, 02 April 2013 02:10 By: Littlefoot
Reg Job Sheduler Oracle 10.2.0.4.0,Linux 5.4 64 bits By: nilesh_pawaskar on Tue, 02 April 2013	1	222	Tue, 02 April 2013 00:52 By: Michel Cadot
Batch Id from child statuses Oracle 11g By: renjivij on Wed, 27 March 2013	9	712	Tue, 02 April 2013 00:25 By: Michel Cadot
create a local report oracle 11g By: swapnabpnn on Mon, 01 April 2013	1	188	Mon, 01 April 2013 15:10 By: Littlefoot
Find the longest path Oracle 9i R2 By: Amine on Mon, 25 March 2013	11	692	Mon, 01 April 2013 14:40 By: Michel Cadot
Measure time overlap between 3 date ranges Oracle 11g By: mavericka on Thu, 28 March 2013	11	747	Mon, 01 April 2013 08:52 By: Solomon Yakobson
Reference cursor to generate the sequence number TOAD 8.5.3.4 By: bhawnakaamra on Mon, 01 April 2013	6	275	Mon, 01 April 2013 08:44 By: Michel Cadot
Weekly Report Oracle, 8.1.7.0.0,Windows 2007 By: kumarvk on Mon, 01 April 2013	2	310	Mon, 01 April 2013 03:51 By: Michel Cadot
Modifying the existing constraint 11G By: saipradyumn on Mon, 01 April 2013	1	295	Mon, 01 April 2013 01:25 By: Michel Cadot
Declaring a record type in a package spec ? By: somegirl on Fri, 29 March 2013	16	478	Sun, 31 March 2013 13:03 By: Michel Cadot
Duplicate rows displayed for a column - need to wrap 10g & AIX 6.1 By: gatetec on Sat, 30 March 2013	14	432	Sat, 30 March 2013 12:09 By: gatetec
Bulk Collect Oracle 10.2.0.1.0 By: jay_cooldude on Fri, 29 March 2013	7	491	Sat, 30 March 2013 10:51 By: dariyoosh
Words occurrence oracle 10.2 By: guddu_12 on Wed, 27 March 2013	8	704	Sat, 30 March 2013 08:32 By: Solomon Yakobson
Can I get this required result.? Oracle 11g R2 By: ranamirfan on Sat, 30 March 2013	5	333	Sat, 30 March 2013 04:09 By: ranamirfan
java.sql.SQLException: ORA-00936: missing expression: Occurign Randomly By: Shillu1 on Thu, 28 March 2013	5	274	Fri, 29 March 2013 13:39 By: Michel Cadot
Dynamic Rows Generate Oracle 10G (10.2.0.1.0 ), Windows 2003 By: mmohsinaziz on Fri, 29 March 2013	4	158	Fri, 29 March 2013 08:35 By: Michel Cadot
Migration oracle 10g,Mysql 5.5 By: siraj.accet@gmail.com on Fri, 01 February 2013	14	683	Fri, 29 March 2013 02:56 By: Michel Cadot
Create tabled of type Varray Oracle 11G R2, Win 7 By: gokul_ifs on Thu, 28 March 2013	4	447	Fri, 29 March 2013 01:56 By: gokul_ifs
Parsing BLOB Contents 11g By: SerenityNetworks on Thu, 28 March 2013	4	272	Thu, 28 March 2013 15:41 By: SerenityNetworks
row to column oracle 10g By: guddu_12 on Thu, 21 March 2013	11	615	Thu, 28 March 2013 11:38 By: Michel Cadot
Read only the input string from BLOB datatype column Oracle 10G By: Gana13 on Thu, 28 March 2013	7	564	Thu, 28 March 2013 07:14 By: _jum
Need a output from multilple rows return only one row in oracle? Oracle 10g By: victoryhendry on Wed, 27 March 2013	11	414	Thu, 28 March 2013 01:25 By: Michel Cadot
generating a key for grouping Oracle 11g By: Oracle1411 on Wed, 27 March 2013	4	359	Thu, 28 March 2013 01:24 By: Michel Cadot