| |
|
Topic |
Replies |
Views |
Last message |
 |
|
Scrambling the data for dev environment after refresh to hide/mask the sensitive data
oracle 11.2.0.4 |
1 |
2235 |
Tue, 19 February 2019 13:57
By: Michel Cadot  |
|
|
Using Window Function in a query Block - Count and Sum
Database - 12c |
2 |
2444 |
Tue, 19 February 2019 11:42
By: EdStevens |
|
|
Executing dynamic sql using forall
12c |
5 |
2627 |
Tue, 19 February 2019 03:23
By: John Watson |
|
|
Displaying rows as columns and grouping data
11g |
1 |
2223 |
Mon, 18 February 2019 02:31
By: Michel Cadot |
|
|
XMLType Column Comparison in Select Query
Oracle11g By: sotu100 on Thu, 14 February 2019 |
3 |
2922 |
Fri, 15 February 2019 01:06
By: Michel Cadot |
|
|
Add new columns and update to 600MB table online mode with zero downtime
Oracle 11gR2 |
5 |
3210 |
Thu, 14 February 2019 07:44
By: John Watson |
|
|
select Statement with CASE and month count
rdbms 12c |
6 |
3200 |
Tue, 12 February 2019 17:32
By: BlackSwan |
|
|
Difference between sum(decode) and count
PL/SQL |
4 |
2851 |
Tue, 12 February 2019 07:44
By: Bill B |
|
|
How to collate rows
PL/SQL |
6 |
3010 |
Tue, 12 February 2019 07:19
By: Bill B |
|
|
Tree View, Connect by Prior on 100m records
Oracle 12c, RED HAT |
7 |
4725 |
Mon, 11 February 2019 16:05
By: sureshonly@hotmail.com |
|
|
Pull out string between two words in string column
Oracle 11g |
3 |
3197 |
Sat, 09 February 2019 23:50
By: spalato76 |
|
|
Issue in dynamic sql.
Oracle 18c |
6 |
3672 |
Sat, 09 February 2019 06:37
By: Solomon Yakobson |
|
|
Need help to Schedule Job to Purge dba_audit_trails along with fga_audit_trail
Unix By: Akmmhto on Mon, 04 February 2019 |
2 |
3157 |
Tue, 05 February 2019 06:06
By: Akmmhto |
|
|
Account number selection from 10 parallel session
Oracle 11gR2 |
9 |
3830 |
Mon, 04 February 2019 10:16
By: srinivas.k2005 |
|
|
table export to excel
12c |
7 |
3165 |
Mon, 04 February 2019 10:13
By: cookiemonster |
|
|
Do I have to use ID as a PK?
General By: CatB on Mon, 28 January 2019 |
17 |
5853 |
Wed, 30 January 2019 15:23
By: Bill B |
|
|
MULTISET EXCEPT - COLLECTION
12C By: shawaj on Sat, 26 January 2019 |
13 |
5457 |
Wed, 30 January 2019 05:13
By: _jum |
|
|
Identify data based on data in other tables By: rrcr on Sun, 27 January 2019 |
14 |
5546 |
Tue, 29 January 2019 07:56
By: BlackSwan |
|
|
DataMapper - JSON -> XML - Add a colon in XML tag By: tutu10 on Mon, 28 January 2019 |
1 |
2755 |
Mon, 28 January 2019 03:27
By: _jum |
|
|
RETURNING BULK COLLECT INTO COLLECTION
12C By: shawaj on Fri, 23 November 2018 |
9 |
5825 |
Sat, 26 January 2019 12:15
By: BlackSwan |
|
|
SQL Query execute more records in WHERE CLAUSE
Oracle Database 10g, Windows XP |
3 |
3221 |
Thu, 24 January 2019 04:10
By: cookiemonster |
|
|
changing telephone format
12c |
4 |
3080 |
Thu, 24 January 2019 03:45
By: m.abdulhaq |
|
 |
How to simulate crash database?
Oracle 12c Release 2 By: petar97 on Mon, 21 January 2019 |
8 |
4577 |
Mon, 21 January 2019 12:40
By: petar97 |
|
|
ORA-01843 on a simple query
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
10 |
4282 |
Fri, 18 January 2019 10:22
By: Michel Cadot |
|
|
Why Do You Need to File a DBA and the Simplest Way of Filing It. |
4 |
3757 |
Thu, 17 January 2019 00:34
By: Michel Cadot |
|
|
DBMS_REDACT with MERGE
Oracle 12.1 |
5 |
5584 |
Wed, 16 January 2019 09:00
By: Solomon Yakobson |
|
|
Spreadsheet-like Totals and Subtotals
11.2 |
12 |
4877 |
Tue, 15 January 2019 18:29
By: Solomon Yakobson |
|
|
 Insert Statement taking more than 2 hrs for 4 million records
Oracle 11gR2 |
21 |
6586 |
Mon, 14 January 2019 03:41
By: anil_mk |
|
|
Determining a due date based on business hours
Otracle 12.1 By: TerryM on Tue, 08 January 2019 |
8 |
6859 |
Fri, 11 January 2019 11:26
By: Michel Cadot |
|
|
wm_concat to listagg By: zxx2403 on Mon, 07 January 2019 |
1 |
4016 |
Mon, 07 January 2019 23:16
By: Barbara Boehmer |
|
|
Proxy Granted But Unable to Modified a Table owned by the Proxy Account
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 |
9 |
5795 |
Mon, 07 January 2019 09:04
By: wtolentino |
|
|
What does @! mean in SQL?
Oracle 11.2.0.3 By: SmithXu on Fri, 04 January 2019 |
1 |
2926 |
Fri, 04 January 2019 20:55
By: BlackSwan |
|
|
Login table connection to another table.
Oracle 10g |
4 |
3212 |
Fri, 04 January 2019 05:43
By: Danny Freeman |
|
|
Regarding Updatable view - Please assist |
2 |
3393 |
Fri, 04 January 2019 03:53
By: cookiemonster |
|
|
filter based on extracting string
12c |
5 |
3814 |
Thu, 03 January 2019 05:59
By: Michel Cadot |
|
|
Substring and Instring in combination
11G By: ABG on Wed, 02 January 2019 |
3 |
3701 |
Thu, 03 January 2019 03:20
By: ABG |
|
|
TRIM function
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 |
4 |
5747 |
Tue, 01 January 2019 00:12
By: Barbara Boehmer |
|
|
Transactions than can be rejected, temporary tables or not?
11.1.2.10 |
8 |
4279 |
Fri, 28 December 2018 14:09
By: Michel Cadot |
|
|
How to flatten one column from multiple rows
Oracle 11.2.9.1.0 By: gunderj on Tue, 18 December 2018 |
7 |
4411 |
Thu, 27 December 2018 08:33
By: Bill B |
|
|
NVL not working in Cursor Subquery
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production |
4 |
3890 |
Mon, 24 December 2018 11:26
By: Bill B |
Search
Help
Members
Register
Login
Home
