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
- 11120 Views
- I also Faced
- E-Mail Answers
Answer Posted / kingston
i don't know
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
how to write date and time literals? : Sql dba
What is the difference between microsoft access and sql server?
What is data profiling in sql?
Do stored procedures prevent sql injection?
what is the functionality of the function htmlentities? : Sql dba
What is offset in sql query?
Differentiate between syntax and runtime errors.
Which operator is used in query for pattern matching?
What is difference between joins and union?
Is pl sql useful?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What is pl/sql table? Why it is used?
What is the mutating table and constraining table?
Why cross join is used?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
