Post by Admin on Jul 19, 2020 14:25:09 GMT
hi everyone,
The store sells items such as books, videos, DVDs, and CDs. The database for the store will hold information about the customers, employees, products, and sales.
Running the SQL*Plus Script to Create the Store Schema
You perform the following steps to create the store schema, Log into the database as a user with privileges to create new users, tables, and PL/SQL packages. I run scripts in my database using the system user
SQL*Plus:
1. Start SQL*Plus and log in.
2. To execute the script file, enter start @c:\script\store_schema.sql
3. Press Enter.
SQL Developer:
1. From the menu, click File, Open, and navigate to the store_schema.sql file.
2. Click the file, and then click the Open button. You should see the script statements in the work area.
3. Click the Run Script button above the work to execute the statements. You might be prompted to select a connection
store_schema.sql (67.61 KB)
The store sells items such as books, videos, DVDs, and CDs. The database for the store will hold information about the customers, employees, products, and sales.
Running the SQL*Plus Script to Create the Store Schema
You perform the following steps to create the store schema, Log into the database as a user with privileges to create new users, tables, and PL/SQL packages. I run scripts in my database using the system user
SQL*Plus:
1. Start SQL*Plus and log in.
2. To execute the script file, enter start @c:\script\store_schema.sql
3. Press Enter.
SQL Developer:
1. From the menu, click File, Open, and navigate to the store_schema.sql file.
2. Click the file, and then click the Open button. You should see the script statements in the work area.
3. Click the Run Script button above the work to execute the statements. You might be prompted to select a connection
store_schema.sql (67.61 KB)