Agenda:
- Getting started with Oracle SQL developer Data modeler
- How to create relational data model
- How to add Sequence Generator to a table
- Handling M:N relationships
- How to create database view
- Export the data model to DDL
- Backup the modeling project
- Create New Data Dictionary
- Getting started with Oracle SQL developer Data modeler
- How to create relational data model
- How to add Sequence Generator to a table
- Handling M:N relationships
- How to create database view
- Export the data model to DDL
- Backup the modeling project
- Create New Data Dictionary
This post will show post-action after the relational data model has been created.
The main purpose is to export the relational model as DDL, and this DDL is runnable SQL script to generate the database schema.
Besides that, it could help us to validate the correctness of data model during DDL generation.
Steps:
1. make sure relational data model has been created.
2. Open the DDL File Editor
File > Export > DDL File
3. Click Generate
4. Review DDL Generation Options: Tree View, Tables, PK and UK Constraints, Indexes, Foreign Keys, Views
5. Click OK
6. If errors alert, search for "-- Error --" and fix it.
7. Once fixed, repeat step 2-5 again.
Done!!
There are lots of information about oracle have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get to the next level in oracle. Thanks for sharing this.
ReplyDeleteOracle Training Chennai
Oracle Training Center in Chennai
Great Article Artificial Intelligence Projects
DeleteProject Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
It incorporates strong information security layers that ensure your delicate data.Change Site URL Using MySQL
ReplyDelete