ITPub博客

copy from http://www.myoracleguide.com/xl/REFERENTIAL_INTEGRITY_and_LOCKING.htm[@more@]This bulletin explains what referential integrity means andhow locking takes place with tables joined by the referential integrityrule. In addition, this bulletin explains how inserting/updating/deleting onetable can cause another table to get locked.REFERENTIAL INTEGRITY: is a rule defined on a column (or set of columns) in onetable that allows the insert or update of a row only if the value for the columnor

How to export Access tables to Oracle[@more@]Install an Oracle ODBC driver How to create a data source based on a machine with an Oracle database Select Export from the File menu Make sure that the export will go to an external database Choose ODBC as the file type and select the datasource The biggest problems are (going from Access to Oracle): Hidden ColumnsMake sure you unhide all columns, they may cause problems Names mixed case names- these go over to mixed case names in Oracle

终于开通了博客，纪念一下。[@more@]终于开通了博客，纪念一下。