From: "Thomas T" <T@T>
Newsgroups: comp.databases.oracle.server
References: <3c38d571.0310100136.3c478ee2@posting.google.com> <1efdad5b.0310100915.1eff238@posting.google.com>
Subject: Re: NewBie type Oracle question
Date: Fri, 10 Oct 2003 13:32:30 -0400
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 165.230.189.212
Message-ID: <3f86ed30$1@rutgers.edu>
X-Trace: rutgers.edu 1065807152 165.230.189.212 (10 Oct 2003 13:32:32 -0400)
Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!logbridge.uoregon.edu!swen.emba.uvm.edu!att541!ip.att.net!rutgers.edu!not-for-mail
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:245060

"Ryan Gaffuri" <rgaffuri@cox.net> wrote in message
news:1efdad5b.0310100915.1eff238@posting.google.com...
> waichoi@yahoo.com (Unbreakable) wrote in message
news:<3c38d571.0310100136.3c478ee2@posting.google.com>...
> > I am getting my OCP and understand that the cert is just a beginning
> > and I do need a working expereience.
> >
> > Therefore, I wish to develop a simple project for skill demostration
> > purpose.
> >
> > I would like to know the set of tools as the experience people use in
> > the market.
> >
> > My freind, who work as Junior DBA, is using the following tools.
> >
> > A.  Oracle 9i  (Of course)
> > B.  Tord     (Sql statement)
> its Toad. Not Tord. Anyone can learn to use this. dont mess with GUIs
> until you get the command line stuff. Stick with sqlplus. Any company
> that requires 'toad experience' is a company of knuckleheads anyway.
> (..snip..)

I agree.  Since you've got a friend in the business, ask him to create
something in Toad, based on Oracle's sample database schema.  Your job is to
re-create the results in straight command-line sqlplus, using only a text
editor, and commands like "desc[ribe] schema.tablename".  Ask him to come up
with the most complicated thing he can, and you must re-create it.  Once you
master SQL in that manner, a bonus exercise for you is to make address
labels come out of a laserjet printer, using a label sheet that has 3 labels
across and 10 labels down, and filling every label on the sheet.  Hint:
You'll need to use printer codes.

-Thomas