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
Oracle Special character while dbms_output 11g By: harshadsp on Thu, 09 June 2016	16	12982	Fri, 10 June 2016 03:29 By: harshadsp
Rebuild table contain partition Oracle database 10g By: dophuong_cs on Wed, 08 June 2016	3	3377	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	8400	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	5866	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	3802	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	3943	Tue, 07 June 2016 11:46 By: adfnewbie
Number to words pl sql By: raghuramgupta on Tue, 07 June 2016	5	4172	Tue, 07 June 2016 11:35 By: Bill B
union all and sql*plus By: Eugene on Thu, 26 December 2002	8	34893	Tue, 07 June 2016 06:38 By: EdStevens
Convert Rows to Columns Oracle 11g By: arifs3738 on Sun, 05 June 2016	9	21329	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	3512	Sat, 04 June 2016 23:35 By: bdtran
Pattern recognition problem 12.1.0.2 By: bdtran on Thu, 26 May 2016	11	5554	Sat, 04 June 2016 13:10 By: bdtran
Transpose rows to columns without aggregation By: dancko on Sat, 04 June 2016	9	4623	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	7305	Fri, 03 June 2016 22:08 By: nath123
Issue with UTL_FILE.INVALID_OPERATION 11g By: namitanamburi on Wed, 01 June 2016	7	4088	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	8125	Fri, 03 June 2016 15:13 By: Michel Cadot
transpose and insert the data oracle 11g By: tolupuluri on Fri, 27 May 2016	19	6713	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	3600	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	5676	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	2555	Thu, 02 June 2016 07:43 By: Bill B
package error By: narang_me12 on Wed, 01 June 2016	7	4124	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	20831	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	12896	Tue, 31 May 2016 22:14 By: pstanand
Filler / Bound Filler in External tables oracle 11g By: ORAGENASHOK on Tue, 31 May 2016	2	2836	Tue, 31 May 2016 08:28 By: Bill B
Loops oracle 11g By: Satheesh.A on Tue, 31 May 2016	7	3262	Tue, 31 May 2016 04:03 By: Satheesh.A
DDL commands oracle 11g By: Satheesh.A on Tue, 31 May 2016	2	2292	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	6443	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	4206	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	6254	Sat, 28 May 2016 06:37 By: Solomon Yakobson
Indexes oracle 11g By: Satheesh.A on Fri, 27 May 2016	2	2065	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	2804	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	4769	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	2557	Thu, 26 May 2016 00:08 By: Michel Cadot
function is not giving correct output By: AmarendraSahoo2016 on Tue, 24 May 2016	4	2704	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	3429	Tue, 24 May 2016 21:35 By: arifs3738
Problem while inserting data in unix env By: amit.sonar on Mon, 23 May 2016	34	9870	Tue, 24 May 2016 09:33 By: Michel Cadot
first tuesday of every month ? sql developer By: nath123 on Fri, 20 May 2016	5	6022	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	4881	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	4638	Mon, 23 May 2016 07:56 By: BlackSwan
IN (or) Equality Operator SQL By: kirankumarmutte on Fri, 20 May 2016	9	5351	Fri, 20 May 2016 16:16 By: John Watson
Display the columns of a table into rows delimited by comma 11.2.0.4 By: grpatwari on Wed, 18 May 2016	19	7207	Fri, 20 May 2016 09:54 By: Michel Cadot