theUnderDog.ca

Oracle Queries

A very incomplete example of querying Oracle

-- queries

SELECT C.coID, C.coName
FROM Company C, TradeType T, Location L, Does D, WorksIn W
WHERE T.tName = 'Handyman'
AND L.lCity = 'Nanaimo'
AND D.tID = T.tID
AND D.coID = C.coID
AND W.lID = L.lID
AND W.coID = C.coID; 


SELECT C.coID, C.coName, C.coPhone, C.coAddress, L.lCity, C.coDesc
FROM Company C, Location L
WHERE C.coID = '100'
AND L.lID = C.lID;

SELECT R.rateNum, R.rateComment
FROM Rating R
WHERE R.coID = '100';

-- account queries

SELECT aID
FROM account
WHERE aEmail = 'jer_k_y@jer.com'
AND aPassword = 'jerjer';

SELECT C.coID, c.coName
FROM company C
Where C.aID = '100';