
2 48
SELECT * FROM EMP;
SELECT * from EMP;
Select * From Emp;
SELECT * FROM EMP;
B. :
:
Jack sal_limit private synonym
Work_city public synonym
Plant_detail public synonym
Jill sal_limit private synonym
Work_city public synonym
Plant_detail table owner
SQL .
SQL
select max(sal_cap) from sal_limit;
private synonym - sal_limit ,
select count(*0 from work_city where sdesc like 'NEW%';
public synonym - work_city
select a.sdesc,b.location from work_city a , plant_detail b where a.city_id =
b.city_id
jack private synonym plant_detail jill , .
C. SQL (bind variables)
SQL ( ), (
, )
a.
select pin , name from people where pin = :blk1.pin;
select pin , name from people where pin = :blk1.pin;
b.
select pin , name from people where pin = :blk1.ot_ind;
select pin , name from people where pin = :blk1.ov_ind;
4. ( )
ORACLE FROM , FROM
( driving table) . FROM ,
. ORACLE ,
. , (FROM ) ,
评论