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
checkbox charachter oracle 11gr2 By: guddu_12 on Thu, 28 February 2019	7	13017	Fri, 01 March 2019 09:06 By: BlackSwan
How to denormalize multiple records into 1 row- N/A By: newuser01 on Thu, 28 February 2019	1	4756	Thu, 28 February 2019 15:04 By: Michel Cadot
Huge XML data in BLOB columns Oracle 10g By: Danny Freeman on Tue, 26 February 2019	2	5957	Tue, 26 February 2019 13:44 By: Michel Cadot
INSERT and SELECT statements Windows By: philipsampson on Tue, 26 February 2019	1	5867	Tue, 26 February 2019 09:08 By: cookiemonster
Scenario Dates oracle 12 By: satishtab89 on Mon, 25 February 2019	13	9889	Tue, 26 February 2019 05:45 By: cookiemonster
Get Window User Name and MAC address after insert in RFQ table in oracle application Transaction (merged) 12.2.6 By: ashokb21 on Sun, 17 February 2019	19	16202	Fri, 22 February 2019 09:15 By: joy_division
Parallel DDL statements in a same table with different partitions Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Tue, 19 February 2019	11	10738	Fri, 22 February 2019 01:32 By: saipradyumn
difference amount between 2 dates By: suji6281 on Fri, 15 February 2019	21	10335	Thu, 21 February 2019 12:52 By: suji6281
How to Update the Col2 for below Table Structure By: sonudev on Thu, 21 February 2019	7	6819	Thu, 21 February 2019 06:41 By: EdStevens
Connect by clause taking lot of time Oracle 11g, Linux By: rajivn786 on Wed, 20 February 2019	8	6854	Wed, 20 February 2019 14:54 By: BlackSwan
Retrun a limit set of rows 9i or 11g By: torz on Sun, 17 February 2019	14	9516	Tue, 19 February 2019 15:53 By: Solomon Yakobson
Scrambling the data for dev environment after refresh to hide/mask the sensitive data oracle 11.2.0.4 By: vancouver_dba on Tue, 19 February 2019	1	4304	Tue, 19 February 2019 13:57 By: Michel Cadot
Using Window Function in a query Block - Count and Sum Database - 12c By: indianscout on Tue, 19 February 2019	2	4886	Tue, 19 February 2019 11:42 By: EdStevens
Executing dynamic sql using forall 12c By: gauravgautam135 on Mon, 18 February 2019	5	5474	Tue, 19 February 2019 03:23 By: John Watson
Displaying rows as columns and grouping data 11g By: vaibhav15211 on Mon, 18 February 2019	1	4530	Mon, 18 February 2019 02:31 By: Michel Cadot
XMLType Column Comparison in Select Query Oracle11g By: sotu100 on Thu, 14 February 2019	3	5470	Fri, 15 February 2019 01:06 By: Michel Cadot
Add new columns and update to 600MB table online mode with zero downtime Oracle 11gR2 By: srinivas.k2005 on Tue, 12 February 2019	5	6099	Thu, 14 February 2019 07:44 By: John Watson
select Statement with CASE and month count rdbms 12c By: evoradba on Tue, 12 February 2019	6	6772	Tue, 12 February 2019 17:32 By: BlackSwan
Difference between sum(decode) and count PL/SQL By: klaartje on Tue, 12 February 2019	4	7802	Tue, 12 February 2019 07:44 By: Bill B
How to collate rows PL/SQL By: klaartje on Tue, 12 February 2019	6	5840	Tue, 12 February 2019 07:19 By: Bill B
Tree View, Connect by Prior on 100m records Oracle 12c, RED HAT By: sureshonly@hotmail.com on Sun, 10 February 2019	7	7907	Mon, 11 February 2019 16:05 By: sureshonly@hotmail.com
Pull out string between two words in string column Oracle 11g By: spalato76 on Sat, 09 February 2019	3	6314	Sat, 09 February 2019 23:50 By: spalato76
Issue in dynamic sql. Oracle 18c By: rajeshsvnr on Wed, 06 February 2019	6	8030	Sat, 09 February 2019 06:37 By: Solomon Yakobson
Need help to Schedule Job to Purge dba_audit_trails along with fga_audit_trail Unix By: Akmmhto on Mon, 04 February 2019	2	5719	Tue, 05 February 2019 06:06 By: Akmmhto
Account number selection from 10 parallel session Oracle 11gR2 By: srinivas.k2005 on Fri, 01 February 2019	9	8442	Mon, 04 February 2019 10:16 By: srinivas.k2005
table export to excel 12c By: m.abdulhaq on Mon, 04 February 2019	7	6984	Mon, 04 February 2019 10:13 By: cookiemonster
Do I have to use ID as a PK? General By: CatB on Mon, 28 January 2019	17	11017	Wed, 30 January 2019 15:23 By: Bill B
MULTISET EXCEPT - COLLECTION 12C By: shawaj on Sat, 26 January 2019	13	10307	Wed, 30 January 2019 05:13 By: _jum
Identify data based on data in other tables By: rrcr on Sun, 27 January 2019	14	10067	Tue, 29 January 2019 07:56 By: BlackSwan
DataMapper - JSON -> XML - Add a colon in XML tag By: tutu10 on Mon, 28 January 2019	1	4665	Mon, 28 January 2019 03:27 By: _jum
RETURNING BULK COLLECT INTO COLLECTION 12C By: shawaj on Fri, 23 November 2018	9	10518	Sat, 26 January 2019 12:15 By: BlackSwan
SQL Query execute more records in WHERE CLAUSE Oracle Database 10g, Windows XP By: rehmankhan on Wed, 23 January 2019	3	5567	Thu, 24 January 2019 04:10 By: cookiemonster
changing telephone format 12c By: m.abdulhaq on Thu, 24 January 2019	4	5252	Thu, 24 January 2019 03:45 By: m.abdulhaq
How to simulate crash database? Oracle 12c Release 2 By: petar97 on Mon, 21 January 2019	8	9053	Mon, 21 January 2019 12:40 By: petar97
ORA-01843 on a simple query Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: Andrey_R on Thu, 17 January 2019	10	9316	Fri, 18 January 2019 10:22 By: Michel Cadot
Why Do You Need to File a DBA and the Simplest Way of Filing It. By: inshah2297@gmail.com on Wed, 16 January 2019	4	6326	Thu, 17 January 2019 00:34 By: Michel Cadot
DBMS_REDACT with MERGE Oracle 12.1 By: Michael.van.Uffelen on Mon, 14 January 2019	5	9524	Wed, 16 January 2019 09:00 By: Solomon Yakobson
Spreadsheet-like Totals and Subtotals 11.2 By: lott42_gmail on Fri, 11 January 2019	12	10320	Tue, 15 January 2019 18:29 By: Solomon Yakobson
Insert Statement taking more than 2 hrs for 4 million records Oracle 11gR2 By: srinivas.k2005 on Tue, 18 December 2018	21	11873	Mon, 14 January 2019 03:41 By: anil_mk
Determining a due date based on business hours Otracle 12.1 By: TerryM on Tue, 08 January 2019	8	11268	Fri, 11 January 2019 11:26 By: Michel Cadot