Answer Posted / sapna kalburgi
Stored procedure is a set of SQL statements used to perform
some particular task.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use subqueries with the in operator using oracle?
What is the difference between hot backup and cold backup in oracle?
Why do you use stored procedures and state some of its disadvantages?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
State and explain the different types of data models?
How to define an anonymous procedure with variables?
How to assign values to data fields in record variables?
How is it different from a normal table?
How to sort output in descending order in oracle?
what is normalisation?what are its uses?
Explain index?
How to start an oracle instance?
What is raw datatype?
Why do we need integrity constraints in a database?
What is the difference between translate and replace in oracle?