Link to home
Start Free TrialLog in
Avatar of Asher00017
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 :)
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Although i don't use SQL Developer there should be a button or a menu option to "Execute Query" ...
EDIT I have seen this tutorial which states there is a "run script" and a "run statement"
1. Copy queries from Word doc to a .sql text file
2. Execute .sql file within Sql developer like

@file1.sql
ASKER CERTIFIED SOLUTION
Avatar of Wasim Akram Shaik
Wasim Akram Shaik
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Asher00017
Asher00017

ASKER

Thanks