SQL常用知识小结 1 查询语句2 DML (INSERT / UPDATE / DELETE / MERGE)3 DCL (GRANT / REVOKE)4 DDL (CREATE / ALTER / DROP / TRUNCATE)5 事务相关 (COMMIT / ROLLBACK / SAVEPOINT) 完整的SELECT语句:SELECT * ||view||subq
权限的传递: grant alter any table to jack;(不能授予其他人权限) grant alter any table to jack with admin option; (带上with admin option就可以在授予其他人权限) &nbs
3个默认用户: Oracle 9i sys change_on_install(网络管理员) 【as sysdba】 syst
Oracle操作语句 建立表: 创建一个简单的表 Create table test( Name varchar2(16), Age number(3), Birth date ); insert 插入:insert into emp values(8001,'java','clerk',7902,sysdate,1000,n
&n
登陆 username:scott password:tiger sqlplus/sqlplusw/desc dept;查看dept的表结构(字段)
The following are number examples for the to_char function. to_char(1210.73, '9999.9') would return '1210.7' to_char(1210.73, '9,999.99') would return '1,210.73' to_char(1210.73, '$
time2=DateDiff("n",date1,date2) '--Divided into the Hour or Minute or second strmm2=""
Copyright © 2005-2025 51CTO.COM 版权所有 京ICP证060544号