Click here to Skip to main content
15,741,892 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
I have installed the plsql developer tool.But while am trying to open it as usual its asking for password,user name,data base name. But i dont know which pass word and user name i should give.
Can any one help me how can i use this tool?
What are the software i have to install other than pl/sql developer tool?
How can i connect this to the server(Local) ?
Which username and pass word i can use?
How can i create schema in database?
plz help me
Updated 15-Jan-13 1:15am
Am Gayathri 15-Jan-13 7:14am    
Can any one?

1 solution

Give it your own username and password, you must remember the password because it will be required every time you open the pl/sql developer tool. To connect it to your local server you must provide the server IP Address on the Host field, as i've always been advised to use a username relevant to whatever you doing at the time.

How can i create schema in database?

Creating tables:

create table subjects (
subject_id number not null,
subject_name varchar2(30) not null,
description varchar2(4000)

When creating Functions and procedure they must be in packages.
Hope this is helpful
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900