|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions A program running in the database that can take complex actions based on the inputs you send it. Using a stored procedure is faster than doing the same work on a client, because the program runs right Latest Answer : Stored procedures are pre compiled SQL Statements. Stored procedures can remove the compilation overhead that is typically required in situations where software applications send inline SQL queries to a database. Stored procedures allow for business ... Latest Answer : 1. A function is used to compute a value. A porucedure is used to execute business logic.2. A functin must return a value. A procedure may not return a value or may return more than one value using out parameter.3. A function can be called from DML statements ... Read Answers (16) | Asked by : vssandilya What is the difference between "IS" and "AS" while creating procedure. Ex:- create procedure IS or AS? Read Answers (5) | Asked by : Shekhar 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 ... Read Answers (3) | Asked by : Sridhar Rao Latest Answer : Stored procedures are stored in data base in complied form. In dynamic sql the statements are dynamically constructed at run time. ... Read Answers (3) | Asked by : asd3 Why the stored functions can not be called from DML Statements? Why cant we modify the database by function? Read Answers (3) | Asked by : Appu 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 ... 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 ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
