随笔分类 -  Oracle

修改oralc表中一个日期型字段的格式,如2010.09.1 改成2010-09-01
摘要：update products set products_time=substr(products_time,1,4)||'-'||substr(products_time,6,2)||'-'||substr(products_time,9,2) 阅读全文
posted @ 2010-09-01 14:23 做你所想 阅读(225) 评论(2) 推荐(0)
获取表的注释
摘要：select a.column_name,b.comments from user_tab_columns A,user_col_comments B where a.COLUMN_NAME=b.column_name and A.Table_Name = B.Table_Name and A.Table_Name='OA_FINANCE' 阅读全文
posted @ 2008-11-21 17:19 做你所想 阅读(241) 评论(0) 推荐(0)
oracle 获得某表的所有字段
摘要：1.select * from tablename 2.在PL/SQL 对该表点右键选"属性" 3.然后在弹出的页面选中字段列,copy,然后粘贴记事本整理一下就可以了 阅读全文
posted @ 2008-11-20 13:47 做你所想 阅读(256) 评论(0) 推荐(0)
Database Link的一点应用
摘要：目的:希望在beijing的数据库里可以查看到ssiss数据库oa_user_msn表. 1:首先2个数据库都是远程的,本地都能返问; 2:D:\oracle\product\10.2.0\client_3\NETWORK\ADMIN\tnsnames.ora 文件里有; BEIJING = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS... 阅读全文
posted @ 2008-10-31 17:42 做你所想 阅读(258) 评论(0) 推荐(0)
Convert.ToDateTime(drv["create_date"].ToString()).ToShortDateString()
摘要：protected void dgList_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { DataRowView drv = (DataRowView)e.Row.DataItem; if (!string.Is... 阅读全文
posted @ 2008-10-24 16:08 做你所想 阅读(394) 评论(0) 推荐(0)
TO_DATE('2007-04-02 00:00:00','YYYY-MM-DD hh24:mi:ss')
摘要：I.CREATE_DATE BETWEEN TO_DATE('2007-04-02 00:00:00','YYYY-MM-DD hh24:mi:ss') AND TO_DATE('2007-04-03 23:59:59 ','YYYY-MM-DD hh24:mi:ss') 阅读全文
posted @ 2008-10-24 16:06 做你所想 阅读(633) 评论(0) 推荐(0)