Scribd
Upload
3 views9 pages

Starting an Offline Database in JDeveloper

To create an offline database in JDeveloper, start JDeveloper in database developer role, create a new database project or open an existing one, select the database project and choose New > Database Tier > Offline Database Objects > Offline Database, supply a name and default schema, then create offline objects like tables, views and triggers within the project to model the database without a live connection.

Uploaded by

RamReddy
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views9 pages

Starting an Offline Database in JDeveloper

To create an offline database in JDeveloper, start JDeveloper in database developer role, create a new database project or open an existing one, select the database project and choose New > Database Tier > Offline Database Objects > Offline Database, supply a name and default schema, then create offline objects like tables, views and triggers within the project to model the database without a live connection.

Uploaded by

RamReddy
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Start Jdeveloper.

1). Start Jdev and select Database developer role.

2). Create either new application or open any existing application.

Create Database Project..


3). Try to create new DB project. Either by click new icon

Or
right click on Application

4). Choose database project.

5). Supply project name and directory location and choose offline Database.

Create offline Database.


Select database project , File New

Database Tier Offline Database Objects Offline Database.

Next create offline DB.

Supply the Name, which can be user friendly.


Supply the Default Schema which must match with the underlying DB schema, for instance
SCOTT, HR, etc.

The resultant file structure looks like below .

Create Offline Objects like Table , View , Trigger etc ..

Create Offline Database table .

You might also like