Showing posts with label sql file from sqlplus. Show all posts
Showing posts with label sql file from sqlplus. Show all posts

Tuesday 8 July 2014

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 :)

A Guide to Installing Oracle HR Schema on an Existing Docker Container

  Hi Reader, Today I want to share my learning on how to install Oracle HR schema on a existing docker container. Step 1: Download the verif...