create or replace procedure job is 
The begin 
Select 
LNBTS. Lnbts_enb_name base station name 
, lncel. LNCEL_CELL_NAME village name 
, LNFDD lncel_fdd_earfcn_dl under horizontal frequency point 
, LNFDD lncel_fdd_earfcn_ul horizontal frequency points on 
The from 
C_LTE_LNCEL lncel, 
C_lte_lnbts LNBTS, 
C_lte_lncel_fdd LNFDD, 
Ctp_common_objects BTS, 
Ctp_common_objects cel, 
Ctp_common_objects FDD 
Where 
Cel. Co_parent_gid=BTS. Co_gid 
And LNBTS. Obj_gid=BTS. Co_gid 
AND lncel. Obj_gid=cel. Co_gid 
And LNFDD. Obj_gid=FDD. Co_gid 
And FDD. Co_parent_gid=cel. Co_gid 
AND lncel. Conf_id=1 
And LNBTS. Conf_id=1 
And LNFDD. Conf_id=1; 
End the job; 

CodePudding user response:

Don't know how to apply INTO great god please help have a look, and cursor loop iteration statements

CodePudding user response:

Select column1, column2 into variable1 and variable2 from table; Suggested that baidu, there are

CodePudding user response:

To do the job times this error, improve identifier error?????? .