i use few third party softwares. they r all having their
own databases .
but the data is repeated in all these databases - say a
person is in all the three databases, but his name is
stoared in diff format in all databases
i want to create a centralised database ,and i dont want to
re-enter the records .
using the exisating records how can i build a centralised
database?
What command would you use to create a backup control file?
61
Explain materialized views and how they are used.
65
how do u setup a replication site?
15
Give the stages of instance startup to a usable state where
normal users may access it.
71
Explain sp_configure commands, set commands?
110
Iam learning oracle developer 2000..
can anyone give me then tutorials sites or PDF related to
developer 2000
please send me the details @ mak2786@gmail.com
thanks
Arun
45
Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
58
what are archived logs?
27
If a parameter is used in a query without being previously
defined, what diff. exist betw. report 2.0 and 2.5 when the
query is applied ?
If a stored procedure is taking a table data type, how it looks?
66
Can we use a Restricted packaged procedure in WHEN_TEXT_ITEM
trigger ?
80
Explain materialized views and how they are used.
41
How To Find That One Week Change in My DataBase we Have Done
Like We Have A database Test I Change Table,Stored Procd.
Then I Find Which SP,Table We Have Edit/Change in Seven
Dayes
53
what are the things that you consider while creating indexes
on partitioning tables?
25
Any sample or model question of punjab national bank for
deputy manger IT
or any sample of PNB.any1 plz do send on
36
what is partitioning? Types of partitioning. explain? what
is the new kind of partitioning type introduced in 9i?
15
if u develop report do u ask for anything from u r team leader
54
What column differentiates the V$ views to the GV$ views and
how?
150
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