Explain the difference between a procedure and a function? What do you understand by those terms?
- 1 Answers
- 1176 Views
- I also Faced
- E-Mail Answers
Answer / Manoj Kumar Ram
"Procedures and functions are SQL objects used to encapsulate code reusability in Oracle. The main difference lies in their return values: Functions return a single value, while procedures don't have a return value. Both can accept input parameters but differ in usage: Functions are typically used for calculations and validation, while procedures are used for performing tasks or operations."
| Is This Answer Correct ? | 0 Yes | 0 No |
How would you go about verifying the network name that the local_listener is currently using?
What is indexing, and how does it improve performance?
What is an Index ? How it is implemented in Oracle Database ?
What is a sub query? Describe its types?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
What is index in Oracle?
Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?
what is dynamic SGA and static SGA
Define Normalization with example?
Can you create a synonym without having a table?
what is unique key?
14 Answers Amazon, Cap Gemini, Infosys, Wipro,
sql query to get zero records from a table
Oracle General 
