1.Difference between procedure and function? 2.What is IN/OUT parameter? 3.Can functions return tables? 4.What is RETURN used for? 5.How to cal stored procedures? 6.What is the benefit of stored ...

for this task i have created a a function named square_num takes an integer and returns its square. and then defined stored procedure which accepts an input number and outputs the squared values using ...