With DTS packaging I can store tables in Excel and convert
them back to SQL. But once I copied tables to Excel I want
to modify some info. How you do that without editing the
Excel file?
Let?s say you have 100,000 records and you want to delete
95,000 at a time and keep only 5 thousand. But in local
memory you don?t have enough space for 95,000 records. What
do you do in this case? How do you delete without any
problem with time and performance?
how you will identify the mapping level bottleneck ? if
there is a mapping level bottleneck then how will you try
to improve the mapping
44
what is Data Definiton Language ?
95
what do u mean by canvases and alerts?
34
With DTS packaging I can store tables in Excel and convert
them back to SQL. But once I copied tables to Excel I want
to modify some info. How you do that without editing the
Excel file?
How do I take a backup of Stored Procedure in Oracle?
57
Explain the classification of Database Management System?
39
How many number of columns can a RECORD GROUP have ?
68
What do you mean by Checkbox ?
81
what is GET_BLOCK property ?
92
I want to export the data date to date from oracle database
then what can i do?
32
explain about the critical recovery scenario you had
experienced
60
What are the Roles and responsibilities of database
administrator?
42
Which parameters are optional in init.ora parameter file?
66
Can we use a Restricted packaged procedure in WHEN_TEXT_ITEM
trigger ?
79
i have a web page and in this page i create 3 textbax and a
"summit" button do you have any html code for add text velue
in my web page like link summation(form) sites.
49
Write a note on File based system/ Data base system
36
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?