Jquest wrote:
> Hello All,
>
> I have installed oracle 9.2 on a Win XP Pro. I have managed to create a
> schema. All I want to learn for the time being is
>
> 1 .PL SQL Commands .
> 2 . and learn to use the "Select" statement effeciently coz I would
> be using it in SAS.
>
> So can I import a database and practice querrying to glory. Is there a
> sample database in the Web or if there is some database some where I
> could do some thing .
>
> thanks
> JQ
- connect as sys
conn / as sysdba
- what schemas exist?
SELECT username
FROM dba_users
ORDER BY 1;
Are any of these present?
HR
OE
PM
SCOTT
SH
PL/SQL demos you can use to learn can be found in Morgan's Library
at www.psoug.org.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Jul 29 2006 - 12:08:43 CDT
