Practical SQL Commands

1. Logging into the database

/ Nologconn Heatmeter /heatmeter@orclConn sys/ as Sysdba

2. View the database name

Select  from v$database;

3. Database Import and Export

 exp  water/ water @orcl  file  =  c:\water.dmp owner< Span style= "color: #808080;" >=   (water); Imp water  / Water @orcl  file  =  c:\waterexp.dmp Span style= "color: #0000ff;" >full  y;imp water  / Water @orcl  file  =  c:\waterexp.dmp =  ( TABALE1) full  =  y; 

4. Delete all tables for a user

Drop User Cascade;

5. Disconnect all connections from a user

Select  from where username='WATER10'; Alter kill Session'22,1'; Drop User Cascade;

6. Query 10 records of the user record

Select rownum, b.*from   (selectcount(d.client_id) CNT            from detail D         group by client_id         Order by desc where <=

Practical SQL Commands