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
Trigger to fill foreign key from another table 11.0.2.10 By: OraFerro on Sun, 11 June 2017	2	662	Sun, 11 June 2017 03:40 By: Michel Cadot
Update values "in groups" Oracle 12c, 12.1.0.2.0, MS Windows 7 By: Littlefoot on Fri, 09 June 2017	5	824	Fri, 09 June 2017 07:33 By: Solomon Yakobson
Handling invalid identifier exception in plsql oracle 11g By: ynkr999 on Wed, 07 June 2017	6	14699	Fri, 09 June 2017 00:54 By: Michel Cadot
Different result when using FOR UPDATE Oracle 11 By: hundsmiachn on Tue, 06 June 2017	4	794	Tue, 06 June 2017 09:56 By: Michel Cadot
dbms_output.put_line for dynamic sql query SQL*Plus: Release 11.2.0.3.0 Production By: shawaj on Tue, 30 May 2017	4	1259	Sat, 03 June 2017 03:28 By: shawaj
oracle external table issue oracle 11g , pl/sql, sql By: POGAKU_SANTHOSH on Wed, 31 May 2017	5	1236	Fri, 02 June 2017 19:03 By: Barbara Boehmer
Sequence generation for Parallel Processing ORACLE 11g, Windows By: lokimisc on Fri, 12 May 2017	21	2994	Fri, 02 June 2017 15:08 By: Bill B
Package to include a sleep inside a procedure Linux 2.6.39-400.286.3.el6uek.x86_64 - Oracle 11.2.0.4.0 By: Nagesh1985 on Thu, 01 June 2017	9	1589	Fri, 02 June 2017 13:33 By: Bill B
Passing value from one cursor to the other one. By: AkilaSubramanian on Tue, 24 May 2011	6	75504	Fri, 02 June 2017 09:34 By: Bill B
Creating foreign key constraints for nested tables of user defined types oracle Oracle By: Hatik on Thu, 01 June 2017	7	1231	Thu, 01 June 2017 22:35 By: Hatik
Query Db table with Key Value Oracle By: hippylou2u on Fri, 26 May 2017	10	1820	Wed, 31 May 2017 11:11 By: Solomon Yakobson
Armstrong numbers By: sridhar.sangubhatla on Tue, 03 July 2007	12	9936	Tue, 30 May 2017 08:20 By: ynkr999
Dependent Objects recursively Oracle 11.2.0.3 By: pointers on Mon, 29 May 2017	4	852	Tue, 30 May 2017 00:09 By: Michel Cadot
Using loop with a variable table name 10G By: shahid17 on Tue, 23 May 2017	8	1596	Mon, 29 May 2017 07:06 By: EdStevens
Help in Query to achieve output? Oracle 11g By: arifs3738 on Thu, 25 May 2017	8	1427	Sat, 27 May 2017 08:46 By: Solomon Yakobson
Create Year and week partition automatically 11.2.0.4 By: grpatwari on Mon, 22 May 2017	13	1968	Wed, 24 May 2017 08:25 By: Bill B
Improve Spool Performance Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit, AIX OS By: abhi_orcl on Mon, 22 May 2017	2	917	Tue, 23 May 2017 03:19 By: cookiemonster
Multiple rows based on column Oracle 10g By: sss111ind on Thu, 27 April 2017	9	2065	Mon, 22 May 2017 10:51 By: Michel Cadot
Oracle Sequences DB 11g, Forms 10 By: mbudzi2017 on Mon, 22 May 2017	11	1577	Mon, 22 May 2017 08:25 By: mbudzi2017
need help in rectifying error sql,oracle 11g By: sowk on Mon, 15 May 2017	11	1869	Mon, 22 May 2017 07:35 By: Bill B
Working of stored procedure Oracle 11g R2 version(11.2.0.1), pl1sql By: kaos.tissue on Sat, 20 May 2017	1	663	Sat, 20 May 2017 11:35 By: BlackSwan
Percentage of occurrences of a row Oracle 11g 11.2.0.2.0 By: Cirov on Wed, 17 May 2017	6	1127	Sat, 20 May 2017 03:55 By: Michel Cadot
listagg function in oracle Oracle 11g R2, pl/sql By: kaos.tissue on Thu, 18 May 2017	8	1283	Thu, 18 May 2017 14:54 By: Michel Cadot
Use ":NEW" in Dynamic SQL in Trigger? By: whdyck on Tue, 16 May 2017	16	1950	Thu, 18 May 2017 08:00 By: BlackSwan
Procedure not functioning properly Oracle 11g R2, pl/sql By: kaos.tissue on Thu, 18 May 2017	14	1692	Thu, 18 May 2017 07:41 By: Bill B
Operating with columns within a table Oracle 11g 11.2.0.2.0 By: Cirov on Sun, 14 May 2017	27	2520	Thu, 18 May 2017 06:41 By: EdStevens
snapshot too old PLSQL 11g By: kmnainani on Thu, 11 May 2017	22	3164	Wed, 17 May 2017 07:02 By: cookiemonster
ListAgg results 11.2 By: lott42 on Fri, 12 May 2017	9	1382	Mon, 15 May 2017 11:41 By: lott42
Loading Data into multiple tables Oracle 11g R2, pl/sql By: kaos.tissue on Fri, 12 May 2017	18	2161	Mon, 15 May 2017 06:56 By: EdStevens
filesystem_like_logging is not in ddl of table oracle 12.1.0.2,Windows Server 2014 By: chad_2000 on Mon, 15 May 2017	5	1010	Mon, 15 May 2017 06:48 By: chad_2000
Taking time from current day/month/year 06:00:00 to sysdate(Current Time) Oracle 10 g By: baranwalb on Sat, 13 May 2017	3	787	Sat, 13 May 2017 06:38 By: Michel Cadot
Multiple values in one-many relationship Oracle 11g R2, pl/sql By: kaos.tissue on Sat, 13 May 2017	2	746	Sat, 13 May 2017 02:51 By: kaos.tissue
Error SQL: ORA-02270: no matching unique or primary key for this column-list Oracle 11g By: Cirov on Fri, 12 May 2017	3	1366	Fri, 12 May 2017 10:51 By: Michel Cadot
Instead of Trigger Oracle 11g R2, pl/sql By: kaos.tissue on Sat, 06 May 2017	23	23388	Fri, 12 May 2017 10:13 By: Michel Cadot
Trigger to join and insert data into table. Oracle 11g R2, pl/sql By: kaos.tissue on Thu, 11 May 2017	39	3151	Fri, 12 May 2017 07:17 By: EdStevens
Pass two or more value Microsoft Visual Studio By: jen888 on Wed, 10 May 2017	3	760	Fri, 12 May 2017 06:40 By: cookiemonster
Using REGEXP_LIKE Oracle 12c By: GusGF on Fri, 12 May 2017	1	668	Fri, 12 May 2017 05:48 By: flyboy
Loop SP out cursor inside a stored procedure 11.0.2.10 By: OraFerro on Wed, 10 May 2017	9	2617	Thu, 11 May 2017 07:43 By: Michel Cadot
SP2-0552: Bind variable "LIMIT" not declared. Oracle database 11.2.04 on Linux By: youngb912 on Wed, 10 May 2017	2	841	Wed, 10 May 2017 19:24 By: youngb912
Using CHECK constraint to validate two types of telephone formatted insert data Oracle 11g Enterprise Ed. Release 11.2.0.1.0 - 64bit, Win 10 Home 64 bit Ed By: spd800c on Wed, 10 May 2017	4	1991	Wed, 10 May 2017 06:52 By: spd800c

Pages (1247): [ « ‹ 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Tue Sep 18 18:52:02 CDT 2018