STEPS 1. open command prompt 2. login with user: sys 3. use the sql command to unlock the HR,SH user ALTER USER username ACCOUNT UNL...
Read More
Showing posts with label SQL * Plus. Show all posts
Showing posts with label SQL * Plus. Show all posts
Creating user & Dropping user using SQL Command
STEPS:- 1. open command prompt 2. login into sqlplus with user: sqlplus sys/password as sysdba 3. create a user using sql command SY...
Read More
SELECT STATEMENT CLAUSES
There are several clauses used with select statement, they are as follows WHERE CONDITION – It will restrict rows according to the conditi...
Read More
Subscribe to:
Posts (Atom)