I got an error SQL1042C. An unexpected system error
occurred.
Explanation:
A system error occurred. One possible reason for this error
is that the database manager is not installed correctly or
the environment is not set up correctly.
On OS/2, while trying to start the database manager, a very
common reason for this error is a corrupted NET.ACC file.
The command cannot be processed.
The tables and views would not be opened. What is the way
to open the dataase?
pls help me
Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3
Answer:select length(trim('ram charan singh')) - length
(replace
(trim ( 'ram charan singh'),' ','')) +1 from dual
The above query working properly when space between the
words is only one &similar
But ,If the space between the words is nonuniform.
Ex:'ram charan singh is good' ans:5
i am not getting this answer using above query.
Where would you look for errors from the database engine?
83
what are the advantages of running a database in NO archive
log mode?
2
i wrote a pl/sql procedure. it must run every sunday 4.40
How can i schedule it with the help of dbms_jobs (or
another other procedure with out creating bat file,exe file)
What is log shipping? Can we do logshipping with SQL Server
7.0 - Logshipping is a new feature of SQL Server 2000. We
should have two SQL Server - Enterprise Editions. From
Enterprise Manager we can configure the logshipping. In
logshipping the transactional log file from one server is
automatically updated into the backup database on the other
server. If one server fails, the other server will have the
same db and we can use this as the DR (disaster recovery) plan.
49
How would you determine who has added a row to a table?
71
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
32
I need to get the values of the previous quarter.how to do
this?eg: if my cuurent month is may i need to get the datas
of the month jan,feb,march.Can it be done in oracle.I tried
with date function q but for the month jan its not
retriving the previous quarter(oct-dec).how to solve
this.plpz anyone help me?
To Refer this Site to Your Friends 
Site Map