In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column
in DATA_EXTRACT_VIEWS table contain NULL value?
15
My requirement is like in database some defects are present
and i need to clean them.To be brief for example every
employee should have active assigments.So for those records
which are not having status as active or null ,i need to
update the roecords using API with the correct value.
Client will provide a flat file for the records whch are
defected.So i need to run the API for those records (flat
file)and update the data in database.
So my question is how to handle this requirement.Is there
any existing API for this purpose?If yes then please send
me the NAME.
How to update the records in the database using flatfile.
Any pointer will be appreciated.Thanks in advance.
You create a private database link <link name> and upon
connection, fails with: ORA-2085: <Link name> connects to
<fully qualified remote db name>. What is the problem? How
would you go about resolving this error?
11
what are steps for interface?
where is exchange rate defined in which table?
12
hi,
the following are the outputs of sp_spaceused and
sp_tempdbspace
sp_spaceused
------------
database size unallocated size
tempdb 77752.95 MB 28026.99 MB
sp_tempdbspace
-------------
database size spaceused
tempdb 77752.945312 1.007812
the unused space in sp_spaceused is nearly 28 Gb and in
sp_tempdbspace is nearly 76 Gb
cany any one explain about this output and why its giving
different results.
166
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
144
What is the difference between Sleep and Wait? (Java)
sequence of firing triggers for text-item is:
1)key_next_item,
2)when_validate_item,
3)post_text_item
Now i change sequence of firing triggers like
when_validate_item,key_next_item...
Is it possible to change sequence? How?
402
What query tells you how much space a tablespace named
"test" is taking up, and how much space is remaining?
2
HI
THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY
SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS
POSSIBLE BY USING DATASTAGE7.5.
173
How to do Data integrity testing? Who does this testing
(Developer or tester)?
99
what is a Nested Loop join?
119
suppose u have been seven tables based on that u have to
create a report u don't have access to db. then how do u
find the relation between tables
131
mazimum size of a database in mysql? when we create a table
then how many tables actually created? write there name?