| Other SQL PLSQL Interview Questions |
|| Asked @
|how to create a database in oracle?please gve anser with example
|Difference between views and materialized views?
|How to get the procedure's, function's name from a package
if it is wrapped(both spec & body).
|Why you are not able to create a table using select
command,if it is having a LONG column?
for eg:create table test as select * from test1
here test1 containg a column having LONG datatype...
|What is INSTEAD OF trigger ?
|How to call the function and Procedure in trigger?
|overloading of stored procedure is possible in oracle?
|Write the order of precedence for validation of a column in
a table ?
|What is difference between CHAR and VARCHAR2?What is the
maximum SIZE allowed for each type?
|What is a database link?
|need to split a string into seperate values.
100 - 'a,b,c'
200 - 'a,x,b,d,e'
300 - 'c'
a - 2
b - 1
c - 2
|Delete duplicate records in the emp table.
|For more SQL PLSQL Interview Questions Click Here |