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,
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
simply put this @/ before the path of the sql file.
and cmd will execute
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 :)