create procedure proc1 (@a int)
as
begin
if @a=1
create table #temp(a1 int)
else
create table #temp(a1 int)
end
while executeing the above code it shows error
like '#temp already exist' .why it shows an error?
why should required nested tables, Object types, partition
tables and varying arrays. what is the difference between
these are all. give me example with explanation.
Which types of backups you can take in Oracle?
2. A database is running in NOARCHIVELOG mode then which
type of backups you can take?
3. Can you take partial backups if the Database is running
in NOARCHIVELOG mode?
189
How to generate OIDS
15
Does QTP Support the Propjects which are running in Dot Net?
As we are starting with new project in Dot net need to use
automation tool?Please advice & let me know what would be
the best.
158
master table and child table performances and comparisons in
Oracle ?
109
Is it possible to insert comments into sql statements
return in the data model editor ?
Which dictionary tables and/or views would you look at to
diagnose a locking issue?
5
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
382
We are using Oracle apps with XML publisher.In that,we are
facing some problems while giving a Footer in RTF
Template.While giving a footer in RTF Template it is
Visible in all the pages,but after the PDF is getiing
generated,the Footer are Visible on alternate pages only
(like on first page ,third page) and so on.
Please provide the Solution for getting the Footer on all
the pages.
99
What are the Features of Forms 6i over 4.5?
What are the Features of Forms 10g?
What are the Features of Reports 6i?
What are the Features of Reports 10g ?
144
currently iam working in mnc as a oracleappsdba,please send
the EXPERIENCE RESUME those who r worked as a oracle apps
dba
135
how to clone 9i Database on to 10g Database.
213
I have done oracle 10g. I need a project knowledge. So if u
please send a project how it should be done,Or you can send
email link. I will be very grateful to u.
5
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?
12
ORACLE ME HINDI NOTES CHAHIYE OR ANY WEB SITE ADDRESS PLZ
GIVE ME IN MY EMAIL ADD,/////////// sunny.145@rediff.com
253
what is the diffrence between before parameter form triger
& formate trigger
106
i am writing a query select EmpNo from Emp how can i call in
after parameter form