|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
updated column on the same table automatically 11.2.0.4.0 - 64bit Production By: mist598 on Mon, 04 September 2017 |
8 |
33077 |
Thu, 07 September 2017 11:58 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) |
|
phone type sql |
15 |
24940 |
Wed, 06 September 2017 05:17 By: quirks ![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) |
|
where clause between to sysdates By: dhuuk42 on Wed, 06 September 2017 |
3 |
10893 |
Wed, 06 September 2017 04:51 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 extract data from oracle table having space in column name using vba code? By: oracbeg on Tue, 05 September 2017 |
4 |
69379 |
Tue, 05 September 2017 09:01 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) |
|
PLSQL Procedure to Grant Privs on Schema Objects Oracle Database 12.1.0.2 on Linux 6.9 By: Lucky A on Fri, 01 September 2017 |
7 |
76662 |
Tue, 05 September 2017 04:12 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 u'' from dual; What does u mean? in this sql. Oracle 11G, 2.0.1 |
2 |
26193 |
Tue, 05 September 2017 04:11 By: chrisindya ![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) |
|
the records with common cust_id should not be shown. |
12 |
24669 |
Mon, 04 September 2017 02:26 By: quirks ![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 Oracle 11g |
5 |
27620 |
Mon, 04 September 2017 02:00 By: quirks ![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 statement to PL/SQL By: winfire on Fri, 01 September 2017 |
6 |
13811 |
Mon, 04 September 2017 01:37 By: quirks ![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) |
|
Bulk Inserts with CLOB column Slower in Oracle 12c than Oracle 11g Oracle 12.1. |
10 |
23283 |
Sun, 03 September 2017 06:38 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) |
|
Unexpected weird result A+A' != U 10.2.0.1.0 |
7 |
77653 |
Fri, 01 September 2017 02:24 By: Roachcoach ![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 show multiple data in single row Oracle11g By: ssyr on Tue, 29 August 2017 |
4 |
22149 |
Fri, 01 September 2017 01:44 By: ssyr ![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 query Oracle11g By: ssyr on Thu, 31 August 2017 |
1 |
15516 |
Thu, 31 August 2017 05:36 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) |
|
Conversion into Clob from Varchar2 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
4 |
11164 |
Wed, 30 August 2017 03:12 By: saipradyumn ![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_INSTR Oracle 12c,NT |
8 |
16769 |
Wed, 30 August 2017 02:37 By: pstanand ![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) |
Question about printing the result of a recursive subquery factoring with line indents |
1 |
3475 |
Tue, 29 August 2017 17:30 By: dariyoosh ![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) |
|
Invalid Datatype error for record type Oracle 11g By: Rotan on Tue, 29 August 2017 |
3 |
11094 |
Tue, 29 August 2017 14:50 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) |
|
Visualize Processes Vertical Oracle 12 By: quirks on Mon, 21 August 2017 |
10 |
17810 |
Tue, 29 August 2017 06:19 By: quirks ![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 lookup function in loop returns rowtype how to get fields from rowtype Oracle 12g |
3 |
25545 |
Tue, 29 August 2017 03:38 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) |
|
Error Linking to C DLL from PL/SQL Local Oracle 12c - Windows 10 |
8 |
16753 |
Mon, 28 August 2017 15:53 By: jhgerold ![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) |
|
Cursor within a cursor Oracle Database 11g Enterprise Edition Release |
1 |
9347 |
Mon, 28 August 2017 13:30 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) |
|
Help with PL SQL query - Analytical Function or group by 12c |
5 |
4154 |
Sat, 26 August 2017 07:47 By: Flyby ![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) |
|
Wanted to delete duplicate records Oracle 11 g |
8 |
21494 |
Thu, 24 August 2017 10:07 By: samiran_cts ![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) |
|
Applying function on column having multiple datatypes |
6 |
4820 |
Tue, 22 August 2017 07:51 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) |
|
Using Trigger in Oracle DB to update a table in SQL Server DB Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: queeny on Tue, 22 August 2017 |
5 |
8418 |
Tue, 22 August 2017 07:43 By: Michel Cadot ![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) |
|
File compressing is not happening Oracle 11g , 11.2.0.3.0 |
2 |
2984 |
Tue, 22 August 2017 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) |
|
Max function PL SQL By: OldDog on Sun, 20 August 2017 |
9 |
4862 |
Tue, 22 August 2017 02:51 By: quirks ![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) |
|
Join and group by on multiple tables Oracle 11g |
2 |
11737 |
Mon, 21 August 2017 08: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) |
|
Solution for ora-00020 maximum number of processes oracle database 8i |
17 |
43396 |
Sun, 20 August 2017 02:23 By: amjad_alahdal ![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 12c |
3 |
3281 |
Fri, 18 August 2017 14:23 By: arifmd1705 ![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) |
|
Should I Clean Up My Collections? 11g By: whdyck on Thu, 17 August 2017 |
8 |
219576 |
Fri, 18 August 2017 09:37 By: whdyck ![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) |
|
Triggers on editioning views inheriting trigger events from NEWER editions Oracle Database - Enterprise Edition Product Version 12.1.0.2 Linux x86-64 OS Version Red Hat Enterprise 6 |
7 |
4608 |
Fri, 18 August 2017 05:36 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) |
|
Setting Edition // Remote Database Oracle 11.2.0.4 |
13 |
6736 |
Fri, 18 August 2017 02:26 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) |
|
Need to get the comma separated value |
4 |
5250 |
Thu, 17 August 2017 12:05 By: rajeshsvnr ![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) |
|
Determine filePath/Name from UTL_FILE.FILE_TYPE? Oracle 11g By: bkuhn on Wed, 16 August 2017 |
4 |
7388 |
Thu, 17 August 2017 09:20 By: bkuhn ![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) |
|
qualification_ind value meaning (2 threads merged by bb, including one hijacked from unrelated thread http://www.orafaq.com/forum/stt/76498/) |
6 |
4569 |
Wed, 16 August 2017 20:47 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) |
|
MISSING DATE oracle 11g , database 11g, windows 7 |
6 |
3358 |
Tue, 15 August 2017 07:37 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) |
|
member procedure execution oracle 11g |
3 |
3516 |
Tue, 15 August 2017 00:16 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) |
|
Code Help: Inserting Records based on records in another table meeting certain parameters Oracle SQL Developer By: cem616 on Wed, 09 August 2017 |
6 |
3974 |
Mon, 14 August 2017 14:07 By: buggleboy007 ![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) |
|
Rectify the code |
9 |
6019 |
Mon, 14 August 2017 06:49 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |