Declare cursor cl is select ename,sal,(sal*12) AS annualSAL FROM EMP; i

define a variable representing the expression used to
calculate on emps total annual remuneration.use the
variable in a statement which finds all emps who can earn
30000 a year or more.

Question Posted / venkat

5 Answers
12002 Views
I also Faced
E-Mail Answers

Answer Posted / venkat

Declare
cursor cl is select ename,sal,(sal*12) AS annualSAL FROM EMP;
i emp%rowtype;
Begin
for i in cl
loop
if i.annualSAL > 30000 then

dbms_output.put_line(i.ename);

end if;
end loop;
end;

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is meant by urlencode and urldocode? : Sql dba

1092

Which are sql * plus commands?

1043

what are set operators in sql? : Sql dba

985

Mention what is the function that is used to transfer a pl/sql table log to a database table?

934

Can we call procedure in select statement?

976

What is difference between hql and native sql?

1093

What are all the different normalizations?

972

Is postgresql a nosql database?

1079

What is the difference between sql and t sql?

966

What is a temporal table?

882

Explain the commit statement.

1103

What is int identity in sql?

1064

How can a pl sql block be executed?

891

How do you update a value in sql?

988

how to convert character strings to numeric values? : Sql dba

1026