From: Bruce Walker Newsgroups: comp.databases.oracle.marketplace,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools Subject: Re: Intro to Oracle:SQL & PL/SQL class -HELP Date: Sat, 10 Feb 2001 14:34:39 -0500 Organization: MindSpring Enterprises Lines: 61 Message-ID: <3A8597CF.B1265E84@mindspring.com> References: <94fjcn$2pm$1@nnrp1.deja.com> NNTP-Posting-Host: cf.45.00.26 Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Server-Date: 10 Feb 2001 19:33:34 GMT X-Mailer: Mozilla 4.7 [en] (WinNT; U) X-Accept-Language: en To: steveee_ca@my-deja.com, steveee_ca@my-deja.com I would like some input from a teacher on the subject. I am taking an Oracle class now from a large corp that specializes in teaching. The Oracle DBA is over 11 weeks, with PL/SQL taking three of those eleven weeks. The class is once a week for 8 hours. Can you adequately take a beginner from zilch to a good understanding in 24 ( 3 X 8 ) hours. The first three weeks have gone by and I feel comfortable with about HALF the material. We are using ORACLE textbooks. In my eyes, they are written poorly, not descriptive at all, and leave a student wanting ' where's the beef ' mode. I have yet to find a good tutor on the web for SQL \ PL/SQL \ SQL Plus which the first exam is based on. Could you direct me to one ?? bruce w steveee_ca@my-deja.com wrote: > Hi, > > I've taught this class many times..I'm looking at the Oracle Education > book for SQL, Chapter 9 and it refers to a lab9_1 script.It's just a > script to create a table called MY_EMPLOYEE as described in the book.. > > Her you go: > > SQL> CREATE TABLE MY_EMPLOYEE > 2 (ID NUMBER(4) PRIMARY KEY, > 3 LAST_NAME VARCHAR2(25), > 4 FIRST_NAME VARCHAR2(25), > 5 USERID VARCHAR2(8), > 6 SALARY NUMBER(9,2)); > > Have fun! > > Steve > > In article , > "Jolo" wrote: > > Has anyone here has taken the Into to Oracle SQL & PL/SQL class ? > > > > I'm doing the labs in chapter 9 on my computer and lo and behold, it > > mentions about running a script called lab9_1.sql. But I don't have it > > although I have all of the other test databases (login as scott, password = > > tiger). > > > > If anyone has that script so I can continue and finish the practices in > > chapter 9 (Manipulating Data) PLEASE E-MAIL THE SCRIPT TO ME !!! > > > > Thanks, > > > > Jon Temple > > temples@att.net > > > > > > Sent via Deja.com > http://www.deja.com/