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
RAISE_APPLICATION_ERROR to display multiple line 11g By: harshadsp on Fri, 10 June 2016	1	239	Fri, 10 June 2016 08:35 By: Bill B
Oracle Special character while dbms_output 11g By: harshadsp on Thu, 09 June 2016	16	645	Fri, 10 June 2016 03:29 By: harshadsp
Rebuild table contain partition Oracle database 10g By: dophuong_cs on Wed, 08 June 2016	3	336	Thu, 09 June 2016 01:01 By: Michel Cadot
How To Update Encrypted Password for all user id's using Update Query Oracle 11 By: ramraju20000 on Tue, 07 June 2016	13	487	Wed, 08 June 2016 18:30 By: Solomon Yakobson
Read/write files from remote server using utl_file in oracle oracle 11g By: tolupuluri on Wed, 08 June 2016	3	315	Wed, 08 June 2016 09:52 By: tolupuluri
behaviour of to_timestamp and time zones Win10, Oracle 12c By: GusGF on Mon, 06 June 2016	5	403	Wed, 08 June 2016 04:47 By: GusGF
Collections in plsql - syntax Oracle 11.2.0.4.0 By: adfnewbie on Mon, 06 June 2016	5	366	Tue, 07 June 2016 11:46 By: adfnewbie
Number to words pl sql By: raghuramgupta on Tue, 07 June 2016	5	277	Tue, 07 June 2016 11:35 By: Bill B
union all and sql*plus By: Eugene on Thu, 26 December 2002	8	9800	Tue, 07 June 2016 06:38 By: EdStevens
Convert Rows to Columns Oracle 11g By: arifs3738 on Sun, 05 June 2016	9	412	Mon, 06 June 2016 08:21 By: Michel Cadot
Adding Cells from two different tables 12.1.0.2 By: bdtran on Thu, 02 June 2016	5	428	Sat, 04 June 2016 23:35 By: bdtran
Pattern recognition problem 12.1.0.2 By: bdtran on Thu, 26 May 2016	11	522	Sat, 04 June 2016 13:10 By: bdtran
Transpose rows to columns without aggregation By: dancko on Sat, 04 June 2016	9	355	Sat, 04 June 2016 12:17 By: dancko
try to insert data in to table using procedure sql developer By: nath123 on Thu, 02 June 2016	13	533	Fri, 03 June 2016 22:08 By: nath123
Issue with UTL_FILE.INVALID_OPERATION 11g By: namitanamburi on Wed, 01 June 2016	7	369	Fri, 03 June 2016 18:58 By: namitanamburi
FIFO Algorithm to calculate Avg weighted value Oracle 10g By: anil029 on Thu, 02 June 2016	15	533	Fri, 03 June 2016 15:13 By: Michel Cadot
transpose and insert the data oracle 11g By: tolupuluri on Fri, 27 May 2016	19	619	Thu, 02 June 2016 15:56 By: tolupuluri
percentages of data population Oracle 11.2.0.3 By: pointers on Tue, 31 May 2016	10	377	Thu, 02 June 2016 14:32 By: Bill B
Data not inserted after MView creation Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 By: smvmohan on Mon, 30 May 2016	14	496	Thu, 02 June 2016 14:28 By: Bill B
encrypt and decrypt URL Oracle Database 11.2.0.3 By: metal_navin on Wed, 01 June 2016	1	279	Thu, 02 June 2016 07:43 By: Bill B
package error By: narang_me12 on Wed, 01 June 2016	7	390	Thu, 02 June 2016 07:38 By: Bill B
E-Mail sending issue from Oracle Database Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit By: Manoj.Gupta.91 on Fri, 12 December 2014	15	5203	Wed, 01 June 2016 02:54 By: Paul_A
Chinese Characters not display in table Oracle 12C UNIX By: pstanand on Tue, 31 May 2016	19	415	Tue, 31 May 2016 22:14 By: pstanand
Filler / Bound Filler in External tables oracle 11g By: ORAGENASHOK on Tue, 31 May 2016	2	257	Tue, 31 May 2016 08:28 By: Bill B
Loops oracle 11g By: Satheesh.A on Tue, 31 May 2016	7	325	Tue, 31 May 2016 04:03 By: Satheesh.A
DDL commands oracle 11g By: Satheesh.A on Tue, 31 May 2016	2	226	Tue, 31 May 2016 02:06 By: Michel Cadot
Reverse row to column and column to row Oracle 11 By: iliyan_84@abv.bg on Thu, 26 May 2016	14	560	Sat, 28 May 2016 14:08 By: Michel Cadot
Empolyees doesn't have any reportess oracle 11 g By: saipradyumn on Fri, 27 May 2016	9	476	Sat, 28 May 2016 08:53 By: Michel Cadot
Last Record oracle 11g, 11.2.0.4 , windows By: Satheesh.A on Fri, 27 May 2016	13	634	Sat, 28 May 2016 06:37 By: Solomon Yakobson
Indexes oracle 11g By: Satheesh.A on Fri, 27 May 2016	2	359	Fri, 27 May 2016 07:25 By: Satheesh.A
Dynamic SQL Select query (merged) PL/SQL By: richard_oak on Thu, 26 May 2016	5	310	Thu, 26 May 2016 12:19 By: BlackSwan
Different values of count(*) and num_rows of table 11g, 11.2.0.1, windows server 2008 By: ashishkumarmahanta80 on Thu, 26 May 2016	12	308	Thu, 26 May 2016 08:41 By: BlackSwan
join table for top 5 and bottom 5 sql developer By: nath123 on Wed, 25 May 2016	5	349	Thu, 26 May 2016 00:08 By: Michel Cadot
function is not giving correct output By: AmarendraSahoo2016 on Tue, 24 May 2016	4	298	Wed, 25 May 2016 02:54 By: Michel Cadot
Need to populate two more columns Oracle 11g By: arifs3738 on Tue, 24 May 2016	7	294	Tue, 24 May 2016 21:35 By: arifs3738
Problem while inserting data in unix env By: amit.sonar on Mon, 23 May 2016	34	726	Tue, 24 May 2016 09:33 By: Michel Cadot
first tuesday of every month ? sql developer By: nath123 on Fri, 20 May 2016	5	565	Tue, 24 May 2016 08:46 By: Bill B
Difference between Global Temporary Table and Collections in PLSQL By: msyogi on Mon, 23 May 2016	6	411	Tue, 24 May 2016 08:30 By: Bill B
Moving data older than 2 years in all fact tables to respective archive tables & purging data Oracle 11g , SQL Developer, Windows By: krisc2499 on Sat, 21 May 2016	10	620	Mon, 23 May 2016 07:56 By: BlackSwan
IN (or) Equality Operator SQL By: kirankumarmutte on Fri, 20 May 2016	9	1437	Fri, 20 May 2016 16:16 By: John Watson