PL SQL interview questions and answers

#pl #sql #interview #questions

[shindednyaneshwar]

Need questions for experienced it's seems for fresher level

[vishnuvardhanjadava]

Hi,
I really appreciate your efforts in making this video.

I have noticed one small mistake in the %type question's answer.

it was mentioned as 'dcode := dept.detpnum%type;', which is wrong.

is should be 'dcode dept.detpnum%type;'
and If we want to initialise a value to 'dcode' then we can use
'dcode dept.detpnum%type:='123';'

it maybe a typo in your code. pls correct it. cheers!