Asher00017
asked on
Executing Create Table statements in Oracle SQL (Very Basic question but need help)
Hi,
I have the SQL developer open. I have a separate database also created.
In word, I have written CREATE TABLE statements for 5 different tables. Now, I need to execute them and the populate them with data using INSERT statement. How do i execute these CREATE TABLE statements that i have in word doc in SQL developer ?
I am very new to oracle sql and it is my 3rd day after installing it. Please consider me as an amateur and help me out :)
I have the SQL developer open. I have a separate database also created.
In word, I have written CREATE TABLE statements for 5 different tables. Now, I need to execute them and the populate them with data using INSERT statement. How do i execute these CREATE TABLE statements that i have in word doc in SQL developer ?
I am very new to oracle sql and it is my 3rd day after installing it. Please consider me as an amateur and help me out :)
1. Copy queries from Word doc to a .sql text file
2. Execute .sql file within Sql developer like
@file1.sql
2. Execute .sql file within Sql developer like
@file1.sql
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
EDIT I have seen this tutorial which states there is a "run script" and a "run statement"