Re: Oracle 9i on Windows Server 2003 64 bit

aaa_at_bbb.com wrote:

>Thank you all for your assistance. It was very much appreciated.
>
>Now that I know I can use SQL Plus, can I ask this?: Is it possible to
>run a script from within SQL Plus (ie. containing a series of create
>and grant etc. statements), or is my only option to enter each
>statement, one at a time? This would be very tedious for a large
>database.
>
>Thanks,
>Dave
>
>

Please do yourself a favor and take a class. You are asking questions I address in the first couple of hours of my begining class. And we certainly can't teach you Oracle here in a usenet group.

Try this:

CREATE TABLE test (
mycolumn VARCHAR2(20));

The following is the script:

BEGIN
   INSERT INTO test VALUES ('ABC');

   INSERT INTO test
   SELECT 'DEF' FROM dual;

   UPDATE test
   SET mycolumn = LOWER(mycolumn);

   DELETE FROM test
   WHERE mycolumn LIKE '%e%';

   COMMIT;
END;
/

And more questions?

Now please sign up for that class.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)