在服务端导入数据时,不小心退出了CMD,如何停止数据的导入
impdp 用户名(ykt/ykt) attach= SYS_IMPORT_TABLE_01回车
stop_job=immediate回车
drop tablespace GJCARD 删除表
drop tablespace GJCARD including contents and datafiles;
drop tablespace GJCARD including contents and datafiles csacade constraints;
在紫色软件中操作数据时,SQL语句为
select BUSID,LINEID,TRADEDATETIME,BUSNAME,STATIONNAME,STATIONID from CARDINFO where LINEID=612 or LINEID=622;
select BUSID,LINEID,TRADEDATETIME,BUSNAME,STATIONNAME,STATIONID from CARDINFO;
select BUSID,LINEID,TRADEDATETIME,BUSNAME,STATIONNAME,STATIONID from CARDINFO_11 where LINEID=43;
select BUSID,
LINEID,TRADEDATETIME,BUSNAME,STATIONNAME,STATIONID from CARDINFO_11 where TRADEDATETIME=‘2019/10/11’ AND LINEID=43;