05 2017 档案

摘要:变量转换 1 2 3 4 5 6 7 var myVar = "3.14159", str = ""+ myVar,// to string int = ~~myVar, // to integer float = 1*myVar, // to float bool = !!myVar, /* to 阅读全文
posted @ 2017-05-27 11:43 kdy 阅读(252) 评论(0) 推荐(0)
摘要:导入: 例:impdp hqoacp/hqoacp@192.168.5.13:1521/oracle DIRECTORY=DATA_PUMP_DIR DUMPFILE=hqoacp20150415.dmp LOGFILE=hqoacp0415.log REMAP_SCHEMA=hqoacp:hqoa 阅读全文
posted @ 2017-05-24 11:45 kdy 阅读(367) 评论(0) 推荐(0)
摘要:Oracle查询用户下的所有表 select * from all_tab_comments – 查询所有用户的表,视图等 select * from user_tab_comments – 查询本用户的表,视图等 select * from all_col_comments –查询所有用户的表的列 阅读全文
posted @ 2017-05-24 11:34 kdy 阅读(777) 评论(0) 推荐(0)