Grace

exp ZJSM/ZJSM@ORCL file=e:\daochu.dmp tables=(GON);--GON表名字imp phg/phg@orcl file=e:\daochu.dmp tables=GON ignore=y;

drop user yfplss cascade;--登录system用户删除已存在的用户名，该用户下的所有东西都被删掉--创建表空间create tablespace yfplss loggingdatafile 'D:/app/Administrator/oradata/oral/yfplss.dbf'--存放表空间的地址size 100m--大小autoextend on --150M自动增长next 150m maxsize 10240mextent management local

1.利用system创建用户--新建用户并授权create user phgov identified by 123456;--授权grant connect, resource to phgov;grant dba to phgov;2.导入到对应的空间fromuser是导出时候的用户，touser是要导入的表空间imp phg/123456@ORCL fro...

光标在sql语句末尾，按住ctrl+enter执行；活动模板允许您在编辑器中插入典型语句及其片段。例如，键入sela并按Tab键插入select * from…;要管理模板:Ctrl+Alt+S |活动模板。Data Grip常用的快捷键总结: 管理数据库连接：Ctrl+Alt+Shift+S 文件视图窗口：Alt+2 进入一个文件：Ctrl+Shift...

关闭会话select sess.sid,sess.serial#,lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_modefrom v$locked_object lo, dba_objects ao, v$session sesswhere ao.object_id = lo.object_idand l...

insertwhen (not exists (select 1 from users where id = '123')) theninto users(id) select '123' from dual;当id为123存在就不会再存入数据锁的概述一.为什么要引入锁多个用户同时对数据库的并发操作时会带来以下数据不一致的问题:丢失更新A,B两个用户读同一数据...

select dbms_metadata.get_ddl('TABLE','COMMUNITY') from dual;COMMUNITY为表名必须大写

<!--批量插入--><insert id="insertMultiCars" parameterClass="java.util.List"> insert into car( id, carnumber, brand, purchasedate, state, orgid, orgcode, ph...

https://wenku.baidu.com/view/2fb8f865580216fc700afd9c.html

添加一列：alter table carapplication add (pay NUMBER(8,2));comment on column carapplication.pay is '花费';commit;创建序列： CREATE SEQUENCE  "SYSTEM"."S_CAR"  MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START W...

1/首先  Ctrl+A  全选需要格式的sql2、然后  Ctrl+F7 即可格式化

https://blog.youkuaiyun.com/com_ma/article/details/66472574?utm_source=itdadao&utm_medium=referral

ORA-01745: invalid host/bind variable name：少了逗号，#号，用了关键字等都有可能 ORA-01830: date format picture ends before converting entire input string常会出现在用to_date这个函数去转化datestamp类型，会出错ORA-00904: "CL"."JSSJ": invali...