|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
PL/SQL: ORA-04053: error occurred when validating remote object oracle12c |
3 |
8458 |
Mon, 23 July 2018 11:10 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) |
|
Oracle materialized views workflow |
3 |
6068 |
Fri, 20 July 2018 13:19 By: Lalit Kumar 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) |
|
ORA-04091: table Table_Name is mutating, trigger/function may not see it Oracle 11g With Apex 5.1 |
7 |
10062 |
Fri, 20 July 2018 04:16 By: elmomagalona ![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) |
![icon1.gif](/forum/images/message_icons/icon1.gif) |
Get last record from another table 11g |
17 |
10723 |
Wed, 18 July 2018 05:26 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) |
|
Need Help on Pl/Sql Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production |
11 |
9108 |
Tue, 17 July 2018 12:19 By: Lalit Kumar 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) |
|
query performance 11g |
3 |
6570 |
Tue, 17 July 2018 06:29 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) |
|
how to work around the substitution variables in plsql Oracle 12c By: mgag on Mon, 02 July 2018 |
3 |
6645 |
Tue, 17 July 2018 06:26 By: ajaychinna ![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) |
|
Generate New Excel format (XLSX) files using Oracle PLSQL Oracle 11.2.0.4 By: nickz on Fri, 13 July 2018 |
3 |
15885 |
Mon, 16 July 2018 06:52 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 Help on Creating FUNCTION |
13 |
9138 |
Wed, 11 July 2018 03:43 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) |
|
SELECT QUERY Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production |
6 |
6636 |
Wed, 11 July 2018 03:38 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) |
|
rownum from table |
7 |
6800 |
Tue, 10 July 2018 06:06 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) |
|
How can bulk insert into the parent , child tables Oracle Linux 6.7, Oracle 12.1.0.2.0 By: fabi88 on Sun, 08 July 2018 |
10 |
10764 |
Tue, 10 July 2018 05:30 By: fabi88 ![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) |
|
Report query Oracle 12CR2 |
10 |
8502 |
Mon, 09 July 2018 12:38 By: joy_division ![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) |
|
type of constraints |
4 |
5730 |
Mon, 09 July 2018 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) |
|
problem with concatenation and group by functions 11g |
11 |
8335 |
Thu, 05 July 2018 07:51 By: achraf87 ![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) |
|
Stored Procedure / Deletion Conflict Oracle 12C |
13 |
7663 |
Thu, 05 July 2018 03: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) |
|
Help required on ranking logic |
6 |
5962 |
Tue, 03 July 2018 23:11 By: ramya29p ![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 get decimal value from string and convert 11g By: tikun on Thu, 28 June 2018 |
18 |
11040 |
Tue, 03 July 2018 06:19 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) |
|
Extract domain name from email address field PS/SQL By: heidibb on Tue, 29 November 2011 |
19 |
30880 |
Tue, 03 July 2018 06:15 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) |
|
Select using DBMS_SQL.EXECUTE (merged) Oracle Linux 6.7, Oracle 12.1.0.2.0 By: fabi88 on Mon, 02 July 2018 |
6 |
7481 |
Mon, 02 July 2018 04:07 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) |
|
Alter Table <<table name>> add partition by range does not work Oracle 11g |
4 |
7491 |
Fri, 29 June 2018 06:52 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) |
|
How to replace the new line and line feed in a specific manner oracle 11g |
5 |
8640 |
Thu, 28 June 2018 01:43 By: POGAKU_SANTHOSH ![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) |
|
Fetching Unix Folder Name and Timestamp in SQL/PLSQL Oracle 11.2.0.4 By: nickz on Fri, 08 June 2018 |
26 |
17754 |
Mon, 25 June 2018 14:05 By: nickz ![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) |
|
Difference between two dates |
9 |
7069 |
Mon, 25 June 2018 06:48 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) |
|
Compare current and previous record Oracle 10 g |
13 |
11085 |
Wed, 20 June 2018 11:50 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) |
SQL: Substring folder name based on numeric value Oracle DB 11.2.0.4 By: nickz on Thu, 14 June 2018 |
11 |
9533 |
Wed, 20 June 2018 02:06 By: nickz ![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) |
|
Help Grouping by By: akull on Mon, 18 June 2018 |
6 |
5515 |
Mon, 18 June 2018 11:33 By: akull ![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) |
|
divide text string into different columns |
10 |
8733 |
Mon, 18 June 2018 10:33 By: suji6281 ![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 of inserting a long string of characters :ORA-22835: Taille de tampon insuffisante pour la c 11g |
2 |
6246 |
Mon, 18 June 2018 08:53 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) |
|
Use multi-threading in PL/SQL Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production |
1 |
11051 |
Mon, 18 June 2018 07:53 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) |
|
Commit Process 10g,WIndows 10 |
2 |
4811 |
Mon, 18 June 2018 04:29 By: gazzag ![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) |
|
oracle large query text 11gr2 on rhel (11.2.0.4.0) |
9 |
6774 |
Wed, 13 June 2018 18:01 By: ramd2530 ![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 display last day of a century Oracle 11g |
3 |
5147 |
Wed, 13 June 2018 11:23 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) |
|
USERENV, and OS_USER |
3 |
4858 |
Wed, 13 June 2018 11:09 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) |
|
How to restrict IN parameter length in Procedure Oracle 11g DB, Windows 7 |
5 |
5421 |
Wed, 13 June 2018 02:04 By: bala.b@outlook.com ![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) |
|
Want to execute 900 query's, is there any faster way to execute Oracle SQL Developer |
9 |
6437 |
Wed, 06 June 2018 15:08 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) |
|
Multiple tables joining |
5 |
5067 |
Mon, 04 June 2018 08:42 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) |
|
does execute immediate create a new connection? |
2 |
4812 |
Fri, 01 June 2018 13:48 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) |
|
Oracle.ucp.jdbc.HarvestableConnection error Oracle 11G Suse Linux |
1 |
4132 |
Fri, 01 June 2018 09:35 By: John Watson ![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) |
|
Hierarchy problem 11.2.0.3 By: Amine on Mon, 28 May 2018 |
3 |
5297 |
Fri, 01 June 2018 00:43 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |