CODEWITHSUNDEEP
oracle-database
Learner
Learner

Reputation: 21425

What is the meaning of @ symbol in SQL*Plus script?

I am going through SQL*Plus script and came across set of lines that has below lines:

@test_data/EMPLOYEE.dat
@test_data/ADDRESS.dat

The .dat has some SQL code inside them. I tried to search in internet what the @ symbole indicates but I did not get any results. I am new to SQL*Plus, please let me know what this symbol indicates.

Upvotes: 0

Views: 1984

Answers (3)

Ritz
Ritz

Reputation: 1

It is used to run the scripts from another file. eg: 

SQL> @PreImport.sql

Upvotes: 0

Rahul Tripathi
Rahul Tripathi

Reputation: 172578

@ is used to call scripts from the external files

From the Oracle docs:

Runs the SQL*Plus statements in the specified script. The script can be called from the local file system or from a web server. The @ command functions similarly to @@ and START.

Upvotes: 1

neshkeev
neshkeev

Reputation: 6476

This is about sql*plus scripting, we use this symbol to call scripts from external files.

Upvotes: 7

Related Questions