Home >
Programmer2Programmer.NET Forum>
IT Interview Question Answer Discussion >> Oracle D2k Form / Report and PL/SQL interview question with answers...
NOTE : Log In required to post Replies for this discussion.
|
Oracle D2k Form / Report and PL/SQL interview question with answers
|
|
AtanuMaity
|
Posted: Wednesday 27, August 2014 09:19:11 AM
|
|
|
What is difference between SUBSTR and INSTR?
-substr gives the substring of the position we gives where asin
str gives the the character present in the particular position
How do I find duplicate values in a table in Oracle?
-
select column_name, count(column_name)
from table
group by column_name
having count (column_name) > 1;
What is the difference between LOv and list item . Why use one
on another?
--use list items for less than 20 different values. For more th
e list of values is recommended, because you can filter in it.
Another difference is, when you use a list item - and you fill
it dynamically using select statements, the first select part i
s shown, and the second is used: both columns (they may be conc
atinated) are character columns. With LOVs you are more flexibl
e with the number of columns you want to show and where you wan
t to paste the values to.
Difference between pre-query & post-query
--Pre-query trigger fires only ones while post-query trigger fi
res each time.the Post-Query trigger fires each time Form Build
er fetches a record into a block.RegardsPawan Ahuja
How many different triggers are available in Report?
-There are five types of triggers in report 6i
1) Before report trigger
2) After report trigger
3) Before Parameter trigger
4) After parameter trigger
5) Between pages trigger
What are different types of column in reports?
There are three types of columns in the report -6i these are:
1) Placeholder Column – Placeholder column is used to store a v
alue for a variable.
2) Formula Column
3) Summary Column
What is the difference between UNION and UNION ALL?
-UNION removes duplicate records (where all columns in the resu
lts are the same), UNION ALL does not.
What is an Exception ? What are types of Exception ?
Exception is the error handling part of PL/SQL block. T
he types are Predefined and user defined. Some of Predefined ex
ceptions are. CURSOR_ALREADY_OPEN DUP_VAL_ON_INDEX
NO_DATA_FOUND TOO_MANY_ROWS INVALID_CURSOR INVALID
_NUMBER LOGON_DENIED NOT_LOGGED_ON PROGRAM-ERROR
STORAGE_ERROR TIMEOUT_ON_RESOURCE VALUE_ERROR ZER
O_DIVIDE OTHERS.
|
|
Back to Top
^ |
|
| AtanuMaity | Posted: Sunday 18, January 2015 11:25:57 AM | | Check here for more question and answer
http://bit.ly/1xj9fJG
| | Back to Top ^ | | |
|
|
Home > Programmer2Programmer.NET Forum >IT Interview Question Answer Discussion >> Oracle D2k Form / Report and PL/SQL interview question with answers...
|