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 :: Polls :: Message Navigator

Topic	Replies	Views	Last message
PL/SQL for Insert/Update ( 1 2) By: aimy on Thu, 12 February 2015	40	13938	Tue, 24 February 2015 03:50 By: Michel Cadot
Table Updates Oracle 11g By: Genesys on Mon, 23 February 2015	15	5332	Tue, 24 February 2015 00:39 By: Genesys
How to delete data from all the tables with one Query? 10g By: manisngpl on Mon, 23 February 2015	9	4358	Mon, 23 February 2015 12:34 By: Bill B
ora-22288 11gR2 RHEL5.5 By: smunir362 on Thu, 19 February 2015	6	5071	Sat, 21 February 2015 11:50 By: BlackSwan
New to using Oracle. Need help! By: jdmas on Thu, 19 February 2015	6	3282	Thu, 19 February 2015 12:41 By: Michel Cadot
To determine if the column value is decreasing Oracle 11g By: roblvl on Thu, 19 February 2015	2	2127	Thu, 19 February 2015 07:29 By: Littlefoot
Oracle 11g Query plan By: ramya_162 on Thu, 19 February 2015	2	1961	Thu, 19 February 2015 07:08 By: EdStevens
Trunc Date Oracle SQL By: naga78 on Thu, 19 February 2015	2	2917	Thu, 19 February 2015 05:35 By: Lalit Kumar B
Outer join restricts a condition RDBMS : 11.1.0.7.0 Oracle Applications : 12.1.2 By: mmasoomansari on Wed, 18 February 2015	3	3571	Thu, 19 February 2015 05:16 By: mmasoomansari
how to grant database link to user By: qanita786 on Tue, 17 February 2015	19	7436	Wed, 18 February 2015 02:41 By: gazzag
Concatenating numbers in virtual column expression throws ORA-12899: value too large for column Oracle database, 12.1.0.1 By: Lalit Kumar B on Tue, 17 February 2015	2	3397	Tue, 17 February 2015 02:29 By: Lalit Kumar B
Identity column inserts duplicates with Insert All statement, unique constraint violation Oracle database, 12.1.0.2, Any OS By: Lalit Kumar B on Tue, 17 February 2015	4	6784	Tue, 17 February 2015 02:20 By: Lalit Kumar B
"Client copy" with PL/SQL By: wurmi on Thu, 12 February 2015	19	7220	Sun, 15 February 2015 09:29 By: wurmi
fetch the same value with & without using the trunc ?? By: mist598 on Tue, 03 February 2015	24	8786	Sun, 15 February 2015 08:21 By: Lalit Kumar B
Split row into two or more rows Oracle 10G r2 By: mmohsinaziz on Thu, 12 February 2015	3	5447	Thu, 12 February 2015 23:48 By: Lalit Kumar B
Assign the SQL statement to a variable Oracle 9.1 By: mikelala on Tue, 10 February 2015	17	7921	Thu, 12 February 2015 22:55 By: BlackSwan
Need help on using regexp_substr in SQL Oracle 11g By: 3183h on Thu, 12 February 2015	2	2111	Thu, 12 February 2015 19:27 By: Barbara Boehmer
PLS-00597: PLSQL Record and Nested Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production, Windows 7 By: ninan on Wed, 11 February 2015	10	6910	Thu, 12 February 2015 10:42 By: Solomon Yakobson
convert string values into rows oracle11 By: oracle_Raj on Wed, 11 February 2015	6	3046	Thu, 12 February 2015 10:03 By: oracle_Raj
blog image display in utl_mail Oracle 10g By: m.abdulhaq on Thu, 12 February 2015	6	4864	Thu, 12 February 2015 05:15 By: m.abdulhaq
SQL output to HTML table in email notification - possible? By: RGall320 on Wed, 11 February 2015	1	2764	Wed, 11 February 2015 12:21 By: Mahesh Rajendran
Spliting of String Oracle 10g By: sss111ind on Thu, 05 February 2015	26	9217	Wed, 11 February 2015 07:36 By: BlackSwan
how do I produce columns based on values within a column By: Mr CPT on Wed, 11 February 2015	2	2476	Wed, 11 February 2015 07:25 By: Michel Cadot
Oracles recursive Connect By By: ksetty on Tue, 10 February 2015	7	3540	Tue, 10 February 2015 11:21 By: Solomon Yakobson
numeric value error By: orcle_us on Tue, 10 February 2015	19	7537	Tue, 10 February 2015 10:58 By: orcle_us
How to Create Database Link In Oracle 8.1.7 By: qanita786 on Tue, 10 February 2015	2	2140	Tue, 10 February 2015 06:35 By: Michel Cadot
split a number or dates by slab (merged) By: mahbbu on Sun, 08 February 2015	14	8224	Tue, 10 February 2015 05:39 By: gazzag
how to get column names from the table By: orcle_us on Sat, 07 February 2015	11	4956	Sun, 08 February 2015 08:58 By: orcle_us
Sql query to read the hardcoded values By: koyalmudi007@gmail.com on Fri, 06 February 2015	13	6431	Sun, 08 February 2015 06:28 By: Solomon Yakobson
ORA-06550: line 15, column 5: PLS-00103: Encountered the symbol "IF" when expecting one of the follo oracle11g By: orcle_us on Fri, 06 February 2015	14	12139	Sat, 07 February 2015 13:29 By: orcle_us
Getting boundaries 11.2.0.3 By: Amine on Tue, 03 February 2015	20	6105	Fri, 06 February 2015 15:03 By: Amine
Insert data through Java class Oracle 10g By: Xandot on Fri, 06 February 2015	7	3654	Fri, 06 February 2015 07:24 By: Lalit Kumar B
extract character between points By: mmm286 on Fri, 06 February 2015	8	3760	Fri, 06 February 2015 04:33 By: Littlefoot
query in CASE expression in select Oracle 11 By: pallaviprakash on Thu, 05 February 2015	3	60165	Fri, 06 February 2015 01:49 By: John Watson
More than one column in Connect by prior Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: mamalik on Mon, 02 February 2015	15	6582	Thu, 05 February 2015 23:52 By: Lalit Kumar B
Explain code Oracle,11.2.0.2.0 - Production,Win7 By: shumail on Wed, 04 February 2015	2	2494	Thu, 05 February 2015 00:53 By: Michel Cadot
How to make logic Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro By: shumail on Sun, 01 February 2015	10	5289	Wed, 04 February 2015 23:04 By: shumail
What is the effect of index for DELETE operation Oracle 11g By: rak.plsql on Sat, 31 January 2015	10	4579	Wed, 04 February 2015 03:46 By: Roachcoach
Convert to date Oracle 11g , Win XP By: rajivn786 on Fri, 23 January 2015	9	4661	Wed, 04 February 2015 02:55 By: cookiemonster
I want find how many hour,minutes,seconds is taken from task_stared and task_end. Oracle 11g By: na.dharma@gmail.com on Tue, 03 February 2015	6	3386	Tue, 03 February 2015 12:55 By: EdStevens