|
|
#1 |
|
Vice Admiral
![]() ![]() ![]() ![]() |
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 |
|
|
|
|
|
#2 |
|
Lieutenant Junior Grade
![]() 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.
![]() |
|
|
|
|
|
#3 | |
|
Still Unbanned Commander
![]() ![]() ![]() ![]() ![]() |
Re: Oracle SQL help?
Quote:
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] |
|
|
|
|