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
Administering queue Oracle 11.2.0.3, AIX By: arijit2004 on Fri, 30 March 2018	13	5906	Sat, 31 March 2018 04:53 By: arijit2004
getting error "table table1 is mutating, trigger/function may no" on executing trigger ORacle 11g By: gold14388 on Thu, 29 March 2018	8	6154	Fri, 30 March 2018 10:59 By: BlackSwan
identifier 'PACK_GEO.TRAN001' must be declared AIX, Oracle 11.2.0.3 By: arijit2004 on Fri, 30 March 2018	2	3593	Fri, 30 March 2018 06:29 By: arijit2004
How to get this table from that Database PL/SQL Developer, unknown, Win 10 By: Nanex on Thu, 29 March 2018	2	3929	Thu, 29 March 2018 08:30 By: joy_division
How to insert table alias in query Oracle 11g By: ssyr on Wed, 28 March 2018	2	3392	Thu, 29 March 2018 01:53 By: Michel Cadot
oracle Trigger for E-mail notifications !! oracle 11g By: shipon_97 on Sun, 25 March 2018	10	9186	Mon, 26 March 2018 23:57 By: shipon_97
How to log error using UTL_CALL_STACK Oracle 12c By: sss111ind on Wed, 07 March 2018	6	5214	Mon, 26 March 2018 07:16 By: Bill B
Merge 2 or more rows into 1 oracle 12c By: laredoeneko on Fri, 23 March 2018	7	5279	Sat, 24 March 2018 02:35 By: John Watson
Display Comma Separated Values 11g By: glmjoy on Wed, 21 March 2018	9	5559	Fri, 23 March 2018 11:34 By: glmjoy
Oracle 10 vs Oracle 12: order from SELECT statement Oracle12 By: basileus on Wed, 14 March 2018	15	8900	Fri, 23 March 2018 07:53 By: cookiemonster
Transaction 2 happen within 60 days of Transaction 1 Oracle Database 12c Enterprise Edition 12.1.0.2.0 By: Saz on Tue, 20 March 2018	13	9409	Wed, 21 March 2018 11:56 By: Saz
Comma Seprate 11g By: glmjoy on Mon, 19 March 2018	4	4391	Tue, 20 March 2018 18:19 By: glmjoy
return records based on records By: mist598 on Mon, 19 March 2018	5	4573	Tue, 20 March 2018 14:20 By: Barbara Boehmer
Arranging row data in column Oracel 10G, Windows 10 By: anil029 on Tue, 20 March 2018	1	3389	Tue, 20 March 2018 07:44 By: BlackSwan
How To Count Total number of rows deleted by DELETE and reset counter after some condition Oracle11g By: ssyr on Thu, 15 March 2018	9	6086	Thu, 15 March 2018 06:13 By: ssyr
Help on running difference sql query (2 merged by CM) oracle 11g By: bharathi89 on Wed, 14 March 2018	6	4075	Wed, 14 March 2018 21:21 By: bharathi89
How Can I Execute Table Name in Order without using ORDER BY Clayuse Oracle11g By: ssyr on Tue, 13 March 2018	6	4097	Wed, 14 March 2018 05:37 By: msol25
Help required for taking distinct count without using DISTINCT keyword By: ramya29p on Mon, 12 March 2018	7	4695	Tue, 13 March 2018 13:11 By: EdStevens
Import data from excel to oracle Db By: malu on Mon, 12 March 2018	3	6013	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	4441	Tue, 13 March 2018 09:16 By: msol25
DBMS_CRYPTO package By: adovgan on Tue, 13 March 2018	2	3783	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	3227	Mon, 12 March 2018 08:04 By: John Watson
Get Current & Previous Quarter Data from table By: ramya29p on Fri, 09 March 2018	5	4113	Fri, 09 March 2018 05:03 By: flyboy
Oracle Partitioned Table get values 11G By: elixir86 on Tue, 06 March 2018	1	3318	Tue, 06 March 2018 13:12 By: BlackSwan
help with error executing a view oracle 12c By: laredoeneko on Sat, 03 March 2018	14	7999	Sun, 04 March 2018 11:36 By: Michel Cadot
comma separated string to column dynamically By: ramya29p on Tue, 27 February 2018	10	7327	Wed, 28 February 2018 07:35 By: Bill B
Compare row & column data 11G By: bond_8801 on Tue, 27 February 2018	8	5410	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	3398	Tue, 27 February 2018 10:52 By: rajivn786
Table Archive and Purge 11.2 By: gopikrish_6 on Sun, 25 February 2018	6	4970	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	10267	Mon, 26 February 2018 15:23 By: Bill B
string format By: suji6281 on Mon, 26 February 2018	3	3162	Mon, 26 February 2018 10:08 By: Bill B
Interval Clause in Date Oracle11g By: ssyr on Mon, 26 February 2018	2	3523	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	3057	Mon, 26 February 2018 03:30 By: saipradyumn
Query help 12.2 By: kapilavastu on Thu, 22 February 2018	15	9283	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	4917	Wed, 21 February 2018 12:46 By: bobghw
SQL Query Oracle 12 c By: Deep_80 on Mon, 19 February 2018	20	9019	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	7759	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	7169	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	5311	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	5855	Mon, 19 February 2018 05:24 By: quirks