Getting started with PL/SQL Developer

Posted on 2005-03-01
Medium Priority
Last Modified: 2013-12-12
I am just getting started with PL/SQL Developer, and I have just loaded Oracle Personal 9i.

I have a lot of past experience with Oracle but not sure how to get the engine running.

I'm more recently familiar with with Sql Server - just open Enterprise Manager and voila !, there are your databases. Need to create a database? Click, and it's done.

So my main question is, how do I see the available databases, and how do I connect to one via Pl Sql Developer?

Are there any sample databases like Northwind or Adventure Works in Sql Server?

I remember Scott/Tiger and I found his tables via Sql Server, but still need a jump start.

Thanks !

Question by:Alaska Cowboy
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Assisted Solution

wasser earned 80 total points
ID: 13435849
Have you set up ORACLE service names for your databases using Net9 Assistant (I'm still at Oracle 8i so I use Net8 Assistant & assume there is similar for ver 9) or Net# Configuration assistant?

I'm not a DBA, just a user but I've always had to set up a Service name to see any of the Oracle DB's that I work with.

LVL 11

Assisted Solution

sujit_kumar earned 80 total points
ID: 13436824
To connect to one Database You need to built the entry in tnsnames.ora (using "Net configuration assistant" from menu). The you can see it's entry while starting PL/SQL Developer (login screen).

It can't show you the list of avaliable databases, but Yes it can show you all the entries in tnsnames.ora.

LVL 13

Accepted Solution

anand_2000v earned 140 total points
ID: 13447096
unlike the databases in SQL server here we use the concept of user/password to seperate the users. in the connection box you  should use scott and password tiger. if you have any problems in this just show us the problem and we might be able to help

Author Comment

by:Alaska Cowboy
ID: 13458669

Thank you for the tips, I got sidetracked on other issues. I will take into account your comments.

LVL 13

Expert Comment

ID: 13473456
aw shucks.....
We did not help you at all. you need not have given points for this.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question