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
how to search for two characters in any sequence, with or without alphanumeric characters in between Oracle 11g, 12c By: namitanamburi on Tue, 29 November 2016	13	3003	Tue, 29 November 2016 15:36 By: Bill B
Star printing in PL/SQL Program Problem 11g By: ashishpatel1992 on Sat, 16 March 2013	13	14139	Tue, 29 November 2016 14:06 By: Michel Cadot
How to pass date parameters in dynamic sql? PL sql By: nukala on Mon, 28 November 2016	8	11629	Tue, 29 November 2016 07:38 By: EdStevens
Function returns Record - How to select By: vactirio on Fri, 25 November 2016	8	3088	Sat, 26 November 2016 06:44 By: vactirio
How to generate a insert script as it is what ever we running the insert script? insert into dept(deptno,dname,loc) values (70,'PERSONNEL','DALLAS') By: narendraenamala on Thu, 24 November 2016	9	4130	Sat, 26 November 2016 04:40 By: Michel Cadot
using rownum oracle 10 g By: akash123 on Fri, 25 November 2016	14	4321	Fri, 25 November 2016 07:06 By: Bill B
Trigger to prevent update/delete/insert operation By: ram_new_to_oracle on Thu, 24 November 2016	4	2595	Fri, 25 November 2016 03:18 By: cookiemonster
Trigger to prevent delete according to select 11.0.2.10 By: OraFerro on Tue, 22 November 2016	9	4911	Thu, 24 November 2016 08:16 By: ALEXWE
Please provide best approach to design ETL in Oracle. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Thu, 24 November 2016	4	1628	Thu, 24 November 2016 07:20 By: John Watson
SQL Query Update 11g By: glmjoy on Thu, 24 November 2016	4	1786	Thu, 24 November 2016 06:11 By: msol25
complex query oracle By: bikashp on Wed, 23 November 2016	1	1647	Wed, 23 November 2016 06:35 By: Michel Cadot
electronic data sharding By: sudeepto chattaraj on Fri, 18 November 2016	14	4415	Tue, 22 November 2016 07:26 By: EdStevens
Update Table Based On Another Table oracle 11g, windows server By: morissa on Fri, 18 November 2016	14	10122	Tue, 22 November 2016 03:38 By: cookiemonster
Show all months between 2 months in a group by query Oracle 11g By: avni on Mon, 21 November 2016	1	2196	Mon, 21 November 2016 03:09 By: Michel Cadot
Rows not populating Oracle DB 12c By: krishna.orcl97 on Fri, 18 November 2016	9	2339	Fri, 18 November 2016 14:18 By: BlackSwan
Oracle 11g Ntile function on top of Dense_rank By: raj85844 on Wed, 16 November 2016	1	1981	Wed, 16 November 2016 23:36 By: raj85844
how to close open cursor when exception oracle 11 By: yk107 on Tue, 15 November 2016	11	5165	Wed, 16 November 2016 12:57 By: yk107
Calling procedure from trigger Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit Windows 7 By: SW26477 on Wed, 16 November 2016	2	1703	Wed, 16 November 2016 10:32 By: Michel Cadot
merge statement problem 10g By: emadnabil on Sun, 13 November 2016	15	5489	Mon, 14 November 2016 07:56 By: emadnabil
Filling a table of object in function loop 11.0.2.10 By: OraFerro on Sun, 13 November 2016	7	3145	Mon, 14 November 2016 06:31 By: Michel Cadot
Need to match combination string at database Oracle 11g, AIX server By: Shan.kumar on Thu, 10 November 2016	12	14159	Mon, 14 November 2016 00:21 By: Shan.kumar
PL/SQL Email Oracle 11gr2 By: VariableReset on Sat, 12 November 2016	3	2221	Sat, 12 November 2016 06:48 By: VariableReset
SQL Query Request oracle 11g By: raj85844 on Wed, 09 November 2016	14	5284	Fri, 11 November 2016 10:19 By: Michel Cadot
spool sql data in excel multi sheets By: Preeti123456 on Thu, 10 November 2016	3	2099	Fri, 11 November 2016 04:17 By: pablolee
How to log what parameter the API is passing to query oracle 11g By: magnify on Wed, 09 November 2016	3	1649	Wed, 09 November 2016 12:22 By: BlackSwan
Search data between months Oracle 11g By: Xandot on Wed, 09 November 2016	2	1719	Wed, 09 November 2016 05:07 By: Xandot
Getting months in the current Fiscal Year in Oracle Oracle Database 11g Enterprise Edition By: megha2525 on Fri, 04 November 2016	5	2440	Wed, 09 November 2016 03:01 By: Flyby
Query help Oracle By: julien1630 on Tue, 08 November 2016	14	13685	Tue, 08 November 2016 10:36 By: Solomon Yakobson
external table with single column oracle 11g By: guddu_12 on Mon, 07 November 2016	23	7623	Tue, 08 November 2016 07:06 By: EdStevens
Procedure execution issue and trace 11g r2, linux By: qazims92 on Mon, 07 November 2016	7	2505	Tue, 08 November 2016 03:56 By: cookiemonster
conversion to 16bit decimal oracle 11gr2 By: guddu_12 on Fri, 28 October 2016	16	6105	Mon, 07 November 2016 10:09 By: guddu_12
Conditional based default value Oracle 11 By: saipradyumn on Mon, 07 November 2016	5	2678	Mon, 07 November 2016 08:05 By: saipradyumn
package modified details oracle 12c, unix By: pstanand on Sun, 06 November 2016	6	2046	Sun, 06 November 2016 02:27 By: Michel Cadot
query needed without using only where clause 10g By: god_bunu on Fri, 04 November 2016	3	1708	Sat, 05 November 2016 02:00 By: Michel Cadot
Selecting the columns Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production By: saipradyumn on Tue, 06 September 2016	32	10687	Fri, 04 November 2016 11:24 By: Solomon Yakobson
summation of multiple values for a particular at specific period oracle 10.g By: eogyamfi on Thu, 03 November 2016	10	3357	Fri, 04 November 2016 11:04 By: Michel Cadot
Query Help Oracle 11g By: SADASIVAM on Sat, 15 October 2016	14	5317	Fri, 04 November 2016 04:03 By: SADASIVAM
How to format JSON column RDBMS 12C By: samiraly on Mon, 31 October 2016	5	3215	Thu, 03 November 2016 09:04 By: samiraly
Column dropped 11 g By: saipradyumn on Mon, 24 October 2016	3	2103	Wed, 02 November 2016 14:59 By: Bill B
Default Character type of the column Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Sat, 01 October 2016	6	3601	Wed, 02 November 2016 06:08 By: Solomon Yakobson