DBA Blogs

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

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?

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...

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...

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 ...

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.

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 -----------------------------------------...

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 ...

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...

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...

In the last few years we have seen a massive growth in the mobile usage of instant messaging and chat applications. With Oracle Intelligent Bots, an integrated feature of Oracle Mobile Cloud...

We share our skills to maximize your revenue!

Context of identity and cloud access controls An intelligent Security Operations Center (SOC) needs threat intelligence and contextual awareness but, first of all, it needs to have the context of...

We share our skills to maximize your revenue!

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...

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...

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 ...

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...

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...

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?

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...

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...