Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 5 Answers
- 12271 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
What is record data type?
Explain the difference between triggers and constraints?
where are cookies actually stored on the hard disk? : Sql dba
What is a constraint?
Does sql backup shrink transaction log?
What is sqlite format?
What does sql stand for?
Is mariadb nosql?
what tools available for managing mysql server? : Sql dba
What's the procedure?
Is grant a ddl statement?
What is a table?
What is the most restrictive isolation level? : Transact sql
What is normalization sql?
does sql support programming? : Sql dba
