[Log In ] [New Posts] []
Go Back   GotApex? Forums Forums > General Topics > Software, OS, and the Internet
User Name
Password

Reply
 
Thread Tools Search this Thread Display Modes
Old 03-01-2002, 07:09 PM   #1
gwilks98
Vice Admiral
 
gwilks98's Avatar
 
Join Date: Aug 2000
Location: StL
Posts: 4,300
Send a message via AIM to gwilks98
Oracle SQL help?

can anyone recommend a good site to teach me some real basic SQL stuff. Here are just a few examples of what I have to do:

List tables in a database.
Write an SQL command that lists owners and table names of all tables in a database.
Do a multi-table join.
Use a SQL statment to count the number of records in a table.
Use SQL statement to count the number of records with a specific word in the table.
Use SQL statement to get an average of a number of records.
Use SQL statement to find a maximum in a collumn.
Do a subquery and use those results in another query...

And this is all done off of www.websql.org

The stuff I looked at on their website didn't really help me out too much.
__________________
"I know the pieces fit, cause I watched them fall away."

"Cold silence has
A tendancy to
Atrophy any
Sense of compassion."

MJK
gwilks98 is offline   Reply With Quote
Old 03-13-2002, 03:21 PM   #2
qmanchu
Lieutenant Junior Grade
 
qmanchu's Avatar
 
Join Date: May 2001
Posts: 165
Check out W3Schools SQL Tutorial as well internet.com's SQL Tutorial. The latter tutorial also provides many other links to other SQL tutorials for your needs. Hope this helps.
qmanchu is offline   Reply With Quote
Old 03-13-2002, 03:31 PM   #3
aglio412
Still Unbanned Commander
 
aglio412's Avatar
 
Join Date: May 2001
Location: Suburbia
Posts: 1,362
Send a message via ICQ to aglio412 Send a message via AIM to aglio412
Re: Oracle SQL help?

Quote:
Originally posted by gwilks98
can anyone recommend a good site to teach me some real basic SQL stuff. Here are just a few examples of what I have to do:

List tables in a database.
Write an SQL command that lists owners and table names of all tables in a database.
Do a multi-table join.
Use a SQL statment to count the number of records in a table.
Use SQL statement to count the number of records with a specific word in the table.
Use SQL statement to get an average of a number of records.
Use SQL statement to find a maximum in a collumn.
Do a subquery and use those results in another query...

And this is all done off of www.websql.org

The stuff I looked at on their website didn't really help me out too much.

send me 10 bucks and i'll do it for you

oracle's site isn't a good one for sql tutorials

here ya go!

http://perl.about.com/cs/beginningsq...s=sql+tutorial

[i'm really starting to like about.com]
aglio412 is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -7. The time now is 05:32 AM.