Sql +
- Thread starter KWAK
- Start date
LateApex
New Member
I'm not sure what you mean by the "basics".
Do you mean how to make queries?
Or, do you mean how to connect to a database?
I never buy books anymore. When I need to do something I google it up, find an example, then start coding.
I'm not sure why you have to learn it by tomorrow. If you have to learn enough to pass a test - then I think you might be out of luck. The stuff should have been studied and practiced way before hand.
Now, if you were already a programmer then I think you'd be able to learn enough to show some proficiency on a test etc...
I'm using Oracle to connect - I need the SQL to make queries. I don't know how similar it is to Access. . . . No, I don't have to take a test - I actually have to use it tomorrow to pull premiums for my job!
RPMDAD
Well-Known Member
Here is a link to an online intro to SQL which includes queries and practice sessions.
SQL Tutorial
SQL Tutorial
LateApex
New Member
I have never used access so I can't tell you how similar it is.
But, if you're just building simple queries to pull data from a database then it's pretty easy.
You use SELECT statements to build your query.
EXAMPLE:
SELECT
premium, total // this is the data you want pulled from the db
FROM
premium_table // name of the table you are pulling from
WHERE
name = Joe Blow // id into the table
If you are only going to be doing simple queries do as I suggested and google up a tutorial and go from there.
slik
New Member
I suggest taking the SQL from the Access queries and pasting them into your SQLPLUS session. You recieve errors. You should be able to track down the differenece from there.
I just converted about 40 Access queries into Oracle SQL with minimual changes.
Good Luck