In case you want to search a string or any other number in all tables inside a schema. Then there…
Tag Tables
Do a “create table” as command without selecting any rows create table abc_new as select * from abc where 1=0;
Flashback Technology provided by Oracle is one of the most useful in a production environment. It is a life saver.…
The final answer to the age old debate of count(*) vs count(1).Absolute proof that count(*) is faster than count(1). sql->alter…
Oracle Database philosophy is Data Recover-ability. This is the reason if you have a huge table with more than 100…