what is the index and synonym. i have the definitions ...can
any one give me brief explanation..
with regards,
No Answer is Posted For this Question
Be the First to Post Answer
What do you understand by aggregation and atomicity?
What do you mean by buffer manager?
What is the purpose of sql?
What is the use of drop command?
What is the use case where we can use stretch database?
What is stored procedure in database?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name, price 101, LED Lights,200 102, 20 watt CFL Lights, 145 103, 30 watt CFL lights,155 Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence flat file product list has two column pro_name, price 20 watt tube light ,45 30 watt tube light ,60
what is the use of SYSTEM.EFFECTIVE.DATE varaible ?
How a Store Procedure called with a cursor out parameter.?
How do you delete a table from database?
How to do replication of firebird databases?
Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don?t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?