| Other SQL PLSQL Interview Questions |
|| Asked @
|Can we use more than one null value for unique key?
sql gurus, here is my question 4 u.
i wanna use triggers for sending reminder mail to all users
who are registered to the site. if any one knws the code plz
send me ans here : email@example.com
|how to sort records in sql?
|how to eliminate null values in a column i.e
1 2 3
NULL 3 4
1 5 NULL
i want output like this
1 2 3
i dnt want to use nvl is null and i dnt want replace the
NULL value with any value i.e nvl(col,o);
|why should required for Indexed by table in pl/sql
|I want to display the employees who have joined in last two
months. (It should be executed randomly means If I execute
the query in March it should display Jan and Feb joined
employees. Same query if i execute in Feb, 2007 it should
display dec, 2006 and jan 2007 joined employees.
|How packaged procedures and functions are called from the
|what is pragma ?
|What are the data types allowed in a table?
|What is the diff between Truncate table / delete <table
|If we declare constraints Unique and Not null on a single
column then it will act as a Primary key, so what is the use
of primary key??
|Is there any problem if we use commit repeatedly after each
dml statement in a plsq procedure ? (eg. there are 10 update
stmt and using 10 commit stmt after each update stmt)
|For more SQL PLSQL Interview Questions Click Here |