|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Text to number conversion Oracle SQL Developer |
15 |
16221 |
Sat, 18 April 2020 07:14 By: Jamesconnor ![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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Function call in ref cursor Oracle 11gR2 |
7 |
7933 |
Wed, 15 April 2020 10: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) |
|
Create Materialized View throws "ORA-01031: insufficient privileges" Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
2 |
19229 |
Wed, 15 April 2020 07: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) |
|
Fine Grain Access control disabled but still prevents to create Materialized View Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
6 |
7961 |
Wed, 15 April 2020 07:21 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) |
|
Calculating the Difference of Timestamp in Min, Sec Windows 2012, 11g, 12c |
9 |
7639 |
Tue, 14 April 2020 07:45 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) |
|
create materialized view log with explicit constraint (merged) Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
3 |
4940 |
Mon, 13 April 2020 14:16 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) |
|
Filtering result from 2 PL/SQL UNION queries PL/SQL 9.0 By: gbuck on Thu, 09 April 2020 |
1 |
5967 |
Thu, 09 April 2020 15:45 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) |
|
Subquery returns more than one row - where clause -decode oracle 12c By: New50 on Wed, 08 April 2020 |
11 |
11015 |
Thu, 09 April 2020 14:40 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) |
|
Adding a from () to a query made it so slow 11.2.0.1.0 |
6 |
6979 |
Wed, 08 April 2020 08:13 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) |
|
getting finacial week number oracle 11gr2 |
15 |
17112 |
Sun, 05 April 2020 11:16 By: danielarias ![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 Full Email Body Text from File to CLOB Column? Oracle 12c |
1 |
5888 |
Thu, 02 April 2020 00:11 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) |
Fill in records where date missing in sequence Oracle 12c, Querying with SQL Developer v3.2.20.10 |
1 |
5236 |
Tue, 31 March 2020 23: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) |
|
Alter Regex to validate email Domain on RFC 5322 from Java to Oracle sql Oracle 11g, windows 10 By: Nicha on Fri, 27 March 2020 |
2 |
9562 |
Mon, 30 March 2020 12:41 By: Nicha ![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) |
|
Joined two tables on one row |
9 |
12839 |
Thu, 26 March 2020 05: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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Cursored FOR loops, PLS-00103 compile error 12.1.0.2.0 |
2 |
9248 |
Sun, 22 March 2020 18:27 By: thegerman ![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) |
|
Moving sequences from one schema to other with the next value. 12c , Solaris 10 |
14 |
15704 |
Sat, 21 March 2020 06:34 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) |
|
XS entity with this name already exists. Oracle form 12c By: Shiv93 on Wed, 18 March 2020 |
7 |
15380 |
Thu, 19 March 2020 04:18 By: Shiv93 ![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 :::Is there any other way to drop the column with out uncompression table in oracle database oracle 12c |
6 |
14286 |
Tue, 17 March 2020 12: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) |
|
different rows in set of data (using lead or alternative) 11.2.0.1.0 |
3 |
5167 |
Tue, 17 March 2020 04:20 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) |
|
Import CSV data from CLOB Oracle 12c, Unix |
32 |
17533 |
Wed, 11 March 2020 09:07 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) |
|
log ORA-01013: user requested cancel of current operation tips 11g |
20 |
20401 |
Wed, 11 March 2020 08:58 By: shthed@gmail.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) |
|
ORA-02069 Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 By: s4.ora on Tue, 10 March 2020 |
2 |
5396 |
Wed, 11 March 2020 08:34 By: s4.ora ![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) |
|
Locking issue while MATERIALIZED VIEW REFRESH PL/SQL Release 12.1.0.2.0 |
6 |
8802 |
Wed, 11 March 2020 07:28 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) |
|
MATERIALIZED VIEW REFRESH HISTORY Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production |
1 |
5461 |
Wed, 11 March 2020 07:18 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 inserts without Loops |
2 |
4201 |
Tue, 10 March 2020 06:10 By: _jum ![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) |
|
Analytic Function: How to Partition Hierarchical Data By: whdyck on Mon, 09 March 2020 |
1 |
3468 |
Mon, 09 March 2020 13:03 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) |
|
exit when cursor%notfound is giving buffer overflow if not being used in anonymous block (merged) |
18 |
11626 |
Thu, 05 March 2020 10:19 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) |
|
Select statement inside IF statement for comparing a given string with records in table |
27 |
16020 |
Tue, 03 March 2020 02: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) |
|
convert rows to column in SQL 12C |
1 |
6878 |
Sat, 29 February 2020 00:58 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) |
|
embedded implicit cursors in SQL Oracle, Win 10 |
1 |
6181 |
Sat, 29 February 2020 00: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) |
|
query-assistance Oracle 11g By: winfire on Fri, 28 February 2020 |
4 |
6277 |
Fri, 28 February 2020 08:26 By: winfire ![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) |
|
Time Between Consecutive Locations Oracle 12c By: run400 on Mon, 24 February 2020 |
4 |
6375 |
Fri, 28 February 2020 03:21 By: _jum ![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 11g Sequence(merged) 11g By: moyida on Thu, 27 February 2020 |
7 |
5815 |
Thu, 27 February 2020 12:27 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 Fetch merged rows back ! |
2 |
3513 |
Thu, 27 February 2020 05:21 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) |
|
regexp_replace (merged 2) By: akarra on Wed, 26 February 2020 |
8 |
5301 |
Wed, 26 February 2020 15:04 By: akarra ![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 (and lock) first unlocked row?! By: emirc on Mon, 16 May 2005 |
8 |
21887 |
Wed, 26 February 2020 06: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) |
|
Single update to get one column value using another column value Oracle 12c |
12 |
6493 |
Tue, 25 February 2020 07:44 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) |
|
Return defined column size of varchar and varchar2 data types |
3 |
7555 |
Mon, 24 February 2020 05:55 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) |
|
Tab Delimited Oracle Database 11g -Oracle JDBC driver- Linux |
3 |
7104 |
Sat, 22 February 2020 08:31 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) |
|
Start Transactional Control in PL/SQL Oracle Database By: aks11 on Wed, 19 February 2020 |
6 |
6798 |
Fri, 21 February 2020 12:06 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |