|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle Sequences DB 11g, Forms 10 |
11 |
5487 |
Mon, 22 May 2017 08:25 By: mbudzi2017 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
need help in rectifying error sql,oracle 11g By: sowk on Mon, 15 May 2017 |
11 |
5695 |
Mon, 22 May 2017 07:35 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Working of stored procedure Oracle 11g R2 version(11.2.0.1), pl1sql |
1 |
2301 |
Sat, 20 May 2017 11:35 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Percentage of occurrences of a row Oracle 11g 11.2.0.2.0 By: Cirov on Wed, 17 May 2017 |
6 |
3394 |
Sat, 20 May 2017 03:55 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
listagg function in oracle Oracle 11g R2, pl/sql |
8 |
4579 |
Thu, 18 May 2017 14:54 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Use ":NEW" in Dynamic SQL in Trigger? By: whdyck on Tue, 16 May 2017 |
16 |
5964 |
Thu, 18 May 2017 08:00 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Procedure not functioning properly Oracle 11g R2, pl/sql |
14 |
5483 |
Thu, 18 May 2017 07:41 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Operating with columns within a table Oracle 11g 11.2.0.2.0 By: Cirov on Sun, 14 May 2017 |
27 |
9510 |
Thu, 18 May 2017 06:41 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
snapshot too old PLSQL 11g |
22 |
11215 |
Wed, 17 May 2017 07:02 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ListAgg results 11.2 |
9 |
4907 |
Mon, 15 May 2017 11:41 By: lott42_gmail ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Loading Data into multiple tables Oracle 11g R2, pl/sql |
18 |
8940 |
Mon, 15 May 2017 06:56 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
filesystem_like_logging is not in ddl of table oracle 12.1.0.2,Windows Server 2014 |
5 |
3283 |
Mon, 15 May 2017 06:48 By: chad_2000 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Taking time from current day/month/year 06:00:00 to sysdate(Current Time) Oracle 10 g |
3 |
3208 |
Sat, 13 May 2017 06:38 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Multiple values in one-many relationship Oracle 11g R2, pl/sql |
2 |
2296 |
Sat, 13 May 2017 02:51 By: kaos.tissue ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Error SQL: ORA-02270: no matching unique or primary key for this column-list Oracle 11g By: Cirov on Fri, 12 May 2017 |
3 |
6785 |
Fri, 12 May 2017 10:51 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Instead of Trigger Oracle 11g R2, pl/sql |
23 |
29629 |
Fri, 12 May 2017 10:13 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Trigger to join and insert data into table. Oracle 11g R2, pl/sql |
39 |
11797 |
Fri, 12 May 2017 07:17 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Pass two or more value Microsoft Visual Studio By: jen888 on Wed, 10 May 2017 |
3 |
2712 |
Fri, 12 May 2017 06:40 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Using REGEXP_LIKE Oracle 12c By: GusGF on Fri, 12 May 2017 |
1 |
2404 |
Fri, 12 May 2017 05:48 By: flyboy ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Loop SP out cursor inside a stored procedure 11.0.2.10 |
9 |
6258 |
Thu, 11 May 2017 07:43 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SP2-0552: Bind variable "LIMIT" not declared. Oracle database 11.2.04 on Linux |
2 |
3728 |
Wed, 10 May 2017 19:24 By: youngb912 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
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 |
4 |
4228 |
Wed, 10 May 2017 06:52 By: spd800c ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
problem with FLOOR function oracle By: omidsm on Wed, 10 May 2017 |
4 |
3749 |
Wed, 10 May 2017 03:38 By: omidsm ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Decode and To_date By: SamP17 on Mon, 08 May 2017 |
13 |
7788 |
Wed, 10 May 2017 03:24 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
invalid file operation Oracle 12C , IBM AIX |
5 |
5077 |
Tue, 09 May 2017 11:08 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Produce output not having any or all inputs (products) |
1 |
3087 |
Tue, 09 May 2017 11:06 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Returning Old value during update Oracle 10g |
12 |
48046 |
Tue, 09 May 2017 10:37 By: Olivier Comte ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Outer Join on Table Forms 6i |
8 |
3767 |
Tue, 09 May 2017 03:27 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Dynamic array as SP input 11.0.2.10 |
12 |
6405 |
Tue, 09 May 2017 01:58 By: OraFerro ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
how to add to the right side of my table, the colums and data of 2 other tables . Oracle 12c By: mpniel on Mon, 08 May 2017 |
5 |
2578 |
Mon, 08 May 2017 10:50 By: mpniel ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Adding missing values in external table Oracle 11g R2, pl/sql |
7 |
3147 |
Sat, 06 May 2017 07:20 By: Solomon Yakobson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Get Return Value from Function without SELECT By: whdyck on Thu, 04 May 2017 |
8 |
4273 |
Fri, 05 May 2017 12:00 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Using Virtual Column Oracle 11g R2, pl/sql |
18 |
6103 |
Fri, 05 May 2017 05:06 By: kaos.tissue ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ORA-14097 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 |
2 |
2886 |
Thu, 04 May 2017 15:53 By: scottwmackey ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Inserting data in multiple tables Oracle 11g R2, pl/sql |
27 |
8704 |
Thu, 04 May 2017 08:34 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Need to get the top 3 employees whose salary increased in three consecutive year Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Product ,window |
6 |
3841 |
Mon, 01 May 2017 03:05 By: arpit0508 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
COnditional change Serial Oracle 11G, Windows 2003 |
2 |
2312 |
Thu, 27 April 2017 02:23 By: mmohsinaziz ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
NOT LIKE operation on the numbers columns Oracle 12c |
20 |
8911 |
Wed, 26 April 2017 10:47 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Issue with DATE |
5 |
3462 |
Wed, 26 April 2017 06:49 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL Tunning - Please Help Me Oracle 10g |
21 |
7245 |
Mon, 24 April 2017 18:21 By: mikek ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |