how the indexes are stored in the Oracle Database?
6
what are the things that you consider while creating indexes
on partitioning tables?
24
what is a Nested Loop join?
21
How we can able to import our own template (users designed
MS-Word templates) which has many tabular columns; need to
pass some values generate by Oracle-reports9i?
Actually need to import more than 400 MS-Word templates into
Oracle Reports-9i to minimize layout design in Reports.
50
What are the built-in functions used for sending Parameters
to forms ?
Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3
Answer:select length(trim('ram charan singh')) - length
(replace
(trim ( 'ram charan singh'),' ','')) +1 from dual
The above query working properly when space between the
words is only one &similar
But ,If the space between the words is nonuniform.
Ex:'ram charan singh is good' ans:5
i am not getting this answer using above query.
40
For a field in a repeating frame, can the source come from
the column which does not exist in the data group which
forms the base for the frame ?
Q1:code to connect to sql server(database) through jdbc
application.
Q2:code to connect to Mysql(database) through jdbc application.
Q3:code to connect to oracle(database) through jdbc application.
26
How to select oracle sequence from different schema and
How to select oracle sequence from different Databases.
Explain with example