Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Where to begin? 1

Status
Not open for further replies.

mancroft

Programmer
Oct 26, 2002
267
GB
I am looking for a decent beginner's tutorial about Oracle.

Just basic stuff... how to put data in and how to get it out.

Could you point me in the right direction, please?

Thanks.
 
Mancroft,

At Amazon.com, I searched for "Oracle for Beginners" and found a couple of titles; "Oracle for Dummies" turned up a title, (plus one for PL/SQL, but don't go there yet.) They certainly look adequate.

If, however, you have access to Oracle, and you can have someone help you log into SQL*Plus (Oracle's Beginners' Text-based, command-line interface), into an Oracle account that has at least "CREATE TABLE..." privileges, then you can get started doing what you requested ("...how to put data in and how to get it out..."):
Code:
CREATE TABLE MANCROFT
   (ID        number
   ,LastName  varchar2(15)
   ,FirstName varchar2(15)
   ,Phone     varchar2(15)
   );

Table created.

INSERT INTO MANCROFT VALUES (1,'Hunt','Dave','801-733-5333');
INSERT INTO MANCROFT VALUES (5,'Doe','John','212-555-1212');

select * from mancroft;

        ID LASTNAME        FIRSTNAME       PHONE
---------- --------------- --------------- ---------------
         1 Hunt            Dave            801-733-5333
         5 Doe             John            212-555-1212
That should, at least, get you started. Let us know how things progress.

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[ Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top