| Other SQL PLSQL Interview Questions |
|| Asked @
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
|What are the attributes of SQL*PLUS ?
|how can stop the sequence with mention the max value and
with out mention the max value
|mail-id table contains two columns(email_id,userid)
it contains different types of mail-ids,and no of users.
here username length is differ na,(ex-
now i want to fetch the email-ids only starting from '@'
|What will be the output of this Query?
select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
|a. Can you delete data from a View.
b. If Yes, can you delete it if there are multiple tables
c. If No, can you delete if there is single source table
which is joining.
|What is Referential Integrity?
|i want insert 10 records from table a to table b.
if i m using statement level trigger how many record insert
?in row level trigger how many record inserted???
|Difference between inline query and stored procedure?
|how to write utl file pkg in SQL
|1.when will you use week refcursor and when will you use
strong ref cursor ?
2.what is the use of sql trace..how do you use it ?
3.can you please send all the sql plus commands...like set
|For more SQL PLSQL Interview Questions Click Here |