NEW WITH SQL INFO TO SITES NEEDED

[FatalExceptionError]

Got an sql project to do and i don't know sql for oracle im interning so this is a learning oppertunity for (which my boss knows and this will lead to bigger projects.. hopefully)
im supposed to write a procedure to search for a persons meter info get the site location and then add it to the end of their complete address in the oracle database since 20020101(year:month:day ie jan 1 2002 so all dates greater than this) This is a run once procedure
can someone give me a link to sites in the following areas
and any additional information i may find handy

1. Place that has examples of implementing loops (especially nested loops)

2. command line reference for sql worksheet

3. reference to reserved words and commands and what their functions are

 

[jee]

The entire Oracle manual set is online at the Oracle Technology Network site. The address for 8i manuals is:

http://otn.oracle.com/docs/products/oracle8i/content.html

You have to sign up to access, but the signup is free.

You will probably be most interested in the PL/SQL User's Guide and Reference.

If you want a command line interface, I would suggest you look at SQL*Plus. The Getting Started with SQL*Plus for Windows manual documents the command line interface for Windows.

If you need plain old SQL information, check the SQL Reference.

 

[njtornado]

I just discovered this link yesterday & it's great as far as I'm concerned.

Instead of having to weed through all of the documentation for each Oracle manual this Oracle site includes a Master Index of all terms in all manuals which then links you to the manual/section which contains exactly what you're looking for.

Also it has a Master Glossary and the capability to search through all of the Oracle manuals at once!

http://tahiti.oracle.com/pls/tahiti/tahiti.homepage

You do have to create the same logon as mentioned in the previous post - but it's definately worth it!

 

[FatalExceptionError]

Thanks guys
I borrowed a co workers sql book and have been reading it.
Its easily understood but I have to be complete in reading it or i might miss something important.
I know how to declare strings now i need to know how to append one string from a database to the end of another.