Tom Kyte

Subscribe to Tom Kyte feed Tom Kyte
These are the most recently asked questions on Ask Tom
Updated: 12 hours 42 min ago

I NEED YOU HELP WITH THIS QUERY! URGENT.

12 hours 42 min ago
Hello I need your help, i don't know how to do this, I'm noob in this field and if you can help I really really gonna be happy. Here is... Assume that the following query is taking a very long time to run. The logins table has 10M records,...
Categories: DBA Blogs

How to handle two diff types in a single column ? is there any work around ?

12 hours 42 min ago
Hi All, I need your inputs and suggestions for the below ; I have 2 column say A and B . In simple words they want to find percentage .But before that they are performing few validations In excel they had these validation before deriving t...
Categories: DBA Blogs

show a grid of deleted records

12 hours 42 min ago
Hi Tom, please i need your help ASAP !!! i have a grid of (agents) in oracle apex with the button DELETE , and i want to know the steps how to show deleted rows in another grid
Categories: DBA Blogs

Materialized view log , logminer

Fri, 2019-02-22 07:06
Hello Tom, would you explain a little which way is better to check on delta of information to populate DWh on schema? Materialized view log or LOGMNR?
Categories: DBA Blogs

Oracle 12c Performance issue after upgrading database from 10.2.0.5.0 to 12.1.0.2.0

Fri, 2019-02-22 07:06
Hello, One of our client has upgraded Test environment Oracle database from 10.2.0.5.0 to 12.1.0.2.0 with Production data. After upgrading the database, we are facing performance issue in few processes which are taking huge time to complete com...
Categories: DBA Blogs

EXP: how to include the "CREATE USER" statement without perform a full export?

Fri, 2019-02-22 07:06
Hello. I need to export an oracle schema using exp, included the "CREATE USER" statement. Now, for do that the only think to do that I know is perform a full export of the database. The problem is that in my database there are a lot of users and th...
Categories: DBA Blogs

rman question

Fri, 2019-02-22 07:06
thomas, happy holiday. I have question(s) related to rman 1. what is the difference between - to back up the current control file and to backup up control file copy(backup controlfile copy) 2. when using either of above command tag and ...
Categories: DBA Blogs

a sql code to remove all the special characters from a particular column of a table

Thu, 2019-02-21 12:46
a sql code to remove all the special characters from a particular column of a table . for example : iNPUT-ABC -D.E.F OUTPUT ABC DEF AND IF THERE IS TWO NAMES LIKE ABC PRIVATE LTD ONE SPACE SHOULD BE MAINTAINED BETWEEN 2 WORDS.
Categories: DBA Blogs

DISTINCT vs UNION

Thu, 2019-02-21 12:46
Hello Tom, my test case create table xxx as select * from dba_tables; insert into xxx select * from dba_tables; I tried 2 queries 1* select distinct * from xxx 2359 rows selected. Execution Plan -----------------------------------------...
Categories: DBA Blogs

Please help to understand how Nested Table cardinality estimation works in Oracle 12C

Wed, 2019-02-20 18:26
Hi Team, Request your help with one issue that we are facing. We pass a Nested table as a variable to a select statement. Example SQL is: <code>SELECT CAST ( MULTISET ( SELECT DEPTNBR FROM DEPT ...
Categories: DBA Blogs

Presentation of function result, which is own-type table via SELECT <func> FROM DUAL in sql developer.

Wed, 2019-02-20 18:26
Hi TOM, I've created a function, that granting access to tables and views in given schema to given user. In result, function returns a own-type table, that contains prepared statement and exception message, if thrown. 1. Creating types: <code...
Categories: DBA Blogs

With clause in distributed transactions

Wed, 2019-02-20 18:26
Hi Tom ! As there is put a restriction on GTTs: Distributed transactions are not supported for temporary tables does that mean that inline views in a query, i.e. using WITH clause, but those with MATERIALIZED hint will not work properly...
Categories: DBA Blogs

SQL Performance Tuning

Wed, 2019-02-20 00:06
Hi Team, i am kinda new to SQL performance tuning, So i need you guys to suggest me some helpful hand books (with test cases) which will suit for me. I have googled for it but don't know which one should i prefer as a newbie. So please share your...
Categories: DBA Blogs

What does argument "shares" stand for in create_plan_directive()?

Wed, 2019-02-20 00:06
Hi, In procedures create_cdb_plan_directive() or create_cdb_profile_directive() of dbms_resource_manager package, it is clear what role plays The parameter called "shares". Now, I fail to see what can be done with this parameter in create_plan_dir...
Categories: DBA Blogs

Dynamic database creation

Wed, 2019-02-20 00:06
Hello.. I'm asking if there is anyway to create an Oracle PDB database dynamically, I mean after the completion of some web registration, for example if I want to provide a complete private oracle database for my customer after he/she register to ...
Categories: DBA Blogs

How to print function name in sqlplus along with creation time.

Wed, 2019-02-20 00:06
Hi, I need advise on below query. Whenever we created any procedure/function from sqlplus command prompt then Function created message shown in sqlplus. E:g SQL> @C:\abc.fnc; Function created. 1:Can...
Categories: DBA Blogs

REGEXP_LIKE - Pattern match with complex logic

Tue, 2019-02-19 05:46
I want to do the regexpr pattern matching and I couldn't. Please help. I want to evaluate the value that is going to be inserted in DB. I want to perform a check as below. Only four special characters and alphabets are allowed. other special ch...
Categories: DBA Blogs

The relationship between null and 0

Tue, 2019-02-19 05:46
I asked you one last time and I will ask you one more question. If !=0, we know we should include null, but the result is not null. If !=0, it is different from zero and null, should not it also contain null if it is not 0?
Categories: DBA Blogs

Select from a table where a key value has matching link for all key values of another table

Tue, 2019-02-19 05:46
I have a set of three tables (T1, T2, T3) that represent dictionary data from external sources. I need to match the data from table 1 with the data in table 3 where <b><i>all</i></b> the rows in table 1 for a given OR_ID are reflected in table 3. T...
Categories: DBA Blogs

Update statement to flag rows

Tue, 2019-02-19 05:46
Hello, Ask Tom team. I'm using the query below to load rows to a destination database based on some conditions. After this is done I want to flag those rows in order to exclude them in the next SSIS ETL run. <code>select t1.invoice_sender,t1.ei...
Categories: DBA Blogs

Pages