Hi All, below is my code..
set timing on
Delete PB_SURVEY_USER_IMA where Name != 'Login ID';
Delete PB_SURVEY_USER_IMA where value not like '%@%';
#Delete PB_SURVEY_USER_IMA where lower(value) like lower('%@pb.com');
Set Id = 10557,
CAN = ( Select Max( account_number)
where member_id in (
where userreg.logonid = trim(PB_SURVEY_USER_IMA.value))
Update PB_SURVEY_USER_IMA Set country_id=(Select language_id from users where users_id in (Select users_id from userreg where userreg.logonid = trim(PB_SURVEY_USER_IMA.value)));
This forum is for problems using SQL*Developer and not general SQL or PL/SQL problems.
It would be better if you opened a new thread in the forum -
Forum: SQL and PL/SQL SQL and PL/SQL