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: View - A View in simple terms is a subset of a table. It can be used to retrieve data from the tables, Insert, Update or Delete from the tables. The Results of using View are not permanently stored in the database. Stored Procedure - A stored ...
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: sp_helptext procname will tell you if the procedure is existed or not as it will show you the whole syntax of that procedure. ...
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
