declare
doesExists number:=0;
begin
select count(1) into doesExists from tab where tname = 'EOSS2G_GREEN_RLDEP';
if doesExists = 1
then
execute immediate 'drop table EOSS2G_GREEN_RLDEP';
--execute immediate 'create table EOSS2G_GREEN_RLDEP as select * from EOSS2G_RLDEP';
else
execute immediate 'create table EOSS2G_GREEN_RLDEP as select * from EOSS2G_RLDEP';
end if;
end;
/
The Error Message I am getting is :
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
& = - + ; < / > at in is mod remainder not rem
<> or != or ~= >= <= <> and or like like2
like4 likec between || multiset member submultiset
Position: 28, Line: 2, Column: 21
SQL: declare
doesExists number:=0
^-- error here -- ORA-06550: line 2, column 21:
I have looked into varied solutions online but still they did not help solve the issue.
Can somebody help me resolve this issue ?
Actually, this particular error is not because of Database but with the platform through which I am working on. I have to explicitly specify sql block separator in the platform in order to commit the above statements.
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
몇 마디 만하겠습니다