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
External Table and Blank spaces Oracle 12C Windows NT By: pstanand on Mon, 13 June 2016	14	13664	Tue, 14 June 2016 11:01 By: Michel Cadot
order of geting value from sequence by trigger Oracle 11g By: miodas007 on Wed, 01 June 2016	6	5440	Mon, 13 June 2016 09:58 By: Bill B
Extract the most data after joining 3 tables Oracle SQL By: misy on Sat, 11 June 2016	8	2578	Sat, 11 June 2016 16:47 By: Barbara Boehmer
Query that gives many different values By: Jdevil on Fri, 20 May 2016	22	4464	Sat, 11 June 2016 10:43 By: EdStevens
error 04063 creating view By: loginel on Fri, 10 June 2016	3	1912	Fri, 10 June 2016 17:31 By: Barbara Boehmer
Listing individual average price Oracle SQL By: misy on Thu, 09 June 2016	3	1961	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	4277	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	1295	Fri, 10 June 2016 08:35 By: Bill B
Oracle Special character while dbms_output 11g By: harshadsp on Thu, 09 June 2016	16	9669	Fri, 10 June 2016 03:29 By: harshadsp
Rebuild table contain partition Oracle database 10g By: dophuong_cs on Wed, 08 June 2016	3	2393	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	6171	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	4696	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	2425	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	2618	Tue, 07 June 2016 11:46 By: adfnewbie
Number to words pl sql By: raghuramgupta on Tue, 07 June 2016	5	2779	Tue, 07 June 2016 11:35 By: Bill B
union all and sql*plus By: Eugene on Thu, 26 December 2002	8	30457	Tue, 07 June 2016 06:38 By: EdStevens
Convert Rows to Columns Oracle 11g By: arifs3738 on Sun, 05 June 2016	9	19700	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	2397	Sat, 04 June 2016 23:35 By: bdtran
Pattern recognition problem 12.1.0.2 By: bdtran on Thu, 26 May 2016	11	3705	Sat, 04 June 2016 13:10 By: bdtran
Transpose rows to columns without aggregation By: dancko on Sat, 04 June 2016	9	2978	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	4836	Fri, 03 June 2016 22:08 By: nath123
Issue with UTL_FILE.INVALID_OPERATION 11g By: namitanamburi on Wed, 01 June 2016	7	2434	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	5536	Fri, 03 June 2016 15:13 By: Michel Cadot
transpose and insert the data oracle 11g By: tolupuluri on Fri, 27 May 2016	19	3783	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	1979	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	3463	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	1718	Thu, 02 June 2016 07:43 By: Bill B
package error By: narang_me12 on Wed, 01 June 2016	7	2507	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	17528	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	8975	Tue, 31 May 2016 22:14 By: pstanand
Filler / Bound Filler in External tables oracle 11g By: ORAGENASHOK on Tue, 31 May 2016	2	1751	Tue, 31 May 2016 08:28 By: Bill B
Loops oracle 11g By: Satheesh.A on Tue, 31 May 2016	7	1853	Tue, 31 May 2016 04:03 By: Satheesh.A
DDL commands oracle 11g By: Satheesh.A on Tue, 31 May 2016	2	1247	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	4212	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	2745	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	4051	Sat, 28 May 2016 06:37 By: Solomon Yakobson
Indexes oracle 11g By: Satheesh.A on Fri, 27 May 2016	2	1365	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	1822	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	2682	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	1471	Thu, 26 May 2016 00:08 By: Michel Cadot