Oracle Magazine, July/August 2017
Database Application Developer and DBA BEYOND SQL 101 ORACLE MAGAZINE JULY AUGUST 2017 107 @ test_ this_ script sql begins with an @ symbol When followed by a filename this symbol acts as a SQL Plus command to execute or run the commands inside the file Alternatively you could use the keyword START as in START test_ this_ script sql Code Listing 3 The test_ this_ script sql database script contents create table employee_ subset employee_ id employee_ name create_ date as select employee_ id first_ name last_ name sysdate from employee select employee_ id employee_ name create_ date from employee_ subset order by employee_ id Code Listing 4 Error received when the SQL environment cannot find your script SQL @ test_ this_ script sql SP2 0310 unable to open file test_ this_ script sql Code Listing 5 The result of running the test_ this_ script sql database script SQL @ test_ this_ script sql
You must have JavaScript enabled to view digital editions.