if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
1 3976i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
1 3489t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
2 3744if i am using dml statement in function. then i am writing select statement what was the output
2 4516Post New MasterCard Oracle General Interview Questions
-
MasterCard Oracle General Interview Questions (4)
What items of information about a task might be useful in real time scheduling?
What are the different software testing tools?
What is Meant by at Discount in Issuance of Shares?
This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?
what is the difference between openrowset and openquery?
Hi i am urgently in need of the ISTQB sample exam questions by John A Estrella and Maria C Estrella as i am going to take the exam at the end of this month. Please send the ecopy of this book to tselvi83@yahoo.co.in
Who is the Governor of Reserve bank of India (RBI)?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
Screenshot document for solution manager installation.
Can I still purchase flex charting?
How to Remove drives listed in a TDriveComboBox ?
Tell the basic difference between banking and finance?
What was your role in the silicon evaluation/product ramp? What tools did you use?
Hi friends I have experience of 6 months in website design and maintanence. Now i am looking for other IT jobs.. to switch platform. please post any interview you know in chennai.
What's your ideal company?
