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
regexp_replace() function help By: wtolentino on Thu, 30 November 2017	9	3370	Fri, 01 December 2017 08:57 By: wtolentino
Function Creation By: WhoAmI on Wed, 29 November 2017	5	2941	Thu, 30 November 2017 03:31 By: cookiemonster
switch data positions By: wtolentino on Tue, 28 November 2017	4	2842	Wed, 29 November 2017 11:06 By: wtolentino
trigger impacting performance 11g32 linux(RHEL) By: dba4oracle on Tue, 28 November 2017	14	3997	Wed, 29 November 2017 06:05 By: dba4oracle
Packages By: rkapex on Sat, 25 November 2017	6	3499	Mon, 27 November 2017 08:04 By: Bill B
How to Avoid ORA-01438: value larger than specified precision allowed for this column Oracle11g By: ssyr on Fri, 24 November 2017	23	16948	Mon, 27 November 2017 06:01 By: ssyr
Procedure By: rkapex on Sat, 25 November 2017	3	2863	Mon, 27 November 2017 03:25 By: cookiemonster
Using views to summarise payment info Oracle SQL 12 By: Rugad on Sun, 26 November 2017	1	2303	Sun, 26 November 2017 16:44 By: BlackSwan
help convert mac address string to hex oracle 12c By: laredoeneko on Sun, 26 November 2017	7	3067	Sun, 26 November 2017 14:16 By: EdStevens
Array ORA-06533: Subscript beyond count 11.0.2.10 By: OraFerro on Wed, 22 November 2017	8	14762	Sat, 25 November 2017 23:01 By: OraFerro
Oracle Sub-query and AND clause behaviour 11g By: LKT on Sun, 19 November 2017	3	2689	Fri, 24 November 2017 09:11 By: Bill B
Unable to grant Admin privileges on SQL Developer 12c Oracle SQL Developer 12c By: Dave0001 on Fri, 24 November 2017	6	3102	Fri, 24 November 2017 02:20 By: Littlefoot
Drop Function gives error oracle 12c Windows 2012 By: muthukrish104 on Fri, 17 November 2017	6	3835	Wed, 22 November 2017 07:05 By: BlackSwan
how can get Three consecutive days By: hassan08 on Fri, 17 November 2017	5	3393	Mon, 20 November 2017 05:21 By: Solomon Yakobson
grouping in matrix 12c By: m.abdulhaq on Sun, 19 November 2017	3	2541	Mon, 20 November 2017 05:02 By: Solomon Yakobson
Query Analysis Oracle 12c By: srinivas.k2005 on Mon, 20 November 2017	7	3074	Mon, 20 November 2017 04:53 By: srinivas.k2005
Passing warning collection from PL/SQL 11.0.2.10 By: OraFerro on Sun, 19 November 2017	2	2619	Sun, 19 November 2017 22:27 By: OraFerro
ora 01882 Sql Developer, 1.5.1.54.40, Windows Server 2003 By: getritesh on Tue, 25 May 2010	24	12806	Sun, 19 November 2017 14:23 By: ashisheck
REST API with DDOS protection ORACLE 12c By: mmation on Fri, 17 November 2017	2	2656	Sat, 18 November 2017 09:47 By: mmation
REGEXP_SUBSTR ORACLE,12C,UNIX By: pstanand on Fri, 17 November 2017	4	2592	Fri, 17 November 2017 10:21 By: pstanand
PL/SQL: SQL Statement Ignored ORACLE XE sql developer version 17.3.0.271 By: malflowers on Thu, 16 November 2017	9	14994	Fri, 17 November 2017 05:35 By: malflowers
oracle external table issue oracle 11g By: POGAKU_SANTHOSH on Sun, 12 November 2017	6	2966	Sun, 12 November 2017 11:51 By: POGAKU_SANTHOSH
update query 11.2.0.4 By: grpatwari on Wed, 08 November 2017	9	43757	Fri, 10 November 2017 01:43 By: Michel Cadot
MATERIALIZED VIEW TNS for 64-bit Windows: Version 11.2.0.1.0 - Production By: shawaj on Wed, 08 November 2017	7	32016	Thu, 09 November 2017 07:10 By: EdStevens
query datewise howmany records oracle 12c By: mvrkr44 on Thu, 09 November 2017	4	12379	Thu, 09 November 2017 04:14 By: mvrkr44
Re: PL/SQL:How to use VARRAY in the USING clause of EXECUTE IMMEDIATE? split from http://www.orafaq.com/forum/t/161791/ By: moracles on Tue, 11 July 2017	10	31155	Thu, 09 November 2017 04:00 By: moracles
Order of Trigger Types 11g Release 11.2.0.3.0 By: whdyck on Mon, 06 November 2017	4	25854	Tue, 07 November 2017 08:18 By: Bill B
how can get five days By: hassan08 on Fri, 03 November 2017	11	214329	Mon, 06 November 2017 02:02 By: quirks
Prevent deletion 12c By: m.abdulhaq on Fri, 03 November 2017	8	4482	Sat, 04 November 2017 10:39 By: m.abdulhaq
ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION Oracle8i Enterprise Edition Release 8.1.7.0.0 /windows7 By: shawaj on Fri, 03 November 2017	3	6195	Sat, 04 November 2017 03:40 By: Littlefoot
TABLE PARTITIONING Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 By: shawaj on Thu, 02 November 2017	3	63833	Fri, 03 November 2017 07:55 By: shawaj
ORA-06502: PL/SQL: numeric or value error. Oracle 4.0 By: WhoAmI on Wed, 01 November 2017	9	178270	Fri, 03 November 2017 07:35 By: BlackSwan
Modify procedure calculation for readability Oracle 11.2.0.4 By: veepee on Sun, 29 October 2017	17	441206	Thu, 02 November 2017 16:44 By: veepee
to_char date conversion not working oracle 11 for Windows 10 By: gunderj on Wed, 01 November 2017	8	269648	Thu, 02 November 2017 04:15 By: cookiemonster
NO_CPU_COSTING hint Oracle 12c By: srinivas.k2005 on Mon, 30 October 2017	3	116482	Tue, 31 October 2017 03:09 By: John Watson
Multiple Rows to a Single Row oracle 10g By: bond007 on Mon, 16 October 2017	20	72374	Sat, 28 October 2017 19:19 By: Barbara Boehmer
Error 500--Internal Server Error while running oracle Reports to print the pdf in 11g R2[11.1.2.2.0] Linux,11gR2 11.1.2.2.0 oracle forms and reports, oracle 11g database By: Beginner_ora on Wed, 25 October 2017	1	2612	Wed, 25 October 2017 07:14 By: John Watson
SQL help on hierarchy data Oracle 10g and DB2 By: srinivas.k2005 on Sun, 22 October 2017	3	39587	Tue, 24 October 2017 11:57 By: srinivas.k2005
Using Oracle Parallel hint By: martjosh on Tue, 17 October 2017	9	67720	Tue, 24 October 2017 08:07 By: BlackSwan
Changing the date format on a specific field By: amandasmile on Wed, 18 October 2017	10	42711	Mon, 23 October 2017 07:41 By: Bill B