RE: SQL knowledge

I would say start with SQL but not too long unless you need to learn how to
produce formatted report-like output using SQL. You just need to learn the
basic SQL to access the database, ie, select,insert,delete,update, create,
grant, how to do joins, etc. It's PL/SQL that you will need most to write
programs that look just like traditional 3GL modules. Thru PL/SQL you can
use SQL statements, manipulate data thru cursors, apply object-oriented
programming. PL/SQL provides a mechanism to trap thru exception handlers any
processing errors. You will need PL/SQL to create database procedures
,triggers and functions. 

Anyway, start with SQL and progress to PL/SQL since PL/SQL is used both in
the database (stored procedures and triggers   and in application codes
(forms,reports, etc).

-----Original Message-----
From: Edwin Davidson [mailto:[email protected]]
Sent: Monday, November 25, 2002 12:30 PM
To: Oracle
Subject: [oracle] SQL knowledge


If you were just starting to learn Oracle, would you jump right into
PL/SQL or would you take the time first to properly learn SQL then go onto
PL/SQL ? 

Thank you.
Edwin


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to %%email.unsub%%.


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].