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?
Can we use a Restricted packaged procedure in WHEN_TEXT_ITEM
trigger ?
164
a table has 2 classifications
1)liabilities
2)earnings
this liabitity has 2 elements with 2 input values
and
the earnings have 2 elements with 2 input values
i wrote a query so that my input is
liability savings amount1 amount2
xxxx null xxxxxx 0
xxx1 null xxxxx1 0
null yyyy 0 yyyy
null yyy1 0 yyy1
my problem is
--when i developed a report(d2k) with this data
my o/p is
liabilities,amount1,savings,amount2
xxxx xxxxxx
xxx1 xxxxx1
yyyy yyyy
yyy1 yyy1
how could i move this savings,savings values 2 palces up.
can any body provide me witha better solution
Draft one mock email requesting your non-technical
management grant you downtime to (provide justification
where applicable) complete the following tasks:
(1) Generate statistics on a large table;
(2) Generate an RDA – if you don't know what an RDA is
please say so.
(3) Rename datafiles.
29
from where do u receive the information to develop report
121
In which dictionary table or view would you look to
determine at which time a snapshot or MVIEW last
successfully refreshed?
2
what is mysql optimization in brief?
46
I have some query regarding Report generation from Oracle
Apps "PO module".
I have to generate a report where table columns are as below:
Vendor_name Invoice No PO Number Item_Quantity Value of
Goods Date of Shipping Name_of_the_transport
Date_of_receipt_issued.
Now my questions is :from which table/column I can get the
information of "Name_of_the_transport" column.
Thanks in advance.
133
How to create Drill down report?
240
In what script is "snap$" created? In what script is the
"scott/tiger" schema created?
9
Illustrate how to determine the amount of physical CPUs a
Unix Box possesses (LINUX and/or Solaris).
3
did u received a single file or multiple files
146
How to combine two function together?
14
HOW TO FIND display the total number of weeks in the year
of 1998 IN EMP TABLE
58
how many tupples can insert in 1 second in sql
68
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE
DESIGN UNIVERSES?
118
Give the stages of instance startup to a usable state where
normal users may access it.
184
Describe what redo logs are.
100
explain about the critical recovery scenario you had
experienced
171
how can db_files > maxdatafiles since db_files is for
instance and the later is for database
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
