Database
cityseabreeze
这个作者很懒,什么都没留下…
展开
-
column types
Oracle:CHARVARCHAR2NCHARNVARCHAR2FLOATLONGNUMBERDATERAWLONG RAWBLOBCLOBNCLOBBFILEROWIDUROWIDXMLTYPEDB2:SMALLINT SMALLINT 两字节整数 -32768 to 32767INTEGER/INT INTEGER 四字节整数 -2147483648原创 2005-05-21 16:37:00 · 1001 阅读 · 0 评论 -
DB Porting
从Oracle 到DB2 http://www-128.ibm.com/developerworks/cn/db2/library/techarticles/0209sunshulong/index1.html http://www-128.ibm.com/developerworks/cn/db2/library/techarticles/0209sunshulong/index2.html原创 2005-04-29 14:43:00 · 813 阅读 · 0 评论 -
DB2 Resource
IBM developerWorks 中国:DB2http://www-128.ibm.com/developerworks/cn/db2/newto/index.htmlhttp://www-128.ibm.com/developerworks/cn/db2/zones/basics/index.htmlCompiling DB2 UDB Stored Procedures with GCC o原创 2005-04-15 09:01:00 · 646 阅读 · 0 评论 -
Oracle Data Dictionary
1. Oracle 数据库管理脚本存放位置: Unix/Linux: %Oracle_home%/rdbms/admin Windows: %Oracle_home%/rdbms/admin2. Oracle 数据库管理脚本命名规则 cat*.sql 关于目录和数据字典信息 dbms*.sql 数据库中关于包的说明 prvt*.原创 2005-04-06 10:47:00 · 922 阅读 · 0 评论 -
Bulk SQL
Bulk SQL has the ability to process multiple rows of data in a single DML statement.It improves the performace by reducing the amount of context switching between SQL and host language.原创 2005-03-29 08:26:00 · 741 阅读 · 0 评论 -
How to connect to another database using sqlplus?
Assume you already logged into an oracle database, now you want to log into another database.The following are suggestion for you: - Connect to a local oracle database: Method: connect username/pass原创 2005-03-25 09:34:00 · 732 阅读 · 0 评论 -
UPDATE tricks
UPDATE titles SET ytd_sales = t.ytd_sales + s.qty FROM titles t, sales s WHERE t.title_id = s.title_id AND s.ord_date = (SELECT MAX(sales.ord_date) FROM sales)The above sql works on sqlse原创 2005-07-21 21:05:00 · 622 阅读 · 0 评论 -
Oracle resource
SQL*Plus Users Guide and Reference: http://rfhs8012.fh-regensburg.de/~oracle/sqlplus/toc.html Oracle Documentation: http://www.oracle.com/technology/documentation/index.html (cityforest/0411061原创 2005-03-19 09:10:00 · 789 阅读 · 0 评论 -
DATA IMPORT & EXPORT
Data Import & Export 1. MySQL data export:%MYSQL_HOME%/bin> mysqldump [options] database [tables] eg. mysqldump --opt database_name > backupfile.sql data import:There are two commands for importing原创 2005-05-07 22:14:00 · 1133 阅读 · 0 评论