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
Announcement: How to use [code] tags and make your code easier to read? Other people will appreciate it By: Littlefoot on Mon, 05 September 2011	0	30160	Mon, 05 September 2011 02:20 By: Littlefoot
ORA-00984: column not allowed here Oracle By: manchev on Sat, 25 May 2013	6	59	Sun, 26 May 2013 00:19 By: Michel Cadot
select the greatest number from the row Oracle 10g, Win7 By: nischalinn on Tue, 18 September 2012	18	691	Sat, 25 May 2013 20:55 By: jstubing
Bill of Materials 11g R2 By: robert1981 on Fri, 24 May 2013	8	332	Sat, 25 May 2013 16:11 By: Solomon Yakobson
SQL Query Help PL/SQL By: jweingarth1 on Fri, 17 May 2013	4	723	Sat, 25 May 2013 15:55 By: Barbara Boehmer
Need to run query multiple times with time gap oracle 10g By: samir2012 on Sat, 25 May 2013	9	252	Sat, 25 May 2013 08:16 By: Solomon Yakobson
How to construct a SQL query to fetch different rows from same table in different columns? Oracle 10 By: syedabdulbaqi on Sat, 25 May 2013	5	164	Sat, 25 May 2013 05:29 By: syedabdulbaqi
Scheduling same job with different timing. Oracle 10g By: sss111ind on Fri, 24 May 2013	7	180	Fri, 24 May 2013 11:21 By: sss111ind
Find and trace custom view/procedure... By: gatetec on Fri, 24 May 2013	7	163	Fri, 24 May 2013 10:45 By: Michel Cadot
Create Index on Multiple tables 10.2.0.5 standard edition Micsoft windows 2008 By: AnilKampiri on Tue, 21 May 2013	7	264	Fri, 24 May 2013 10:37 By: Michel Cadot
NTILE Issue By: fakru.y on Fri, 24 May 2013	2	129	Fri, 24 May 2013 10:26 By: Michel Cadot
How to extract full text from clob where I have a distict select Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 SunOS ts0503 5.10 Generic_141445-09 i86pc i386 i86pc By: jimmy_s_abraham@yahoo.com on Thu, 23 May 2013	28	358	Fri, 24 May 2013 10:24 By: Michel Cadot
Another example of the "start of group method" 9.2.0.8 Win2003 Server By: Amine on Fri, 24 May 2013	0	160	Fri, 24 May 2013 09:10 By: Amine
dbms_lock.sleep By: ora1980 on Wed, 22 May 2013	7	323	Fri, 24 May 2013 07:43 By: Bill B
Replacing multiple characters By: scottwmackey on Tue, 21 May 2013	18	596	Thu, 23 May 2013 18:57 By: Solomon Yakobson
How to use window functions in where clause without inline view By: vikram1780 on Thu, 16 May 2013	2	247	Thu, 23 May 2013 16:48 By: Bill B
Procedure which converts salary By: aslan on Thu, 23 May 2013	1	81	Thu, 23 May 2013 14:07 By: Michel Cadot
Variable in the FROM clause 11GXE, Windows XP By: abnk on Wed, 08 May 2013	21	686	Thu, 23 May 2013 12:53 By: Michel Cadot
PL/SQL HELP By: kolpalamayaw on Thu, 23 May 2013	2	162	Thu, 23 May 2013 08:31 By: Michel Cadot
Conversion By: DUTTA@TARUN on Thu, 23 May 2013	2	116	Thu, 23 May 2013 05:08 By: pablolee
ORA-06550: (2 Merged) By: atirtil on Wed, 22 May 2013	17	383	Thu, 23 May 2013 04:32 By: atirtil
Database Link Problem Oracle Sql Plsql By: swapnilpimple on Wed, 22 May 2013	1	110	Thu, 23 May 2013 00:04 By: Michel Cadot
Retrieve view definiton Oracle 9.2.0.8, Win2003 server By: Amine on Mon, 20 May 2013	31	596	Thu, 23 May 2013 00:03 By: Michel Cadot
'UTL_SMTP' Oracle 10g By: Baharul on Wed, 22 May 2013	3	229	Wed, 22 May 2013 08:57 By: Michel Cadot
please help,Error(15,22): PLS-00382: expression is of wrong type By: fared240 on Wed, 22 May 2013	3	270	Wed, 22 May 2013 07:59 By: fared240
How the SQL hash is computed ? By: Amine on Wed, 22 May 2013	4	320	Wed, 22 May 2013 07:12 By: Michel Cadot
Please help me to implement this. Oracle 11g By: ajaykumarkona on Mon, 20 May 2013	7	464	Wed, 22 May 2013 05:57 By: Michel Cadot
Display data in Chinese language in window 7 oracle 11g By: ashwani0301 on Tue, 21 May 2013	7	245	Wed, 22 May 2013 03:51 By: ashwani0301
Can Any one please tell me how this query working??? By: mdsirajoddin on Tue, 21 May 2013	6	390	Wed, 22 May 2013 00:49 By: Littlefoot
lock table (2 Merged) oracle database 11g By: mahnazzz on Tue, 21 May 2013	3	206	Wed, 22 May 2013 00:47 By: Littlefoot
Order by in Date Column Oracle 116 By: feroze on Mon, 20 May 2013	3	300	Tue, 21 May 2013 14:55 By: Bill B
Cursor and variable issue. Oracle 7.3 By: CyberGoo on Mon, 20 May 2013	15	613	Tue, 21 May 2013 09:32 By: CyberGoo
Variable is NULL ORACLE 11G By: Johnqiu on Tue, 21 May 2013	13	224	Tue, 21 May 2013 08:38 By: Johnqiu
Tablespace Monitoring script oracle 10g By: x-oracle on Mon, 20 May 2013	6	289	Tue, 21 May 2013 08:19 By: BlackSwan
utl_file error oracle 9i By: umesh seth on Tue, 14 May 2013	9	262	Mon, 20 May 2013 20:22 By: Barbara Boehmer
Join in Insert By: Taha on Mon, 20 May 2013	2	184	Mon, 20 May 2013 07:09 By: Solomon Yakobson
Understanding Primary Key/Composite Key By: Taha on Fri, 17 May 2013	12	302	Mon, 20 May 2013 06:55 By: Taha
Truncate Master Table Issue General - All By: Wah_has on Fri, 17 May 2013	15	729	Mon, 20 May 2013 03:46 By: Michel Cadot
VARRAY Issue Oracle Database 11g 11.2.0.2.0 - 64bit, Unix By: sap_arul on Wed, 15 May 2013	12	496	Fri, 17 May 2013 08:18 By: mnitu
Need help on SQL join. Oracle 11gR2 By: gokul_ifs on Tue, 14 May 2013	8	496	Fri, 17 May 2013 07:11 By: Kevin Meade