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
Import data from excel to oracle Db By: malu on Mon, 12 March 2018	3	7218	Tue, 13 March 2018 13:06 By: EdStevens
select more rows and insert less oracle 11gr2 By: guddu_12 on Tue, 06 March 2018	6	5287	Tue, 13 March 2018 09:16 By: msol25
DBMS_CRYPTO package By: adovgan on Tue, 13 March 2018	2	4560	Tue, 13 March 2018 07:09 By: adovgan
steps to create dynamic join query in oracle sql By: asheolik on Mon, 12 March 2018	1	4034	Mon, 12 March 2018 08:04 By: John Watson
Get Current & Previous Quarter Data from table By: ramya29p on Fri, 09 March 2018	5	4952	Fri, 09 March 2018 05:03 By: flyboy
Oracle Partitioned Table get values 11G By: elixir86 on Tue, 06 March 2018	1	4123	Tue, 06 March 2018 13:12 By: BlackSwan
help with error executing a view oracle 12c By: laredoeneko on Sat, 03 March 2018	14	9252	Sun, 04 March 2018 11:36 By: Michel Cadot
comma separated string to column dynamically By: ramya29p on Tue, 27 February 2018	10	8475	Wed, 28 February 2018 07:35 By: Bill B
Compare row & column data 11G By: bond_8801 on Tue, 27 February 2018	8	6466	Tue, 27 February 2018 17:33 By: BlackSwan
Count occurrences of String in field Oracle 11g, Win 10 By: rajivn786 on Mon, 26 February 2018	2	4464	Tue, 27 February 2018 10:52 By: rajivn786
Table Archive and Purge 11.2 By: gopikrish_6 on Sun, 25 February 2018	6	5962	Mon, 26 February 2018 15:30 By: Bill B
Commit after deletion of every 5000 rows Oracle11g By: ssyr on Mon, 08 January 2018	17	12579	Mon, 26 February 2018 15:23 By: Bill B
string format By: suji6281 on Mon, 26 February 2018	3	4029	Mon, 26 February 2018 10:08 By: Bill B
Interval Clause in Date Oracle11g By: ssyr on Mon, 26 February 2018	2	4370	Mon, 26 February 2018 04:10 By: cookiemonster
Character set Conversion Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Mon, 26 February 2018	2	3991	Mon, 26 February 2018 03:30 By: saipradyumn
Query help 12.2 By: kapilavastu on Thu, 22 February 2018	15	10528	Fri, 23 February 2018 11:51 By: Littlefoot
User variable to decide which in statement to use in query By: bobghw on Tue, 13 February 2018	5	5898	Wed, 21 February 2018 12:46 By: bobghw
SQL Query Oracle 12 c By: Deep_80 on Mon, 19 February 2018	20	10740	Wed, 21 February 2018 07:48 By: joy_division
Grouping of records in a table with a group id 11G, Unix By: bahubcd on Sat, 03 February 2018	11	8831	Wed, 21 February 2018 06:51 By: Bill B
NVL Vs OR condition PL/SQL Release 11.2.0.4.0 - Production By: saipradyumn on Thu, 15 February 2018	9	8516	Mon, 19 February 2018 07:00 By: cookiemonster
Finding exact row in case of matching Oracle 10g By: maanosajnabi on Mon, 15 January 2018	6	6121	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	7112	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	8252	Mon, 19 February 2018 04:12 By: quirks
BULK COLLECT ISSUE Oracle 12C, Unix By: bahubcd on Wed, 14 February 2018	4	7443	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	13757	Wed, 14 February 2018 10:14 By: Michel Cadot
schedule job for multi threading oracle 10g By: simplesanju on Sat, 10 February 2018	3	4540	Mon, 12 February 2018 00:32 By: simplesanju
difference between date By: hassan08 on Mon, 05 February 2018	5	4989	Tue, 06 February 2018 03:45 By: John Watson
recursive query 12c By: m.abdulhaq on Sat, 03 February 2018	11	7116	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	5896	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	8135	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	20656	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	5726	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	4843	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	4378	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	7701	Thu, 25 January 2018 04:14 By: cookiemonster
Special grouping with SQL Oracle 12C R2 By: OlafCologne on Sat, 20 January 2018	5	5809	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	8096	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	5707	Tue, 16 January 2018 02:57 By: msol25
Problem with Data display Oracle11g By: ssyr on Fri, 12 January 2018	6	6108	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	4844	Fri, 12 January 2018 02:57 By: quirks