Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / anil_abbireddy
A query is written at the from clause of an another query
is called inline view.
| Is This Answer Correct ? | 49 Yes | 5 No |
Post New Answer View All Answers
What are the different types of sql commands?
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...
what is self join and what is the requirement of self join? : Sql dba
What is sql prepared statement?
What is sql and its types?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What are all the different normalizations?
Who is the owner of mysql database?
How to Declare Fixed Length String Value In PL SQL
How can a function retun more than one value in oracle with proper example?
Should I use mbr or gpt?
What are joins in sql?
What does joining a thread mean?
What is a mutating table and a constraining table?
What is pragma in pl sql?
