Scenario:
- An sql script, create-tables.sql, for creating tables is stored in a folder on Google Drive.
- A personal computer, Macbook Pro, is connected to Google Drive through Google Drive FileStream.
- A database schema is on Oracle Always Free Cloud with ATP workload type.
Procedure:
- Make a connection to a database schema on Oracle Free Cloud from a local SQL developer.
- On the worksheet of SQL Developer, type:
@path_to_your_script_file/your_script_filename.sql
- An example of the command is:
@"/Users/YourUsername/Google Drive/My Drive/OracleApex/sql-script/create-tables.sql"
- Notes: Double quotes are required when a path contains one or more whitespaces.
- Click “Run script” icon