Ask Ershad : May I Help Your Administration(Oracle+MSSQL Server+MySQL) ?

Hi Ershad Here,A DBA by profession.Working with Oracle,MSSQL Server & MySQl on WIN/LIN/SUN platform. Mail your questions and advice at askershad@gmail.com. Comments and advice are highly appreciable. [PLEASE Do TEST before you actually DO!!!]

Monday, April 19, 2010

DIFF utility: Find Differences Between Files

Working as a DBA , you may encounter situations like to compare two files to check whether the contents are same or not. diff will surely ma...

Reference to vi editor

hi, Can check a somewhat huge reference for vi editor. Very much helps to DBA guys. $ vi filename Some Helpful vi Command-Line Startup Optio...

Sunday, April 18, 2010

Select the LAST N rows from a table in Oracle

From Oracle 9i onwards, the RANK() and DENSE_RANK() functions can be used to determine the LAST N or BOTTOM N rows. Examples: Get the bottom...

Select the TOP N rows from a table in Oracle

Below is the examples to find the top 5 employees based on their salary. Option 1: Using RANK() SELECT employee_name, salary FROM ( SELECT e...

Controlling the Autotrace Report in sql*plus

In sql*plus with AUTOTRACE command you can see the execution plan of successful SQL DML (that is, SELECT, DELETE, UPDATE and INSERT) stateme...

View web version

Powered by Blogger.