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
Finding exact row in case of matching Oracle 10g By: maanosajnabi on Mon, 15 January 2018	6	1753	Mon, 19 February 2018 06:22 By: quirks
Oracle PLSQL validate a row and insert each cell value of row as a new row with validation results i oracle By: hareesh996 on Sat, 17 February 2018	10	1631	Mon, 19 February 2018 05:24 By: quirks
Need help with insert in Oracle Oracle SQL Developer By: victor_pulga on Sat, 17 February 2018	11	1780	Mon, 19 February 2018 04:12 By: quirks
BULK COLLECT ISSUE Oracle 12C, Unix By: bahubcd on Wed, 14 February 2018	4	1028	Thu, 15 February 2018 00:09 By: Michel Cadot
How to get the functions name used by a column in the whole database oracle 11g By: POGAKU_SANTHOSH on Thu, 01 February 2018	38	3414	Wed, 14 February 2018 10:14 By: Michel Cadot
schedule job for multi threading oracle 10g By: simplesanju on Sat, 10 February 2018	3	1217	Mon, 12 February 2018 00:32 By: simplesanju
difference between date By: hassan08 on Mon, 05 February 2018	5	1232	Tue, 06 February 2018 03:45 By: John Watson
recursive query 12c By: m.abdulhaq on Sat, 03 February 2018	11	1738	Sat, 03 February 2018 12:55 By: BlackSwan
dba_dependencies_columns 12.2.0.1.0 By: Bill B on Thu, 01 February 2018	5	1212	Fri, 02 February 2018 07:48 By: Bill B
Websocket connection through Oracle PL SQL Oracle 12c By: santoshvgotur@gmail.com on Thu, 01 February 2018	3	1276	Fri, 02 February 2018 06:54 By: EdStevens
need two token matching query oracle 11.2.0.4 By: mvrkr44 on Thu, 07 December 2017	38	7307	Wed, 31 January 2018 18:50 By: Barbara Boehmer
Is there a way to do a rollup on only one dimension 11.2.0.4, Windows 2012 R2 By: juniordbanewbie on Thu, 23 November 2017	3	1716	Thu, 25 January 2018 18:10 By: juniordbanewbie
load script for loading data from oracle table to excel By: sshree12 on Wed, 24 January 2018	3	1217	Thu, 25 January 2018 11:50 By: Bill B
Alternate to DECODE function to be used in elsif statment in PLSQL procedure By: oracbeg on Thu, 25 January 2018	2	1005	Thu, 25 January 2018 08:17 By: Michel Cadot
how can don't use column in group by By: hassan08 on Tue, 23 January 2018	7	2613	Thu, 25 January 2018 04:14 By: cookiemonster
Special grouping with SQL Oracle 12C R2 By: OlafCologne on Sat, 20 January 2018	5	1539	Sat, 20 January 2018 09:25 By: Littlefoot
Material view auto refresh DBMS_SCHEDULER oracle 11g By: POGAKU_SANTHOSH on Thu, 18 January 2018	2	1287	Thu, 18 January 2018 04:42 By: POGAKU_SANTHOSH
How to replace with null for non alphanumeric characters in Varchar2 field. Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: msol25 on Tue, 09 January 2018	6	1545	Tue, 16 January 2018 02:57 By: msol25
Problem with Data display Oracle11g By: ssyr on Fri, 12 January 2018	6	1917	Fri, 12 January 2018 08:14 By: joy_division
duplicate records with different date_from and date_to Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: naga.oracle on Wed, 10 January 2018	3	1527	Fri, 12 January 2018 02:57 By: quirks
malformed cursor oracle 12c By: desmond30 on Thu, 11 January 2018	8	1193	Thu, 11 January 2018 09:10 By: cookiemonster
PL/SQL procedure issue Windows By: nicolewells on Sun, 07 January 2018	12	2489	Thu, 11 January 2018 00:17 By: Littlefoot
Change the order of records in some variables By: habitusantos on Mon, 08 January 2018	6	1510	Tue, 09 January 2018 06:36 By: Littlefoot
Recording Update through trigger based on csv file upload By: oracbeg on Thu, 04 January 2018	3	1217	Sun, 07 January 2018 22:33 By: oracbeg
SQL query oracle xe 11g By: hudo on Fri, 05 January 2018	4	1373	Fri, 05 January 2018 10:54 By: Michel Cadot
printing first day of every month oracle 10g By: kumarravik on Mon, 01 January 2018	8	1725	Fri, 05 January 2018 07:16 By: Solomon Yakobson
Procedure with multiple search filter Oracle 10g By: Danny Freeman on Wed, 03 January 2018	6	1346	Thu, 04 January 2018 13:50 By: EdStevens
Why does Oracle rename the bind variable? Oracle 11.2.0.3 By: SmithXu on Sun, 31 December 2017	7	1850	Thu, 04 January 2018 05:56 By: _jum
Query contain MODEL cause "column not allowed here" in select statement By: vincenttic on Mon, 01 January 2018	4	1027	Tue, 02 January 2018 21:00 By: vincenttic
Function or filter in hierarchy query 12c By: m.abdulhaq on Tue, 26 December 2017	4	1472	Tue, 02 January 2018 02:09 By: quirks
dense_rank performance By: shahzad-ul-hasan on Sat, 30 December 2017	1	1265	Sat, 30 December 2017 08:07 By: BlackSwan
Cant use replication from SQL Server 2008 to Sybase? sql-server 2008 By: luveshan on Sat, 30 December 2017	1	1189	Sat, 30 December 2017 02:17 By: Littlefoot
regexp_substr 12c By: m.abdulhaq on Tue, 26 December 2017	6	1389	Fri, 29 December 2017 10:57 By: Littlefoot
mysql and oracle issue using dblink By: nicolewells on Fri, 29 December 2017	2	1083	Fri, 29 December 2017 07:54 By: EdStevens
last date of the year By: sshree12 on Wed, 27 December 2017	3	1120	Thu, 28 December 2017 07:40 By: joy_division
current date - preovious date calculations By: sshree12 on Tue, 26 December 2017	18	2620	Wed, 27 December 2017 21:59 By: Barbara Boehmer
over partition by By: sshree12 on Wed, 27 December 2017	14	1818	Wed, 27 December 2017 09:02 By: sshree12
Open cursor 11g32 linux(RHEL) By: dba4oracle on Wed, 27 December 2017	2	767	Wed, 27 December 2017 06:20 By: dba4oracle
Set timestamp with milliseconds to default to 0 milliseconds Oracle 11g By: pallaviprakash on Tue, 26 December 2017	2	792	Wed, 27 December 2017 00:44 By: Littlefoot
Create a combination DML Trigger Oracle 11gr2, multiple OS platform By: trantuananh24hg on Sun, 24 December 2017	5	1286	Tue, 26 December 2017 12:22 By: joy_division