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
- 12191 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
Can a table contain multiple primary key’s?
What is scalar data type in pl sql?
Explain polymorphism in pl/sql.
What is the difference between partition and index?
What is the usage of when clause in trigger?
What is sql injection owasp?
What is the difference between count 1 and count (*) in a sql query?
What is sql keyword?
explain access control lists. : Sql dba
What is difference between left and right outer join?
How to execute a stored procedure?
How can you know that statistics should be updated?
what does the t-sql command ident_current does? : Transact sql
what is the command used to fetch first 5 characters of the string? : Sql dba
What is nvarchar in sql?
