|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
dense_rank performance |
1 |
3970 |
Sat, 30 December 2017 08:07 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![This topic has been locked](/forum/theme/orafaq/images/readlocked.png) |
|
Cant use replication from SQL Server 2008 to Sybase? sql-server 2008 |
1 |
4446 |
Sat, 30 December 2017 02:17 By: Littlefoot ![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) |
|
regexp_substr 12c |
6 |
6029 |
Fri, 29 December 2017 10:57 By: Littlefoot ![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) |
|
mysql and oracle issue using dblink |
2 |
4516 |
Fri, 29 December 2017 07:54 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) |
|
last date of the year |
3 |
4531 |
Thu, 28 December 2017 07:40 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) |
|
current date - preovious date calculations |
18 |
11098 |
Wed, 27 December 2017 21:59 By: Barbara Boehmer ![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) |
|
over partition by |
14 |
10487 |
Wed, 27 December 2017 09:02 By: sshree12 ![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) |
|
Open cursor 11g32 linux(RHEL) |
2 |
3140 |
Wed, 27 December 2017 06:20 By: dba4oracle ![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) |
|
Set timestamp with milliseconds to default to 0 milliseconds Oracle 11g |
2 |
6342 |
Wed, 27 December 2017 00:44 By: Littlefoot ![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) |
|
Create a combination DML Trigger Oracle 11gr2, multiple OS platform |
5 |
4741 |
Tue, 26 December 2017 12:22 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) |
|
How To Delete older data less than 10 years Oracle11g By: ssyr on Fri, 15 December 2017 |
18 |
9208 |
Sun, 24 December 2017 03:46 By: SmithXu ![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) |
|
Find where exception occurred in oracle procedure Oracle Plsql, Oracle 12C, Unix/Linux |
6 |
5236 |
Fri, 22 December 2017 02:50 By: pavan_mrt ![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 cast collection in table |
4 |
6027 |
Thu, 21 December 2017 22:29 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) |
|
CLOB to file Oracle 11g, Win 7 |
1 |
3700 |
Thu, 21 December 2017 11:49 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) |
|
LIKE Operator in MERGE Oracle,12c,Unix |
6 |
4191 |
Thu, 21 December 2017 07:10 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) |
|
How to execute a result of another table. |
10 |
5999 |
Wed, 20 December 2017 08:18 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) |
|
create table in another schema By: malu on Wed, 13 December 2017 |
6 |
7794 |
Wed, 20 December 2017 07:56 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) |
|
Help regarding regexp_substr oracle 11g |
3 |
3999 |
Wed, 20 December 2017 07:13 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) |
|
Oracle 12c injection Oracle 12c |
1 |
3146 |
Tue, 19 December 2017 00:43 By: Littlefoot ![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 When Refreshing Materialized View Oracle 10g By: ANU_IN on Sun, 17 December 2017 |
2 |
3669 |
Mon, 18 December 2017 06:33 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) |
|
CREATE VIEW with "SELECT * FROM" several tables Oracle 11 / Oracle 12 By: Rumak18 on Tue, 12 December 2017 |
12 |
6345 |
Fri, 15 December 2017 07:40 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) |
|
Need to Retrieve data from JSON file in Oracle sql select query Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Thu, 11 August 2016 |
10 |
7375 |
Thu, 14 December 2017 08:39 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) |
|
Help for getting information where external table used in database Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: msol25 on Thu, 14 December 2017 |
2 |
3370 |
Thu, 14 December 2017 01:36 By: msol25 ![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) |
|
Retrieve column names with aliases Oracle 10g |
7 |
4285 |
Tue, 12 December 2017 15:14 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) |
|
ORA-01502: index or partition of such index is in usable Oracle 12C (12.1.0.2.0) |
3 |
4149 |
Tue, 12 December 2017 05:09 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) |
|
i need to know hows this happening? By: amul on Wed, 19 July 2006 |
8 |
4960 |
Mon, 11 December 2017 09:30 By: appailoveyou ![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) |
|
Temporary LOBs, temp space, PGA DB 12.x |
3 |
4718 |
Fri, 08 December 2017 11:53 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) |
|
sequence problem? forms 6i , 11g db |
23 |
12901 |
Fri, 08 December 2017 06:18 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) |
|
How to convert column to rows Oracle 11g |
1 |
3455 |
Fri, 08 December 2017 01:49 By: sss111ind ![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 in Query for Required output Oracle8i Enterprise Edition Release 8.1.7.0.0 By: shawaj on Tue, 05 December 2017 |
17 |
8602 |
Wed, 06 December 2017 09:30 By: shawaj ![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) |
![icon7.gif](/forum/images/message_icons/icon7.gif) |
Number Conversion Oracle 10g |
2 |
2925 |
Wed, 06 December 2017 03:58 By: maanosajnabi ![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) |
|
Term Match with Jaro-Winkler logic 11 |
14 |
9916 |
Tue, 05 December 2017 10:48 By: Barbara Boehmer ![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) |
|
remove duplicate values by date all |
8 |
7679 |
Tue, 05 December 2017 07:10 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) |
|
SQL Query 11g By: LKT on Fri, 01 December 2017 |
11 |
7531 |
Mon, 04 December 2017 03:02 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) |
|
Difference in SQL 'order by' and MIN, MAX, LISTAGG results oracle 12c, client 11G sous windows |
25 |
12791 |
Fri, 01 December 2017 10:27 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) |
|
regexp_replace() function help |
9 |
5274 |
Fri, 01 December 2017 08:57 By: wtolentino ![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) |
|
Function Creation By: WhoAmI on Wed, 29 November 2017 |
5 |
4368 |
Thu, 30 November 2017 03:31 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) |
|
switch data positions |
4 |
4406 |
Wed, 29 November 2017 11:06 By: wtolentino ![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) |
|
trigger impacting performance 11g32 linux(RHEL) |
14 |
5815 |
Wed, 29 November 2017 06:05 By: dba4oracle ![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) |
|
Packages By: rkapex on Sat, 25 November 2017 |
6 |
4881 |
Mon, 27 November 2017 08:04 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |