-
linux下orcale基本操作指令第一步登录数据服务器:输入账号ssh 192.168.111.111 -l oracle输入密码 *********------------------------------------------------------------------------------------------------------------------------------------------------------------第二步 登录数据输入 数据库账号 sqlplus user输入 数据库密码 **********进行数据库操作------------------------------------------------------------------------------------------------------------------------------------------------------------1.查询输入 select id from table;回车键;------------------------------------------------------------------------------------------------------------------------------------------------------------2.插入输入 insert into ecp_sys_type (ID, SYS_ID, SYS_NAME, DESCRIPTION) values (162, 'iphone', 'iPhone', 'iphone');回车键;输入 :commit;------------------------------------------------------------------------------------------------------------------------------------------------------------3.修改输入:update ecp_wap_channel set id=424 where channel_id='ZZ0761';回车键;输入:commit;------------------------------------------------------------------------------------------------------------------------------------------------------------4.查询序列当前值 select SEQ_ECP_SYS_SUPPLY.nextval from dual;------------------------------------------------------------------------------------------------------------------------------------------------------------5.创建表输入:create table ECP_SYS_TYPE(ID NUMBER not null,SYS_ID VARCHAR2(32),SYS_NAME VARCHAR2(64),DESCRIPTION VARCHAR2(500));回车键;输入 :commit;------------------------------------------------------------------------------------------------------------------------------------------------------------6.创建序列输入:create sequence SEQ_ECP_WAP_LOGminvalue 1maxvalue 9999999999999999999999999999start with 600increment by 1cache 20;回车键:输入:commit;------------------------------------------------------------------------------------------------------------------------------------------------------------注意:有更新动作时候;一定要记得commit。
select table_name from user_tables;// 当前用户拥有的表
user_tables的字段包括:table_name,tablespace_name,last_analyzed
SQL> conn / as sysdba sysdba用户模式连接
SQL> startup 启动数据库
SQL> shutdown immediate 立即关闭数据库
SQL> desc dba_users; 查询dba_users表结构
SQL> select username from dba_users; 查询当前sid下的所有用户的username
SQL> select count(*) from username.tablename; 查询tablename表的行数
SQL> drop user username cascade; 删除名称为username的oracle用户
SQL> select distinct table_name from user_tab_columns; 查看当前user模式下所有表名
// end
// 以下为oracle中获取last_insert_id的自定义方法:
public static function getInsertId($sequence){
$sql = "select $sequence.nextval from dual";
$result = DB::query($sql)->execute();
return $result[0]['NEXTVAL'];
}