Are stored procedures faster than queries?
No Answer is Posted For this Question
Be the First to Post Answer
what is the use of double ampersand (&&) in sql queries?
What is the maximum size of sqlite database?
How can I make sql query run faster?
What is the maximum number of triggers,can apply to a single table?
Can ddl statements be used in pl/sql?
HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM
Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.
What are the modes of parameters that can be passed to a procedure ?
How many functions are there in sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
What are the two types of cursors in pl sql?
How to create an array in pl/sql?