in user parameter property we have list of values.can we
write select query for binding? for example:: select empno
from emp where deptno=:deptnum :deptnum is first parameter
it displays distinct dept nos. if i do like this it is
giving error:: bind variables are not allowed in the select
statement
112
How to do Data integrity testing? Who does this testing
(Developer or tester)?
99
what is software?
26
Typically, where is the conventional directory structure
chosen for Oracle binaries to reside?
14
Is it possible to insert comments into sql statements
return in the data model editor ?
Explain how you would restore a database using RMAN to Point
in Time?
6
How to use timestamp datatypes
7
does the query needs a hint to access a materialized view?
106
A successfully created SSIS package in SQL Server 2005 runs
fine in MS BIDS and Integration Services. But gives error
when run through an SQL-Job. What are the possible reasons?
There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
183
Which dictionary view(s) would you first look at to
understand or get a high-level idea of a given Advanced
Replication environment?
1
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
92
what is meant by magic query
110
what is mysql optimization in brief?
46
Give two methods you could use to determine what DDL
changes have been made.
120
What do you mean by Checkbox ?
143
You have just had to restore from backup and do not have
any control files. How would you go about bringing up this
database?
206
what are the advantages of running a database in archive log
mode?
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
