why should required for Indexed by table in pl/sql3 4646
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?
What is the difference between Outer join and Full outer join?5 32329
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...7 7855
Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it... if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten.....and when you put a figure like 20536, at that time in that boxis TWENTY will wrote in "thousand" box FIVE will be in "hundred" box and THIREE will be in "ten" box...... so, in sort i need to know that how can i do module for this that it appears automatically in perticular boxs...thanks2 2718
HI THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS POSSIBLE BY USING DATASTAGE7.5.1 1566
can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?1 2686
can you any body tell me why are go for the rebuild the master database.what is the reason?2 2397
what is package and it uses and how can u call a package933
What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning
how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used
how to insert data into partitioned table partition done by Range partition1 13089
What different of iner joint & outer joint with example4 6709
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How many number of columns can a RECORD GROUP have ?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What is snapshot is too old? Give and example for better understand.
What are the Roles and responsibilities of database administrator?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
as a technical developer in oracle applications which type errors feced in your experience sofar
what is checksum in sql server.........???
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
What is the operator that is used for case-insensitive regular expression searches in PostgreSQL?
how do u setup a replication site?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
how many no of arguments can be passed in procedures and functions