Hello everyone welcome to my blog. I am just finish my training in Oracle so right now I wanted to share my knowledge and experience in Oracle with you all. I am not an expert in Oracle yet, but I am trying my best to give as simple as possible output to you all. There for please drop me an email or comment if you find any mistake.
Getting Started
After you install Oracle on your computer, it time to unlock an account in oracle. I am planning to use 2 accounts, HR and SCOTT.
Unlock account HR and SCOTT
1. login into SYSTEM account using SQL Plus
2. alter user hr identified by hr account unlock;
3. alter user scott identified by tiger account unlock;
With this syntax now you be able to use 2 accounts in Oracle. I will teach you how to create you own ID and Tablespace in another chapter.
SQL Statements
| SELECT INSERT UPDATE DELETE MERGE | Data manipulation language (DML) |
| CREATE ALTER DROP RENAME TRUNCATE COMMENT | Data definition language (DDL) |
| GRANT REVOKE | Data control language (DCL) |
| COMMIT ROLLBACK SAVEPOINT | Transaction control |
Getting Started
After you install Oracle on your computer, it time to unlock an account in oracle. I am planning to use 2 accounts, HR and SCOTT.
Unlock account HR and SCOTT
1. login into SYSTEM account using SQL Plus
2. alter user hr identified by hr account unlock;
3. alter user scott identified by tiger account unlock;
With this syntax now you be able to use 2 accounts in Oracle. I will teach you how to create you own ID and Tablespace in another chapter.