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
ORA-01839: date not valid for month specified Oracle 10g By: rc3d on Fri, 01 November 2013	10	530	Fri, 08 November 2013 15:17 By: Bill B
Record vs Object problem Oracle 11g By: ageless1946 on Fri, 08 November 2013	3	268	Fri, 08 November 2013 12:40 By: ageless1946
Writing to CSV or excel using UTL_FILE in ORACLE By: nathran on Wed, 06 November 2013	7	500	Fri, 08 November 2013 06:36 By: Solomon Yakobson
How to count different items with one sentence instead of above? ORACLE By: zhaoquer on Mon, 04 November 2013	15	707	Fri, 08 November 2013 03:03 By: Lalit Kumar B
char to timestamp conversion 10G, unix By: babhuko on Thu, 07 November 2013	1	142	Thu, 07 November 2013 14:34 By: Solomon Yakobson
How to allow only numbers where condition substr(Object_id,7,10) oracle 11 By: cplusplus1 on Thu, 07 November 2013	4	223	Thu, 07 November 2013 08:26 By: Solomon Yakobson
Use of UPPER function with wild cards By: newbieinapps on Wed, 06 November 2013	5	288	Thu, 07 November 2013 02:14 By: ThomasG
ORA-06508: PL/SQL: could not find program unit being called oracle database 10g By: njnbat on Tue, 15 October 2013	12	675	Thu, 07 November 2013 00:00 By: njnbat
what array or collection type to use oracle 11g By: gentleman777us on Wed, 06 November 2013	11	505	Wed, 06 November 2013 15:19 By: gentleman777us
day,month year regex oracle 10g, unix By: babhuko on Mon, 04 November 2013	10	527	Tue, 05 November 2013 11:36 By: Solomon Yakobson
How to update data from backup table PL/SQL,ORACLE By: chary12345 on Mon, 04 November 2013	16	871	Tue, 05 November 2013 07:36 By: cookiemonster
syntax By: nataliafoster26 on Mon, 04 November 2013	3	245	Tue, 05 November 2013 02:49 By: gazzag
Transpose and dynamic column depending on result Oracle 10g By: rasi_85 on Mon, 04 November 2013	6	313	Mon, 04 November 2013 14:56 By: rasi_85
hours validation Oracle 10g,windows 7 By: thelearner on Fri, 01 November 2013	10	1598	Sat, 02 November 2013 11:29 By: Littlefoot
onchange By: nataliafoster26 on Fri, 01 November 2013	3	325	Sat, 02 November 2013 01:04 By: Lalit Kumar B
deferrable initially immediate Oracle 10g,windows 7 By: thelearner on Fri, 01 November 2013	3	1793	Fri, 01 November 2013 15:30 By: John Watson
Constraints in Describe Oracle 10g,windows 7 By: thelearner on Fri, 01 November 2013	1	191	Fri, 01 November 2013 12:49 By: Littlefoot
Loop in UTL_FILE is not getting closed oracle 11.2.0.3.0 - Windows server 2008 R2 By: muktha_22 on Fri, 01 November 2013	1	273	Fri, 01 November 2013 01:58 By: Littlefoot
CREATE New Table from existing tables ORACLE 11g By: arifugurel on Thu, 31 October 2013	7	338	Fri, 01 November 2013 01:20 By: Littlefoot
PL/SQL SQL DEVELOPER By: aravindreddy.akiti on Thu, 31 October 2013	4	373	Thu, 31 October 2013 18:38 By: Lalit Kumar B
select * from one table but not all tables in a query Oracle 11g By: seahaze on Wed, 30 October 2013	15	679	Thu, 31 October 2013 15:30 By: Lalit Kumar B
LONG data type obsolete - but Oracle use them in meta data (directory)? WTF? Oracle 10g By: rc3d on Thu, 31 October 2013	4	286	Thu, 31 October 2013 15:08 By: John Watson
XML Variables 10g r2 By: leeweb on Thu, 31 October 2013	2	196	Thu, 31 October 2013 10:32 By: Solomon Yakobson
Pivot query: grouping pivot field, using query for IN clause Oracle 11.2.0.1.0 By: OraFerro on Thu, 31 October 2013	4	409	Thu, 31 October 2013 07:06 By: flyboy
string to date Oracle 11g By: siraj.accet@gmail.com on Thu, 31 October 2013	7	404	Thu, 31 October 2013 05:38 By: Solomon Yakobson
convert local time to UTC oracle Database 11g Enterprise Edition Release 11.1.0.6.0 By: rkhatiwala on Wed, 30 October 2013	8	476	Wed, 30 October 2013 18:22 By: cookiemonster
Meaning of the piece of code Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production,TNS for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production By: gupta27 on Wed, 30 October 2013	7	305	Wed, 30 October 2013 16:03 By: Lalit Kumar B
Can we have 2 insert statements for 1 for loop Oracle 10g Forms, WinXP By: stalin4d on Wed, 30 October 2013	10	664	Wed, 30 October 2013 10:21 By: Lalit Kumar B
Troubleshoot procedure error Oracle 11g By: Santhosh05 on Wed, 23 October 2013	27	1140	Wed, 30 October 2013 07:44 By: cookiemonster
update with case using select 11.2.0.3.0 By: lijok on Wed, 30 October 2013	3	170	Wed, 30 October 2013 05:43 By: lijok
Pagination Query By: rameshaimhigh@gmail.com on Wed, 30 October 2013	1	157	Wed, 30 October 2013 02:48 By: Michel Cadot
Result from Rows to Columns Oracle 10g,Oracle11g By: chandan.rattan on Tue, 29 October 2013	8	431	Tue, 29 October 2013 10:37 By: Lalit Kumar B
getting total and single name in one query Oracle 10g By: sss111ind on Tue, 29 October 2013	7	432	Tue, 29 October 2013 10:25 By: sss111ind
Concatenating address fields Oracle 10g By: sss111ind on Mon, 28 October 2013	18	720	Tue, 29 October 2013 04:49 By: sss111ind
Separate string based on Comma (merged 2) Oracle 10g By: sss111ind on Mon, 28 October 2013	10	443	Tue, 29 October 2013 03:58 By: sss111ind
why it doesnt save in table By: nataliafoster26 on Mon, 28 October 2013	6	370	Tue, 29 October 2013 02:27 By: Littlefoot
Query for the below requirement 10.2.0.5 By: avineshr on Mon, 28 October 2013	5	360	Tue, 29 October 2013 01:17 By: Michel Cadot
sql By: walls on Mon, 28 October 2013	2	204	Mon, 28 October 2013 14:10 By: Lalit Kumar B
External Tables UNIX, Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production By: ind9 on Mon, 28 October 2013	1	251	Mon, 28 October 2013 11:52 By: Solomon Yakobson
XMLTYPE datatypw Oracle 10g By: ashish_sun123 on Mon, 28 October 2013	6	291	Mon, 28 October 2013 11:41 By: _jum