create table PRO_WO_FORM ( ID VARCHAR2(32) not null, AREA VARCHAR2(255), CANNCEL NUMBER(1), CANNCEL_CAUSE VARCHAR2(255), CODE VARCHAR2(255), CONTENT VARCHAR2(1010), CREATE_TIME VARCHAR2(255), DELAY VARCHAR2(255), EFFECTIVE VARCHAR2(255), HANDLE_TIME VARCHAR2(255), PRO_ID VARCHAR2(255), SCENE VARCHAR2(255), SLA VARCHAR2(255), STATE VARCHAR2(255), STREET VARCHAR2(255), SUPERVISION VARCHAR2(255), TITLE VARCHAR2(255), TYPE VARCHAR2(255), VISION_FLAG VARCHAR2(255), ZNCL_TIME VARCHAR2(255), ZNSH_TIME VARCHAR2(255), PRO_SH_ID VARCHAR2(32), SYS_ORG_ID VARCHAR2(32), SYS_USER_ID VARCHAR2(32), APP_EMOTION VARCHAR2(255), PROGRESS VARCHAR2(255), LAST_BACK_TIME VARCHAR2(255), CANNCEL_TIME VARCHAR2(255), CANNELLER VARCHAR2(32), CHECK_FORM_ID VARCHAR2(32), IS_NEED_CHECK SMALLINT, RETURN_FORM_ID VARCHAR2(32), ITEM_ID VARCHAR2(255), PJ_TYPE VARCHAR2(255), END_TIME VARCHAR2(32), ITEM_CATALOG_ID VARCHAR2(32), ITEMCATALOGID VARCHAR2(32), HANDLE_TYPE VARCHAR2(3), BACK_ORG_ID VARCHAR2(32) );
create table RETURN_FORM ( ID VARCHAR2(32) not null, R_INFO VARCHAR2(255), R_TIME VARCHAR2(255), STATE VARCHAR2(255), RETURN_USER_ID VARCHAR2(32), CONTENTMENT NUMBER(4) );
SELECT * FROM (SELECT * FROM pro_wo_form SAMPLE block(20) INNER JOIN return_form SAMPLE BLOCK(20) ON (pro_wo_form.return_form_id = return_form.id)) WHERE ROWNUM < 3; --结论sample block必须放到表的后面;表不能使用别名 |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1156389/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1156389/