Ӧ
COMPUTER APPLICATIONS
1999 19 6 Vol.19 No.6 1999



Microsoft AccessOracleܱȽ
ӡ
ժҪMicrosoft Access΢ûϲĹϵݿϵͳOracleҪʹڴͼϣOracle Developer/2000ƳOracleҲʼ΢ͨԶݿϵṹݻݹݰȫԡǰû桢ϵͳЧʵȷıȽϣֹϵݿϵͳ΢еȱ㡣
ؼʡAccessOracleDeveloper/2000RDBMSSQL
1
Access ĿǰȽеһֹϵݿݿһAccessӦóռʹ洢ݣʹܺ׵öַʽɸѡ͸ݡңͨʾĻϵı鿴AccessݣҲڴӡıпǡΪMicrosoft Office Professionalһ֣Access ䷽ݵصWordExcelһ΢ϵõ˹㷺Ӧá
OracleĿǰедģϵݿϵͳΪһ͵ķֲʽݿƷOracle ṩֲκͳ͸ԵĹܣڸʽ칹ϵͳ൱̶ӲϵͳĶԡOracleʼ΢Oracleǿܼûٶ׼ȷؽݼҲǿı֤ݵԺһԼάݵİȫOracleṩĵĴԿߣ߿ٵĽһӦá
Ϊ˾ĲƷOracleAccessиԵƺȱ㣬ԶһۺϵıȽϡ
2ݿϵṹıȽ
Oracleһ͵ķֲʽݿϵͳϵͳÿͻ/ϵṹ绷УÿһжûӲƽ̨ԳΪҲԳΪվϵݿû˵һ߼ϵĵһݿ壬һԡԼȫԶǶһ߼ϵĵݿпƵġԹݵĴȡйݿϵͳĴɿͻɡOracleֲʽݿϵͳṹͼ1ʾOracleݿԵġǰˡ롰ˡ֮֡ݱTablesڱеԼΪˡݿԱͳһйǰˡ߹ӦóͨݿӣConnectݡˡݡOracleġǰˡ͡ˡнϴĶԡ

ͼ1Oracleֲʽݿϵṹ
OracleṩһĿͻ/ϵṹDBMSSQL*NET㣬ֲϵͳֵ֧ͨЭϣΪOracle RDBMSṩֲʽʵֵ£ѯ
OracleͬAccess߾ûӿʹһ洢ݿصĶ󶼴洢ڴϵһļСûԺɵعʹԼݼصĶȻӿڱʹõAccessݿĹ۵ԵŵܿʵһݳԱͬһļеĻº޸Щ͸鷳ˡΪ˿˷ȱ㣬ḻĿԱݳԱֱ洢ͬļУȻʹAccessṩӼʹݳԱֳɡǰˡ͡ˡ
3ݻıȽ
AccessṩַȡⲿԴӺ͵롣ͨAccessӺ͵빦ܣԽDbaseFoxProParadoxLotusExcelݿԼHtmlļıļӻΪAccessõݿ⡣AccessԶʵݿAccessݿתļԲûҪͨODBCԴҪݿļAccessпVBʵֶODBCı̡
OracleԶʵݿĻûṩĿſͻOpen Client AdapterͨODBCʵܡĿǰOracle֧Microsoft SQL ServerMicrosoft AccessRdbȼODBCԴOracleʵݿĻ滹һľԡ
4ݹıȽ
κιϵݿϵͳRDBMSҪܶǼʾ洢ϢOracleͨʹSQLSELECTʵһܡSQLSELECT6Ӿ䣬ͨǿԺܼ򵥵ؽһеʾҲʵ漰ҪݱݽмĸӲѯ˲ѯ⣬OracleͨSQL򵥵ʵݵĲ롢¡ɾȲ⣬Oracle ṩ˴ĺͨЩʵһݱTable֮ݲ
OracleṩԶݿдȡSQLPL/SQLSQLһֱ׼ĽṹѯԣOracleͨʵݿļԡOracleṩSQL*PlusִSQLûȿִһһSQLҲԱдһSQLݡPL/SQLģʽĹ̻SQL߱SQLûеĹ̻Էŵ㣬аģ黯ṹʹöʶù̻Կƽṹгơ߲ܵȡSQLPL/SQLִʾͼͼ2ͼ3

ͼ2SQLִ

ͼ3PL/SQLִ
OracleͬAccessһ㲻֧ûֱдSQLݡAccessͻصṩ˴ݿ򵼣WizardʹûԿٵؿʺԼݿԭͣ˿ڡAccessDatabaseṩ˲ѯQueries壨FormsReportsǩߣûݺ͹ݡAccessҲ߱ǿݹܡΪ˷ûAccessṩ˽ݱTableѯûƵȵĴ򵼣Wizard
AccessпͨVBݡָһļϣÿʵضĹܣĳӡĳʹĳЩͨԶɡ磬ĳ꣬ûĳťʱиú꣬ԴӡĳAccessѾṩ˽50깩ûʹãûԼдʵĲDatabaseڵģ飨ModuleǩУûԱԼVB ΡЩοʵָӵݲݹܡûͨϵVBؼЩΡ
5ݰȫԵıȽ
ݿⰲȫָݿԷֹϷʹãҪþǱݿеݣݱй¶ʧԼƻԵظı䡣
Microsoft Access ṩݿⰲȫִͳΪ򿪵ݿ룬ûȫûʻݿһ֡⣬ɽݿⱣΪ MDE ļɾݿпɱ༭ Visual Basic ԷֹԴ塢ģƽ޸ġ
Ϊ򿪵ݿһ򵥵ķֻмȷûſԴݿ⡣Microsoft Access мܣֱӲ鿴ݿļ޷õģǱȽϰȫġ
Ϊ򿪵ݿȱϵͳֻڴݿʱ룬ݿ֮ݿежûǿõġңҪݿ⣬ʹݿ롣룬Ƶݿ⽫ͬ
Accessݿⰲȫ㷺ķûȫְȫںܶʹõķҪû Microsoft Access ʱȷԼݲ롣ڹϢļУûʶΪĳԱMicrosoft Access ṩĬϵ飺ԱΪԱ飩ûΪû飩Ҳɶ顣
AccessݿԱΪûȨޣ涨ʹݿеĶ磬ûĳԱԲ鿴޸ġ˿͡еݣܸıơֻ鿴ݵıܷʡʡԱĳԱݿеж󶼾ȫȨޡҪøϸµĿƣԴԼʺţΪָʵȨޣȻûӵС
AccessȻṩ˺ܶలȫԴʩİȫҪûAccessĬϵݿȨǶκûŵġOracleṩAccessƵAccessǿöİȫơOracleǰ˵ĶΪİȫṩõĻϵͳʵְȫԹʱ´ʩ֤ͨݿûͿֹOracleûעᵽOracleݿ⣬ݿдȡڸ費ͬûͬȨޣûݿݵȨ۸費ͬûݿʵĴȡȨޣṩݿʵȡƻƣʹûԼݿݵĴȡϵͳʹʹͼʵʩȫԿơ
OracleݿԱDBAԸݿķʺݿʵĴȡȨݿԱԽûԴммȨOracle7ȫ֧ANSI/ISO׼ԼԽԼдݱУñ̾ͿʵʩʵԺԹOracle͸׶ύƣԱֲ֤ԣೡֻҪñ׼SQL COMMITʾ־ͿύOracleԶͽйϣȷгһͬύһͬʹOracle7Խ͸ظƵ㣬Oracle7ԶˢֻΪգ
6ǰûıȽ
ΪMicrosoftһȭͷƷAccessṩʮַû档һAccessӦóǿԼDatabaseǩֱΪTablesѯQueries壨FormsReports꣨Macrosͳģ飨ModulesAccessṩ߹ʹݵֹߡ
AccessWindowsϵͳͬMicrosoft˾AccessƷOracleƷơAccessָ֧VBؼWindowsϵͳ˺ܺõνӡAccessṩ˴ģƹܣá
Developer/2000Oracleṩǰ˿ߡͨһߣûʹķͼûӦóOracleṩSQL*FormsʹûԿִлڱFormӦóOracleSQL*ReportsһǿıɸֱSQL*LoaderɸݼOracleOracle Developer/2000ƹпõƹ߽١ȻͨVBXؼ乤䣬޽ϴ󡣲ңOracle Developer/2000Խϲ˵Oracle Developer/2000AccessҪѷһ
7ЧʵıȽ
AccessݵĲǽSQLɵģSQLнϸߵִЧʡǣAccessǽVBʵӦó򣬶VBһֽԣԴ˵Чʵֻͣ΢ϵСݿ
Oracle֧SQLPL/SQLԣнϸߵٶȡOracleӵ7濪ʼ˶ϵṹӲϵṹΪûṩĸܡOracleЭĶϵṹݵǰɣ̬ݿ̵ĸSQLûִͬһSQLʱڴеһʹڴռôﵽС̬SQL̬SQLԼ洢̿ΪûʹϵͳڴռôﵽСOracle7ṩڳɱܲѯŻϵͳݱеͳϢЧĴȡ·Oracle7Чȡ·Ͳԣ֤˶ӵĲѯҲмѵĲѯܡ
8
ͨϱȽǿԷ֣Accessʹ㣬Чʽϵͣ΢ϿСݿ⣻OracleǿЧʽϸߣȫԽϺãͼûƲ㣬ʺдģݿ⡣ 
߼飺ӡڡ缼ֲʽݿϵͳо
ɡʦ
ߵλйҵѧѧ뼼ϵ.ݣ221008
ո:1999-03-16(޸ĸ)
