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
How do I total each column of data with multiple queries? Oracle 12.1, Version 3.2.20.09 By: Dallas Graves on Mon, 06 March 2017	8	910	Thu, 09 March 2017 07:16 By: Bill B
which is best to locate row in oracle table By: asliyanage on Wed, 08 March 2017	15	1117	Thu, 09 March 2017 07:11 By: Bill B
Exchange Partition Oracle 11g By: saipradyumn on Wed, 08 March 2017	2	612	Wed, 08 March 2017 01:43 By: saipradyumn
Enable novalidate constraint Oracle 11g By: ORAGENASHOK on Mon, 06 March 2017	7	941	Tue, 07 March 2017 03:27 By: Roachcoach
How to split col into two columns according to data types By: ssyr on Mon, 06 March 2017	21	1311	Tue, 07 March 2017 03:02 By: cookiemonster
Date closest to event date By: ertweety on Mon, 06 March 2017	5	561	Mon, 06 March 2017 20:44 By: ertweety
Analytical query Oracle 11g By: srinivas.k2005 on Mon, 06 March 2017	3	536	Mon, 06 March 2017 09:46 By: cookiemonster
Delays between two dates excluding holidays/weekends Oracle 11.2.0.3 By: pointers on Thu, 02 March 2017	3	707	Mon, 06 March 2017 02:58 By: cookiemonster
why cbo select FULL TABLE SCAN By: meganmegan on Thu, 02 March 2017	14	1135	Sun, 05 March 2017 04:57 By: meganmegan
Bitmap index for nullable timestamp column ? Oracle 11gR2 / Linux By: kevinz on Mon, 27 February 2017	19	1517	Thu, 02 March 2017 20:08 By: Bill B
Convert select query to a cursor and that has to fetch first record Oracle 11g By: msyogi on Thu, 02 March 2017	3	517	Thu, 02 March 2017 14:21 By: Michel Cadot
Using debug in EBS r12 database with SQL Developer ORACLE EBS R12 By: annu-agi on Wed, 01 March 2017	4	877	Thu, 02 March 2017 09:53 By: Michel Cadot
{} in SQL Oracle 11g By: rahul1982 on Thu, 02 March 2017	5	647	Thu, 02 March 2017 08:13 By: cookiemonster
How to query and not include weekend or Bankholidays SQL By: timppap on Thu, 02 March 2017	2	545	Thu, 02 March 2017 02:17 By: Barbara Boehmer
Carriage return in column data for spool Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: abhi_orcl on Tue, 28 February 2017	12	1086	Wed, 01 March 2017 12:08 By: Michel Cadot
Today I came across different space issue in 12c DB (merged 2) PL/SQL Release 12.1.0.2.0 - Production By: saini006 on Wed, 01 March 2017	5	624	Wed, 01 March 2017 09:18 By: Flyby
Complex date differences - Bet you can't figure this one out. By: ertweety on Mon, 27 February 2017	11	968	Tue, 28 February 2017 09:27 By: Michel Cadot
online table structure changes without affecting the user 11g By: manikandan23 on Sat, 25 February 2017	22	1347	Tue, 28 February 2017 06:49 By: EdStevens
Execute Immediate with Dynamic From table Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Tue, 28 February 2017	2	574	Tue, 28 February 2017 01:51 By: saipradyumn
2 column values going inverse and how to display corresponding keys 11g By: manikandan23 on Sat, 25 February 2017	14	1317	Mon, 27 February 2017 16:13 By: Barbara Boehmer
Avoiding 2 Group By clauses By: manikandan23 on Mon, 27 February 2017	5	558	Mon, 27 February 2017 12:00 By: Michel Cadot
can we use column alias in having clause By: asliyanage on Sun, 26 February 2017	6	638	Mon, 27 February 2017 09:14 By: Bill B
Deletes with respect to table sizes 11g By: manikandan23 on Sat, 25 February 2017	6	648	Mon, 27 February 2017 09:11 By: Bill B
Return all rows if no matching condition found Oracle 12c By: pratik4891 on Sun, 26 February 2017	4	586	Mon, 27 February 2017 07:21 By: Michel Cadot
Why difference between count() and count() By: asliyanage on Sat, 25 February 2017	15	1569	Sun, 26 February 2017 01:40 By: Michel Cadot
How to find No of Entries per week For consecutive week By: gspandian on Thu, 23 February 2017	30	1388	Sat, 25 February 2017 05:59 By: Solomon Yakobson
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired 12c By: jaysorcale on Wed, 18 January 2017	14	8586	Sat, 25 February 2017 01:42 By: asliyanage
Declare a cursor from the return of a procedure? By: sdsmaster on Tue, 21 February 2017	8	880	Thu, 23 February 2017 15:07 By: Barbara Boehmer
Update based on grouping 11.0.2.10 By: OraFerro on Mon, 20 February 2017	26	1571	Wed, 22 February 2017 05:24 By: Michel Cadot
PLSQL - Update in Loop Oracle 11g By: wmpl on Mon, 20 February 2017	5	726	Tue, 21 February 2017 23:23 By: Barbara Boehmer
Flashback techniues By: Vijayarajan51 on Tue, 21 February 2017	2	598	Tue, 21 February 2017 10:26 By: Michel Cadot
Loading techniques By: Vijayarajan51 on Tue, 21 February 2017	3	499	Tue, 21 February 2017 10:10 By: Vijayarajan51
unique result Oracle 11g By: rahul1982 on Tue, 21 February 2017	2	490	Tue, 21 February 2017 03:39 By: rahul1982
Comma separate value with column value as column name 11.2.0.4 By: grpatwari on Sun, 19 February 2017	4	638	Mon, 20 February 2017 07:49 By: Michel Cadot
Synonym switching oracle 11g release 2 By: raj85844 on Thu, 16 February 2017	5	907	Thu, 16 February 2017 16:50 By: Caffeine+
cumulative sum & product oracle 11g release 2 By: varada on Wed, 15 February 2017	18	1187	Thu, 16 February 2017 10:02 By: varada
Create a Job to run Oracle Package stored procedure 11.0.2.10 By: OraFerro on Wed, 15 February 2017	4	758	Wed, 15 February 2017 23:05 By: OraFerro
Oracle BLOB DATA ORACLE,PLSQL By: bkumar on Wed, 15 February 2017	5	461	Wed, 15 February 2017 14:11 By: BlackSwan
Global Temporary table storage Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit By: abhi_orcl on Tue, 14 February 2017	9	723	Wed, 15 February 2017 10:36 By: abhi_orcl
Problem while using AUTHID CURRENT_USER By: amit.sonar on Fri, 10 February 2017	4	595	Wed, 15 February 2017 09:26 By: cookiemonster