Why use truncate instead of delete?
No Answer is Posted For this Question
Be the First to Post Answer
what is the cursor and use of cursor in pl/sql ?
What is record type in pl sql?
Can we enter data in a table in design view?
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 does fetching a cursor do?
What are pl sql data types?
Is coalesce faster than isnull?
What is union and union all keyword in sql?
Are left and right joins the same?
What are the types of index in sql?
Why do we use procedures?
How can a function retun more than one value in oracle with proper example?