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
Listing individual average price Oracle SQL By: misy on Thu, 09 June 2016	3	1917	Fri, 10 June 2016 12:00 By: misy
Query Date Ranges with select statement (merged 3) Oracle SQL By: basitfaazal on Tue, 07 June 2016	12	4239	Fri, 10 June 2016 08:36 By: Bill B
RAISE_APPLICATION_ERROR to display multiple line 11g By: harshadsp on Fri, 10 June 2016	1	1260	Fri, 10 June 2016 08:35 By: Bill B
Oracle Special character while dbms_output 11g By: harshadsp on Thu, 09 June 2016	16	9568	Fri, 10 June 2016 03:29 By: harshadsp
Rebuild table contain partition Oracle database 10g By: dophuong_cs on Wed, 08 June 2016	3	2351	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	6124	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	4612	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	2384	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	2582	Tue, 07 June 2016 11:46 By: adfnewbie
Number to words pl sql By: raghuramgupta on Tue, 07 June 2016	5	2732	Tue, 07 June 2016 11:35 By: Bill B
union all and sql*plus By: Eugene on Thu, 26 December 2002	8	30156	Tue, 07 June 2016 06:38 By: EdStevens
Convert Rows to Columns Oracle 11g By: arifs3738 on Sun, 05 June 2016	9	19662	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	2343	Sat, 04 June 2016 23:35 By: bdtran
Pattern recognition problem 12.1.0.2 By: bdtran on Thu, 26 May 2016	11	3661	Sat, 04 June 2016 13:10 By: bdtran
Transpose rows to columns without aggregation By: dancko on Sat, 04 June 2016	9	2930	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	4788	Fri, 03 June 2016 22:08 By: nath123
Issue with UTL_FILE.INVALID_OPERATION 11g By: namitanamburi on Wed, 01 June 2016	7	2384	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	5456	Fri, 03 June 2016 15:13 By: Michel Cadot
transpose and insert the data oracle 11g By: tolupuluri on Fri, 27 May 2016	19	3733	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	1938	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	3416	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	1682	Thu, 02 June 2016 07:43 By: Bill B
package error By: narang_me12 on Wed, 01 June 2016	7	2462	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	17437	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	8852	Tue, 31 May 2016 22:14 By: pstanand
Filler / Bound Filler in External tables oracle 11g By: ORAGENASHOK on Tue, 31 May 2016	2	1700	Tue, 31 May 2016 08:28 By: Bill B
Loops oracle 11g By: Satheesh.A on Tue, 31 May 2016	7	1814	Tue, 31 May 2016 04:03 By: Satheesh.A
DDL commands oracle 11g By: Satheesh.A on Tue, 31 May 2016	2	1199	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	4158	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	2699	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	4001	Sat, 28 May 2016 06:37 By: Solomon Yakobson
Indexes oracle 11g By: Satheesh.A on Fri, 27 May 2016	2	1327	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	1776	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	2636	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	1431	Thu, 26 May 2016 00:08 By: Michel Cadot
function is not giving correct output By: AmarendraSahoo2016 on Tue, 24 May 2016	4	1622	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	2072	Tue, 24 May 2016 21:35 By: arifs3738
Problem while inserting data in unix env By: amit.sonar on Mon, 23 May 2016	34	5561	Tue, 24 May 2016 09:33 By: Michel Cadot
first tuesday of every month ? sql developer By: nath123 on Fri, 20 May 2016	5	4434	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	3067	Tue, 24 May 2016 08:30 By: Bill B