| |
|
Topic |
Replies |
Views |
Last message |
 |
|
How too convert rows into columns based on order hiredate month wise
oracle 12c |
1 |
4024 |
Fri, 24 April 2020 00:57
By: Michel Cadot  |
|
|
Need age difference between warning and critical
Oracle |
9 |
5782 |
Wed, 22 April 2020 12:10
By: Michel Cadot |
|
|
Duplicate returns from list of Values
Oracle APEX By: WillJ on Fri, 17 April 2020 |
20 |
10646 |
Wed, 22 April 2020 10:26
By: WillJ |
|
|
Emp Code Searching Issue
Oracle DB 12C By: wasimK on Tue, 21 April 2020 |
6 |
4361 |
Tue, 21 April 2020 11:52
By: Michel Cadot |
|
|
Extracting specific portion of a string using REGEX
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professiona |
3 |
4045 |
Mon, 20 April 2020 17:31
By: buggleboy007 |
|
|
PL/SQL Stored Procedure Showing Oracle Error 27476 (Job Doesn't Exist)
Oracle 12c |
2 |
2527 |
Mon, 20 April 2020 14:43
By: bmccollum |
|
|
RAISE_APPLICATION_ERROR not invoked by Logon trigger
Oracle 11.2.0.3.0 SE , Oracle 12.1.0.2.0 SE |
10 |
5795 |
Mon, 20 April 2020 11:28
By: Michel Cadot |
|
|
Hierarchy again and again
11.2.0.3.0 By: Amine on Sun, 19 April 2020 |
5 |
3181 |
Mon, 20 April 2020 08:42
By: Amine |
|
|
Text to number conversion
Oracle SQL Developer |
15 |
13069 |
Sat, 18 April 2020 07:14
By: Jamesconnor |
|
 |
Function call in ref cursor
Oracle 11gR2 |
7 |
6275 |
Wed, 15 April 2020 10:07
By: Michel Cadot |
|
|
Create Materialized View throws "ORA-01031: insufficient privileges"
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
2 |
10943 |
Wed, 15 April 2020 07:23
By: Michel Cadot |
|
|
Fine Grain Access control disabled but still prevents to create Materialized View
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
6 |
6192 |
Wed, 15 April 2020 07:21
By: Michel Cadot |
|
|
 Calculating the Difference of Timestamp in Min, Sec
Windows 2012, 11g, 12c |
9 |
5831 |
Tue, 14 April 2020 07:45
By: Michel Cadot |
|
|
create materialized view log with explicit constraint (merged)
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
3 |
3621 |
Mon, 13 April 2020 14:16
By: wtolentino |
|
|
Filtering result from 2 PL/SQL UNION queries
PL/SQL 9.0 By: gbuck on Thu, 09 April 2020 |
1 |
4531 |
Thu, 09 April 2020 15:45
By: Michel Cadot |
|
|
Subquery returns more than one row - where clause -decode
oracle 12c By: New50 on Wed, 08 April 2020 |
11 |
8708 |
Thu, 09 April 2020 14:40
By: Michel Cadot |
|
|
Adding a from () to a query made it so slow
11.2.0.1.0 |
6 |
5538 |
Wed, 08 April 2020 08:13
By: OraFerro |
|
|
getting finacial week number
oracle 11gr2 |
15 |
14908 |
Sun, 05 April 2020 11:16
By: danielarias |
|
|
How To Add Full Email Body Text from File to CLOB Column?
Oracle 12c |
1 |
4708 |
Thu, 02 April 2020 00:11
By: Michel Cadot |
|
 |
Fill in records where date missing in sequence
Oracle 12c, Querying with SQL Developer v3.2.20.10 |
1 |
3895 |
Tue, 31 March 2020 23:43
By: Michel Cadot |
|
|
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 |
7715 |
Mon, 30 March 2020 12:41
By: Nicha |
|
|
Joined two tables on one row |
9 |
10743 |
Thu, 26 March 2020 05:02
By: Michel Cadot |
|
|
Cursored FOR loops, PLS-00103 compile error
12.1.0.2.0 |
2 |
6701 |
Sun, 22 March 2020 18:27
By: thegerman |
|
|
Moving sequences from one schema to other with the next value.
12c , Solaris 10 |
14 |
11044 |
Sat, 21 March 2020 06:34
By: Solomon Yakobson |
|
|
XS entity with this name already exists.
Oracle form 12c By: Shiv93 on Wed, 18 March 2020 |
7 |
11687 |
Thu, 19 March 2020 04:18
By: Shiv93 |
|
|
ORACLE :::Is there any other way to drop the column with out uncompression table in oracle database
oracle 12c |
6 |
11281 |
Tue, 17 March 2020 12:41
By: Bill B |
|
|
different rows in set of data (using lead or alternative)
11.2.0.1.0 |
3 |
3788 |
Tue, 17 March 2020 04:20
By: OraFerro |
|
|
Import CSV data from CLOB
Oracle 12c, Unix |
32 |
14926 |
Wed, 11 March 2020 09:07
By: cookiemonster |
|
|
log ORA-01013: user requested cancel of current operation tips
11g |
20 |
18350 |
Wed, 11 March 2020 08:58
By: shthed@gmail.com |
|
|
ORA-02069
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 By: s4.ora on Tue, 10 March 2020 |
2 |
3866 |
Wed, 11 March 2020 08:34
By: s4.ora |
|
|
Locking issue while MATERIALIZED VIEW REFRESH
PL/SQL Release 12.1.0.2.0 |
6 |
7118 |
Wed, 11 March 2020 07:28
By: Bill B |
|
|
MATERIALIZED VIEW REFRESH HISTORY
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production |
1 |
3830 |
Wed, 11 March 2020 07:18
By: Bill B |
|
|
multiple inserts without Loops |
2 |
2926 |
Tue, 10 March 2020 06:10
By: _jum |
|
|
Analytic Function: How to Partition Hierarchical Data By: whdyck on Mon, 09 March 2020 |
1 |
2298 |
Mon, 09 March 2020 13:03
By: Michel Cadot |
|
|
exit when cursor%notfound is giving buffer overflow if not being used in anonymous block (merged) |
18 |
9471 |
Thu, 05 March 2020 10:19
By: Michel Cadot |
|
|
Select statement inside IF statement for comparing a given string with records in table |
27 |
13236 |
Tue, 03 March 2020 02:43
By: cookiemonster |
|
|
convert rows to column in SQL
12C |
1 |
5547 |
Sat, 29 February 2020 00:58
By: Michel Cadot |
|
|
embedded implicit cursors in SQL
Oracle, Win 10 |
1 |
5040 |
Sat, 29 February 2020 00:54
By: Michel Cadot |
|
|
query-assistance
Oracle 11g By: winfire on Fri, 28 February 2020 |
4 |
5221 |
Fri, 28 February 2020 08:26
By: winfire |
|
|
Time Between Consecutive Locations
Oracle 12c By: run400 on Mon, 24 February 2020 |
4 |
5169 |
Fri, 28 February 2020 03:21
By: _jum |
Search
Help
Members
Register
Login
Home
