asuyunlong的专栏

SELECT nvl(MAX(t.uuid),0) AS UUID from AMC_BIZ_REC t where t.uuid=11

oracle 中使用 imp和exp可以进行数据的导入和导出1.导出指定用户表空间EXP ul3/ul3@hz BUFFER=64000 FILE=E:\hz.dmp OWNER=ul32.导入指定用户表空间IMP ul3/ul3@orcl BUFFER=64000 FILE=C:\hz.DMP FROMUSER=ul3 TOUSER=ul3在使用oracle dmp文件导入时，导

UPDATE AMC_FAX_ADDRESS_LIST AFAL SET (FAX1, FAX2, TEL1, TEL2) = (SELECT BFI.LXR_FAX, BFI.JBR_FAX, BFI.LXR_TEL, BFI.JBR_TEL FROM BASE_FAXLIST_INFO BFI WHERE BFI.FAXID = AFA

DELETE FROM AMC_DEPT WHERE ID IN (SELECT ID FROM AMC_DEPT start with ID=4 connect by prior ID=PID)注意：id为菜单主键，pid为子菜单中父菜单主键。