Query to Select the First Day and Last Day of the Current Month select trim(to_date(last_day(sysdate),’DD/MM/YYYY’)) as lastday from dual; select…
Tag sqlplus
There are scenarios where you cannot login to SQL*PLUS even with SYSDBA credentials to restart a hanged database. There is…
So you are an Oracle DBA and have got used to the luxury of BASH shell in nix systems. Where…
What to do when a production database goes hanging and there is no time left and your boss is standing…
For running a single SQL Command via sqlplus on multiple servers, we have to first do a few pre-requisites 1.…
Shell Script to generate a column seperator report in SQL*PLUS using a shell script. It can be opened in Excel…
This is a script to query a table, generate the result in HTML and send an email using mailx for…
Suppose you have a query result and want to concatenate a string to that output for better readibility, it can…
Problem —— Error on starting ASM from SQLPLUS or ASMCMD SQL> startup; ORA-01078: failure in processing system parameters ORA-29701: unable…