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
how to extract data from oracle table having space in column name using vba code? By: oracbeg on Tue, 05 September 2017	4	69333	Tue, 05 September 2017 09:01 By: Bill B
PLSQL Procedure to Grant Privs on Schema Objects Oracle Database 12.1.0.2 on Linux 6.9 By: Lucky A on Fri, 01 September 2017	7	76570	Tue, 05 September 2017 04:12 By: cookiemonster
Select u'' from dual; What does u mean? in this sql. Oracle 11G, 2.0.1 By: chrisindya on Fri, 01 September 2017	2	26111	Tue, 05 September 2017 04:11 By: chrisindya
the records with common cust_id should not be shown. By: adil shakeel on Mon, 28 August 2017	12	24604	Mon, 04 September 2017 02:26 By: quirks
SQL Query Oracle 11g By: sql_123 on Thu, 24 August 2017	5	27576	Mon, 04 September 2017 02:00 By: quirks
mysql statement to PL/SQL By: winfire on Fri, 01 September 2017	6	13764	Mon, 04 September 2017 01:37 By: quirks
Bulk Inserts with CLOB column Slower in Oracle 12c than Oracle 11g Oracle 12.1. By: rkrishna on Sun, 27 August 2017	10	23218	Sun, 03 September 2017 06:38 By: John Watson
Unexpected weird result A+A' != U 10.2.0.1.0 By: bluetooth420 on Wed, 30 August 2017	7	77608	Fri, 01 September 2017 02:24 By: Roachcoach
How to show multiple data in single row Oracle11g By: ssyr on Tue, 29 August 2017	4	22092	Fri, 01 September 2017 01:44 By: ssyr
Need help on query Oracle11g By: ssyr on Thu, 31 August 2017	1	15479	Thu, 31 August 2017 05:36 By: John Watson
Conversion into Clob from Varchar2 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Mon, 28 August 2017	4	11108	Wed, 30 August 2017 03:12 By: saipradyumn
REGEXP_INSTR Oracle 12c,NT By: pstanand on Wed, 23 August 2017	8	16733	Wed, 30 August 2017 02:37 By: pstanand
Question about printing the result of a recursive subquery factoring with line indents By: dariyoosh on Tue, 29 August 2017	1	3430	Tue, 29 August 2017 17:30 By: dariyoosh
Invalid Datatype error for record type Oracle 11g By: Rotan on Tue, 29 August 2017	3	11039	Tue, 29 August 2017 14:50 By: Solomon Yakobson
Visualize Processes Vertical Oracle 12 By: quirks on Mon, 21 August 2017	10	17760	Tue, 29 August 2017 06:19 By: quirks
Oracle lookup function in loop returns rowtype how to get fields from rowtype Oracle 12g By: jokrasa on Fri, 25 August 2017	3	25466	Tue, 29 August 2017 03:38 By: cookiemonster
Error Linking to C DLL from PL/SQL Local Oracle 12c - Windows 10 By: jhgerold on Mon, 28 August 2017	8	16662	Mon, 28 August 2017 15:53 By: jhgerold
Cursor within a cursor Oracle Database 11g Enterprise Edition Release By: megha2525 on Mon, 28 August 2017	1	9306	Mon, 28 August 2017 13:30 By: Littlefoot
Help with PL SQL query - Analytical Function or group by 12c By: namitanamburi on Tue, 15 August 2017	5	4103	Sat, 26 August 2017 07:47 By: Flyby
Wanted to delete duplicate records Oracle 11 g By: samiran_cts on Tue, 22 August 2017	8	21452	Thu, 24 August 2017 10:07 By: samiran_cts
Applying function on column having multiple datatypes By: oracbeg on Tue, 22 August 2017	6	4767	Tue, 22 August 2017 07:51 By: joy_division
Using Trigger in Oracle DB to update a table in SQL Server DB Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: queeny on Tue, 22 August 2017	5	8377	Tue, 22 August 2017 07:43 By: Michel Cadot
File compressing is not happening Oracle 11g , 11.2.0.3.0 By: mm_kanish05 on Tue, 22 August 2017	2	2936	Tue, 22 August 2017 03:43 By: cookiemonster
Max function PL SQL By: OldDog on Sun, 20 August 2017	9	4819	Tue, 22 August 2017 02:51 By: quirks
Join and group by on multiple tables Oracle 11g By: kishor9329 on Mon, 21 August 2017	2	11690	Mon, 21 August 2017 08:10 By: Bill B
Solution for ora-00020 maximum number of processes oracle database 8i By: amjad_alahdal on Thu, 20 July 2017	17	43310	Sun, 20 August 2017 02:23 By: amjad_alahdal
function 12c By: arifmd1705 on Fri, 18 August 2017	3	3228	Fri, 18 August 2017 14:23 By: arifmd1705
Should I Clean Up My Collections? 11g By: whdyck on Thu, 17 August 2017	8	219509	Fri, 18 August 2017 09:37 By: whdyck
Triggers on editioning views inheriting trigger events from NEWER editions Oracle Database - Enterprise Edition Product Version 12.1.0.2 Linux x86-64 OS Version Red Hat Enterprise 6 By: fixxxer on Wed, 16 August 2017	7	4520	Fri, 18 August 2017 05:36 By: Michel Cadot
Setting Edition // Remote Database Oracle 11.2.0.4 By: suddhasatwa_oracle on Mon, 07 August 2017	13	6693	Fri, 18 August 2017 02:26 By: Michel Cadot
Need to get the comma separated value By: rajeshsvnr on Mon, 14 August 2017	4	5198	Thu, 17 August 2017 12:05 By: rajeshsvnr
Determine filePath/Name from UTL_FILE.FILE_TYPE? Oracle 11g By: bkuhn on Wed, 16 August 2017	4	7290	Thu, 17 August 2017 09:20 By: bkuhn
qualification_ind value meaning (2 threads merged by bb, including one hijacked from unrelated thread http://www.orafaq.com/forum/stt/76498/) By: mlashin on Tue, 08 August 2017	6	4520	Wed, 16 August 2017 20:47 By: Barbara Boehmer
MISSING DATE oracle 11g , database 11g, windows 7 By: hisham99 on Tue, 15 August 2017	6	3318	Tue, 15 August 2017 07:37 By: John Watson
member procedure execution oracle 11g By: ynkr999 on Tue, 25 July 2017	3	3471	Tue, 15 August 2017 00:16 By: Barbara Boehmer
Code Help: Inserting Records based on records in another table meeting certain parameters Oracle SQL Developer By: cem616 on Wed, 09 August 2017	6	3924	Mon, 14 August 2017 14:07 By: buggleboy007
Rectify the code By: salam_shah on Tue, 08 August 2017	9	5971	Mon, 14 August 2017 06:49 By: Bill B
extract portion of strings 12c By: m.abdulhaq on Sat, 05 August 2017	6	5597	Tue, 08 August 2017 23:09 By: m.abdulhaq
SQL QUERY oracle 11g 32-bit, windows7 By: shawaj on Fri, 04 August 2017	5	4320	Tue, 08 August 2017 21:28 By: shawaj
ORA-29279: SMTP permanent error: Unable to relay Oracle 10g By: sarfarazahmedv on Tue, 16 August 2011	12	74418	Fri, 04 August 2017 19:16 By: BlackSwan