Tuesday 1 July 2008

How do I execute a SQL file using SQL*Plus?

To execute a *.sql file using Oracles' SQL*Plus command utility you must follow these steps:
  • Start SQL*Plus
  • Type in connection information and connect
  • At the prompt type @{file} for example:
  • @MyFile.sql or
  • @oracle/scripts/MyFile.sql

Reference Link: http://www.techonthenet.com/oracle/questions/script.php

No comments: