What is the difference between View and Stored Procedure? Can views accept input parameters as stored procedure? If yes,how could I do that? I am new to database and working on MS SQL,if someone could
Latest Answer: i think view doesn't accepts any parameters. ...
Latest Answer: Yes , we can. Here is simple example. CREATE OR REPLACE PROCEDURE TEST_PROC(V_NUM OUT NUMBER) ASBEGINV_NUM := 10;END;/CREATE OR REPLACE FUNCTION TEST_FUNC RETURN NUMBER ASV_NUM NUMBER;BEGINTEST_PROC(V_NUM);RETURN V_NUM;END;/SELECT TEST_FUNC() FROM ...
Latest Answer: PRAGMA AUTONOMOUS_TRANSACTION is used to commit the transaction in the PL/SQL block which is inside another PL/SQL block which is on the verge of rolling back.To make an independent transaction within a PL/SQL block ...
Why the stored functions can not be called from DML Statements? Why cant we modify the database by function?
Latest Answer: Stored procedures are stored in data base in complied form. In dynamic sql the statements are dynamically constructed at run time. ...
Latest Answer: A ref cursor is basically a data type. A variable created based on such data type is called a cursor variable.Dynamic cursors are declared using reference cursors.Differences:1. Cusor is static in nature. Once a query is assosiated with a cursor, the ...
Latest Answer: select proc_name from user_procedures; ...
Latest Answer: A function can be called in a select statement as well as in a stroed proc. As function call would return a value we need to store return value in a variable.Ex:Assume we have a fuction .. FN_TEST(Date IN VARCHAR2, ID OUR VARCHAR2) RETURN VARCHAR2.within ...
Latest Answer: External procedures provide a mechanism for calling out to a non-database program, such as a DLL under NT or a shared library under Unix. Every session calling an external procedure will have its own extproc process started by the listener. This extproc ...
What is the difference between "IS" and "AS" while creating procedure. Ex:- create procedure IS or AS?
View page [1] 2 Next >>
Go Top
