17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT DISTINCT NVL(LM_LICENSE.LICENSE_TYPE_ID,0),
NVL(CASE_MASTER.CASE_ID,0),
NVL(CASE_PRODUCT.PRODUCT_ID,0),
NVL(CASE_PRODUCT.SEQ_NUM,0)
FROM CASE_MASTER,
CASE_PRODUCT,
LM_PRODUCT,
LM_LIC_PRODUCTS,
LM_LICENSE
WHERE CASE_MASTER.CASE_ID = CASE_PRODUCT.CASE_ID
AND CASE_PRODUCT.PRODUCT_ID =
LM_PRODUCT.PRODUCT_ID
AND LM_PRODUCT.PRODUCT_ID =
LM_LIC_PRODUCTS.PRODUCT_ID
AND LM_LIC_PRODUCTS.LICENSE_ID =
LM_LICENSE.LICENSE_ID
AND CASE_MASTER.DELETED IS NULL
AND CASE_PRODUCT.DELETED IS NULL
AND LM_PRODUCT.DELETED IS NULL
AND LM_LIC_PRODUCTS.DELETED IS NULL
AND LM_LICENSE.DELETED IS NULL
AND LM_LICENSE.COUNTRY_ID = 107
AND CASE_MASTER.COUNTRY_ID = 107
AND CASE_PRODUCT.PROTOCOL_FOLLOWED IS NULL
AND CASE_PRODUCT.PRODUCT_ID IS NOT NULL
AND CASE_MASTER.CASE_ID = 15415412
AND CASE_PRODUCT.PRODUCT_ID =102335
AND CASE_PRODUCT.SEQ_NUM = 34129887
SELECT LM_LICENSE.TRADE_NAME, LM_LICENSE.TRADE_NAME_J
INTO V_TRADE_NAME, V_TRADE_NAME_J
FROM CASE_MASTER,
CASE_PRODUCT,
LM_PRODUCT,
LM_LIC_PRODUCTS,
LM_LICENSE
WHERE CASE_MASTER.CASE_ID = CASE_PRODUCT.CASE_ID
AND CASE_PRODUCT.PRODUCT_ID = LM_PRODUCT.PRODUCT_ID
AND LM_PRODUCT.PRODUCT_ID =
LM_LIC_PRODUCTS.PRODUCT_ID
AND LM_LIC_PRODUCTS.LICENSE_ID =
LM_LICENSE.LICENSE_ID
AND CASE_MASTER.DELETED IS NULL
AND CASE_PRODUCT.DELETED IS NULL
AND LM_PRODUCT.DELETED IS NULL
AND LM_LIC_PRODUCTS.DELETED IS NULL
AND LM_LICENSE.DELETED IS NULL
AND LM_LICENSE.COUNTRY_ID = 107
AND LM_LICENSE.LICENSE_TYPE_ID = 4
AND CASE_MASTER.COUNTRY_ID = 107
AND CASE_PRODUCT.PROTOCOL_FOLLOWED IS NULL
AND CASE_PRODUCT.PRODUCT_ID IS NOT NULL
AND CASE_MASTER.CASE_ID = ROW_REC.CASE_ID
AND CASE_PRODUCT.PRODUCT_ID = ROW_REC.PRODUCT_ID
AND CASE_PRODUCT.SEQ_NUM = ROW_REC.SEQ_NUM;
给这两个变量赋值 会报错
V_TRADE_NAME, V_TRADE_NAME_J