Learning Oracle? 1

[TheInsider]

I have come to the point where I feel that I know all there is to know about Microsoft Access database development. I realize that the two DBMS's are quite different but I would like to move onto Oracle. So far I have become quite frustrated with Oracle (or my lack of understanding of Oracle). I don't know where to start - the new concepts are very foriegn to me. I want to be able to develop local databases with Oracle, just as I have been doing in Access or Visual Basic 6. Is there a book out there that will give me a good primer on Oracle database developement?
Thanks,

Rob Marriott
rob@career-connections.net

 

[Guest_imported]

I'll send you a self learning of oracle you can with it setp by step, and i hope you'll understand oracle philosphy,
its size is 14 mb, is it possible to send it with attachment to your e-mail.
Thanks

 

[TheInsider]

Hi,
Thanks! I have purchased an intro book on Oracle by the Oracle Press, which I hope will give me a bit of a primer. I would be very greatfull to have your guide/program as well - I can use all of the information that I can get. Please send it to:

rob@career-connections.net

14Mb should not be a problem, but if it is, please let me know.

Rob Marriott
rob@career-connections.net

 

[TheInsider]

Hi,
My e-mail should, but does not as of recently, allow for such large attachments. Would it be possible for you to break the file up and send it @ about 3 megs each attachment? I am also working on setting up an IDrive at

http://www.IDrive.com

Thanks,

Rob Marriott
rob@career-connections.net

 

[TheInsider]

Hi,
I have my IDrive set up now. You can easily send me the file by going to:

http://www.idrive.com

user name: cctc11
password: oracle

If it says that the account has not yet been validated (they were having technical difficulties at the time I signed up), click the "Do it later" button at the bottom of the form. Then just go to the "Drop box" folder and upload the file.
Thanks again,

Rob Marriott
rob@career-connections.net

 

[Guest_imported]

Hi. I just discovered your site. It's very interesting. I am learning Oracle8i. My question is:
I want to create a table in which I named a column "ID"
(ID varchar2 first letter must start with 'W')
How do I do that?
Thanks.

 

[THoey]

Hi Pat and Welcome to TT...

CREATE TABLE your_table_name 
(
   ID   VARCHAR2 (10)
) TABLESPACE your_table_space_name

As for setting the ID to start with a W... I am not sure how I would handle that. Probably at input time.

It's a start...


Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?

 

[MikeLacey]

You can handle the "beginning with 'W'" problem with a trigger that runs on insert or update -- it would raise an error if it did not, this would abort the operation.
Mike
michael.j.lacey@ntlworld.com

 

[THoey]

Thanks Mike. I thought there was a way, and I figured it would be at input, but couldn't think of anything. Better to say nothing then to have someone try something and ruin their database...


Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?

 

[Doylet]

I would also like to have a copy of the 14MB self learning of Oracle delivered to

http://www.xdrive.com

using 'FDoylet' as User ID and Password.

Thanks in advance!


==================
learning & sharing

http://come.to/iwn