CODEWITHSUNDEEP
sqloracle11g
SJSL
SJSL

Reputation: 67

How to save tables, sequences etc in Oracle Database Express 11g

This is going to be a really silly question for 99% of people.

I've just started a Database paper (complete novice here) and I'm doing an assignment where I need to design a bunch of tables and add foreign keys, sequences etc.

I've managed to create all of the above in the Oracle express (11g) 'Object Browser' however I need to "provide a SQL script file to define the database schema" and I have no idea how to do that.

I thought there might be some sort of "Save as" or "export to sql script" option somewhere. Have spent the past couple of hours searching the net and trying to figure it out to no avail.

Any help would be very very much appreciated.

Upvotes: 0

Views: 4633

Answers (1)

N West
N West

Reputation: 6819

If you're learning a RDBMS, you should really write the code that builds the objects instead of using a GUI to do it for you. The CREATE TABLE command is quite straightforward, and you'll learn some of the syntax of the Data Definition Language (DDL). The GUI might do this all for you, but you won't learn much by doing it that way.

Upvotes: 1

Related Questions