if we want to load data from a text file into a mysql table,
but the columns in table are 1st: code(int) and 2nd:
city(varchar), but in text file the format is 1st cityname
and then code separeted by delimeters. how to load?
If there exist a index on the table, and we then make a
view on that table (include the indexed column from base
table) than why do we require indexing on view?Doesnt it
create an overhead?
How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
A Table has 10,000 records,How can i get latest 10 dates
from the table.so that i can only store those 10 records
in to my Resultset Object,to reduce load on my app?
What types of questions are asked in NIC(Natinal
Informatics Centre)'s interview?If any one has any
information about this,I would be very thankful to
him/her.....
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 GET_BLOCK property ?
209
What is the Tune Query
111
how to clone 9i Database on to 10g Database.
211
Write about Transaction Management in Oracle 9i?
197
how report can be generated if we have the database designed
in oracle 10g?
14
How would you go about increasing the buffer cache hit
ratio?
208
where can i free download sqlserver2008..i can install
sqlserver2008 without visual studio 2008 and work on it
128
What command would you use to encrypt a PL/SQL application?
216
How would you best determine why your MVIEW couldn't FAST
REFRESH?
4
How do you recover a datafile that has not been physically
been backed up since its creation and has been deleted.
Provide syntax example.
54
we have 10 concurrent programs under one request group
out of 10 ccps all users submitting only 9 programs from
srs window remaining one ccp for specific user how can it
possible send me answer asap.