- 博客(10)
- 资源 (8)
- 收藏
- 关注
转载 ubuntu rpm
如果安装rpm包,照下面做:1.apt-get install alienalien -i xxx.rpm 直接安装alien -d xxx.rpm 生成Debian包2.apt-get install rpmmkdir /var/lib/rpmrpm --initdbrpm -ivh xxx.rpm3.自运行:用rcconfapt-get install rcconfrcc
2012-02-26 10:26:17 366
转载 What does the SQLCODE Function do
What does the SQLCODE Function do?The SQLCODE function returns the error number associated with the most recently raised error exception. This function should only be used within the Exception Handl
2012-02-25 15:17:47 418
转载 What does the SQLERRM Function do
What does the SQLERRM Function do?The SQLERRM function returns the error message associated with the most recently raised error exception. This function should only be used within the Exception Hand
2012-02-25 15:15:56 560
转载 关于oracle的NOLOGGING
关于oracle的NOLOGGINGOracleSQL可以采用NOLOGGING模式执行以下操作:1 索引的创建和ALTER(重建)。2 表的批量INSERT(通过/*+APPEND */提示使用“直接路径插入“。或采用SQL*Loader直接路径加载)。表数据不生成redo,但是所有索引修改会生成redo,但是所有索引修改会生成redo(尽管表不生成日志,
2012-02-24 17:22:48 1654
转载 Oracle/PLSQL: Trunc Function (with dates)
Oracle/PLSQL: Trunc Function (with dates)In Oracle/PLSQL, the trunc function returns a date truncated to a specific unit of measure.The syntax for the trunc function is:trunc ( date, [ forma
2012-02-24 17:01:37 575
转载 Oracle/PLSQL: Sign Function
Oracle/PLSQL: Sign FunctionIn Oracle/PLSQL, the sign function returns a value indicating the sign of a number.The syntax for the sign function is:sign( number )number is the number to te
2012-02-24 16:57:25 613
转载 Oracle/PLSQL: Decode Function
Oracle/PLSQL: Decode FunctionIn Oracle/PLSQL, the decode function has the functionality of an IF-THEN-ELSE statement.The syntax for the decode function is:decode( expression , search , resul
2012-02-24 16:56:11 753
转载 oracle nvl( ) 函数
nvl( ) 函数示例请参阅从两个表达式返回一个非 null 值。语法NVL(eExpression1, eExpression2)参数eExpression1, eExpression2如果 eExpression1 的计算结果为 null 值,则 NVL( ) 返回 eExpression2。如果 eExpression1 的计算结果不是 n
2012-02-24 16:15:05 360
转载 oracle中substr函数的用法
oracle中substr函数的用法 In oracle/PLSQL, the substr functions allows you to extract a substring from a string.The syntax for the substr function is: substr( string, start_position, [
2012-02-24 16:09:20 506
转载 oracle grant
--select * from dba_users; 查询数据库中的所有用户 --alter user TEST_SELECT account lock; 锁住用户 --alter user TEST_SELECT account unlock; 给用户解锁 --create user xujin identified by xujin; 建立用户 --grant cr
2012-02-06 10:16:06 425
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人