sql file in sqlplus

hello fellas, today i'm sharing my learning how to run sql file from sqlplus,
create a sql file lets suppose test.sql
and put some code like select query from a pre-defined or custom table from hr schema,

select * from country;

save and close it.
 save it anywhere on hard-drive like i've saved it directly on c drive;

open cmd connect it and enter the cmd like

@/test.sql

 simply put this @/ before the path of the sql file.
and cmd will execute

 

thank you :)

Unlock HR Schema In Oracle 10g

Hello Fellas, today i'm sharing how to unlock the HR schema which is by default unlock in Oracle Database.

just use the code in the sqlplus

• first login by system user
• then use this code.

• alter user hr identified by PASSWORD account unlock

   where PASSWORD will be your user defined password.