费费笔记

摘要: 来不及写，这里有好文：http://msdn.microsoft.com/en-us/library/ch2aw0w6.aspx阅读全文

摘要: I don't think many of u haveexperience withDataTable.Load or DataTable.Merge, so here I take time to write it down for future check and records.The MSDN document has a good sample and explanation about Load method: http://msdn.microsoft.com/en-us/library/4e06d41f.aspxToo long for a lazy man to read,阅读全文

摘要: To insert a date/time value into the Oracle table, you'll need to use the to_date function. The to_date function allows you to define the format of the date/time value.For example, we could insert the '3-may-03 21:02:44' value as follows:insert into table_name(date_field)values(to_date('2003/05/03 2阅读全文

摘要: 修改数据库字符集为：ZHS16GBK查看服务器端字符集SQL > select * from V$NLS_PARAMETERS修改：$sqlplus /nologSQL>conn / as sysdba;若此时数据库服务器已启动，则先执行 SHUTDOWN IMMEDIATE 命令关闭数据库服务器，然后执行以下命令:SQL>shutdown immediate;SQL>STARTUP MOUNT;SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;SQL>ALTER SYST阅读全文

摘要: oracle分页查询的时候，不能使用limit，所以只能这样 1. select * from table_name where rownum>begin and rownum< end 2.sql = "select * from table" con.prepareCall("SELECT * FROM(SELECT A.*, rownum r FROM("+sql+") A WHERE rownum <= "+intPage*intPageSize+") B WHERE r > "+(阅读全文

摘要: Oracle 数据类型数据类型参数描述char(n)n=1 to 2000字节定长字符串，n字节长，如果不指定长度，缺省为1个字节长（一个汉字为2字节）varchar2(n)n=1 to 4000字节可变长的字符串，具体定义时指明最大长度n，这种数据类型可以放数字、字母以及ASCII码字符集(或者EBCDIC等数据库系统接受的字符集标准)中的所有符号。如果数据长度没有达到最大值n，Oracle 8i会根据数据大小自动调节字段长度，如果你的数据前后有空格，Oracle 8i会自动将其删去。VARCHAR2是最常用的数据类型。可做索引的最大长度3209。number(m,n)m=1 to 38 n阅读全文

摘要: [代码]阅读全文