Run SQL Command Line
connect hr/hr --> ERROR (the password will expire within 7 days)
connect system/admin --> ERROR (invalid username/password; logon denied) WARNING (You are no longer connected to ORACLE.)
conn sys as sysdba >> Enter password: sysdba >> connected.
show user >> USER is "SYS"
alter user system identified by admin; >> User altered.
connect system/admin >> Connected
alter user hr account unlock; >> User altered.
alter user hr identified by hr; >> User altered.
connect hr/hr >> connected.
select table_name
2 from user_tables;
>> table 나옴
host
>> 위치 나옴 (ex. C:\oraclexe\app\oracle\product\11.2.0\server\BIN>)
exit
show user >> USER is "HR"
@job_grades.sql (파일이름)
>> ...Table created. Commit complete.
@sqlplus_demobld.sql
>> ...complete.
select table_name
2 from user_tables;
>> ... ~ rows selected.
