What are user defined stored procedures ?
Answer Posted / rishi anand
Stroed procedures are basically set of sql statements.User
defined stored procedures are created by users in which
they can use functions,procedures to get the desired result
from database.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is data abstraction in sql?
what is index? : Sql dba
Why triggers are used?
What is memory optimized table?
What is input buffer in sql*plus?
Can we use insert statement in function?
How do I save the results of sql query in a file?
What is a schema? How is it useful in sql servers?
Give the order of sql select?
Explain the advantages and disadvantages of stored procedure?
Which language is used in sql?
What is scope and visibility in PL/SQL?
Can we insert in sql function?
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 is the difference between an inner and outer join?