What will happen after commit statement ?

Answer Posted / highness

locks will be released

changes will be made permanent

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the need of merge statement?

543


Why do we use set serveroutput on?

506


What is sql and db2?

526


What are the commands used in sql?

519


How to pronounce postgresql?

572






Is crud a cuss word?

539


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 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

2056


What are the most important characteristics of pl/sql?

566


Are stored procedures compiled?

519


Why stored procedure is better than query?

499


What is difference between pl and sql?

526


Write a unique difference between a function and a stored procedure.

523


Explain the the update statement in sql?

562


What do you think about pl/sql?

522


How can you fetch first 5 characters of the string?

542