Tag SQL
Amazon Web Services has been gaining popularity in the last few years since cloud computing has been in the spotlight.…
Oracle 19c is now available to use on Oracle Live SQL
First Install UTL_MAIL ### To install UTL_MAIL: [code language=”sql”] sqlplus sys/**** @$ORACLE_HOME/rdbms/admin/utlmail.sql @$ORACLE_HOME/rdbms/admin/prvtmail.plb [/code] ### Create a Reporting User ###…
Check for Duplicate Row using Group By function This script deletes each row in the group after the first row.…
— Get DDL from impdp — The below command will not import the dump, but will just create a .sql…
This error occurs when an expression is divided by zero. It is considered a logical error in Oracle. In mathematics,…
— Insert statements dynamically — Select ‘insert into abc values(‘||col1||’,’||col2||’,’||col3||’,’||col4||’);’ from xyz;
This is a script to query a table, generate the result in HTML and send an email using mailx for…
To select 10 random records from a table in Oracle SELECT * FROM ( SELECT * FROM TABLE_NAME ORDER BY…
SQL Query to check size of Table — Check Size in GB SELECT bytes/1024/1024/1024 FROM USER_SEGMENTS WHERE SEGMENT_NAME in (‘TABLE1′,’TABLE2’);…
SQL> conn / as sysdba Connected to an idle instance. SQL> startup mount ORACLE instance started. SQL> drop database; drop…
When a large number of records neds to be deleted from a table. If you do a normal delete it…
Flashback Technology provided by Oracle is one of the most useful in a production environment. It is a life saver.…
This error occurs when you have a public synonym defined and the object referencing or owning the synonym has been…
CAUTION !!!! DO NOT DO THIS ON YOUR PRIMARY. IF YOU DO THEN YOU WOULD REQUIRE MEDIA RECOVERY ON THE…
SELECT /*+ RULE */ GRANTEE FROM SYS.DBA_ROLE_PRIVS A WHERE GRANTED_ROLE=’DBA’ AND EXISTS (SELECT NULL FROM ALL_USERS WHERE USERNAME =A.GRANTEE);
Even when sessions are inactive they can be executing SQL’s in the background. You have to identify the SQL’s which…
Just found an amazing monitoring tool for Oracle Databases. All it needs is an Oracle client installed on your workstation.…
While creating a’ Report and Form’ Application in Oracle APEX if your using a table which has no primary key…
Original Article : http://searchoracle.techtarget.com/tip/Oracle-vs-SQL-Server-Why-Oracle-wins A brief comparison between Oracle and SQL Server. Oracle comes out leaps and bound ahead in this…
Query to check if there is any logon triggers defined for your database. Logon trigger is a trigger which fires…
Sometimes it becomes necessary to add a dummy value next to a dummy column in a report. It can be…
Error: ORA-01858: a non-numeric character found where a digit was expected Cause: You tried to enter a date value using…