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.
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 rtm in testing?
How does a covering index work?
What are properties of the transaction?
What is a composite primary key?
what is foreign key? : Sql dba
When do we use triggers?
What are all types of user defined functions?
what are different types of collation sensitivity? : Sql dba
how to include numeric values in sql statements? : Sql dba
Explain lock escalation? : Transact sql
What does truncate mean in sql?
how to select unique records from a table? : Sql dba
How will you distinguish a global variable with a local variable in pl/sql?
Name some usages of database trigger?
what is the difference between where clause and having clause? : Sql dba