Re: NewBie type Oracle question

"Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message news:1efdad5b.0310100915.1eff238_at_posting.google.com...
> waichoi_at_yahoo.com (Unbreakable) wrote in message
news:<3c38d571.0310100136.3c478ee2_at_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 Received on Fri Oct 10 2003 - 12:32:30 CDT