| Other SQL PLSQL Interview Questions |
|| Asked @
|What is pragma exception and how, when, where us
|How to create a view on a table which does not exists
|how to achieve this problem?i am having table with two
colums like empno,gender.
in gender column, i am having records male,female like that
.my final output will be
|Suppose I have to create a view on a table, that is not yet been
created by DBA. I khow the table structure. Is it possible to
create the view before DBA creates this table? If yes then how?
Is it possible to create synonym in this way?
|HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM
|In testing where do we use sql language and how it helps in
|What are % TYPE and % ROWTYPE ? What are the advantages of
using these over datatypes?
|Can you have multiple SPs with the same name on a database?
|What is dynamic SQl and how you will create and execute
|Let us suppose we have a table with structure in order
and now i want to re-organize the columns of this table to
how can i do this with queries ?
assume that table contains the data.
|What is a cursor for loop ?
|Can we interchange parameters in procedure while calling
|For more SQL PLSQL Interview Questions Click Here |