MySQL is the world's most popular open source database . With its proven performance , reliability , and ease-of-use , MySQL has becom...
Read More
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Unlocking User in Oracle Database
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
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
Creating User & Dropping User using SQL DEVELOPER
STEPS 1. login into "sql developer" with user: sys role:sysdba 2. click on connection "sys" and view all objects ...
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)