What will happen after commit statement ?

What will happen after commit statement ?
by

1 Answer

Answer :

Cursor C1 is
Select empno,
ename from emp;
Begin
open C1; loop
Fetch C1 into
eno.ename;
Exit When
C1 %notfound;-----
commit;
end loop;
end;
The cursor having query as SELECT .... FOR UPDATE gets closed after
COMMIT/ROLLBACK.
The cursor having query as SELECT.... does not get closed even after
COMMIT/ROLLBACK.
by

Related questions

Can you use a commit statement within a database trigger?

Description : Can you use a commit statement within a database trigger?

Last Answer : No

What is a 2 Phase Commit

Description : What is a 2 Phase Commit

Last Answer : Two Phase commit is used in distributed data base systems. This is useful to maintain the integrity of the database so that all the users see the same values. It contains DML statements or Remote ... b) Commit Phase :: Commit all participants to coordinator to Prepared, Read only or abort Reply

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

Description : Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

Last Answer : It is not possible. As triggers are defined for each table, if you use COMMIT of ROLLBACK in a trigger, it affects logical transaction processing.

what are difference between post database commit and post-form commit?

Description : what are difference between post database commit and post-form commit?

Last Answer : Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after inserts, updates and deletes have ... The post-database-commit trigger fires after oracle forms issues the commit to finalized transactions.

Describe two phases of Two-phase commit ?

Description : Describe two phases of Two-phase commit ?

Last Answer : Prepare phase - The global coordinator (initiating node) ask a participants to prepare (to promise to commit or rollback the transaction, even if there is a failure) Commit - Phase - If ... , if all participants cannot prepare, the coordinator asks all nodes to roll back the transaction.

What is Two-Phase Commit ?

Description : What is Two-Phase Commit ?

Last Answer : Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency across the global distributed database. It has two phase, a Prepare Phase and a Commit Phase.

What does COMMIT do ?

Description : What does COMMIT do ?

Last Answer : COMMIT makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed.

How to add conditions in select statement in oracle?

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

What are the types of SQL Statement ?

Description : What are the types of SQL Statement ?

Last Answer : Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.

How do u implement the If statement in the Select Statement

Description : How do u implement the If statement in the Select Statement

Last Answer : We can implement the if statement in the select statement by using the Decode statement. e.g select DECODE (EMP_CAT,'1','First','2','Second'Null); Here the Null is the else statement where null is done .

Can a formula column be obtained through a select statement?

Description : Can a formula column be obtained through a select statement?

Last Answer : Yes

What is Statement Auditing ?

Description : What is Statement Auditing ?

Last Answer : Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects.

Can you see Execution Plan of a statement?

Description : Can you see Execution Plan of a statement?

Last Answer : YES. In many ways, for example from GUI based tools like TOAD, Oracle SQL Developer. Configuring AUTOTRACE, a SQL*Plus facility AUTOTRACE is a facility within SQL*Plus to show us the explain plan of the ... - Like SET AUTOTRACE ON, but suppresses the printing of the user's query output, if any.

I've heard that if you are really, truly opposed to certain types of behaviors, then you won't commit those behaviors even after having too much to drink. Do you think this is true?

Description : I've heard that if you are really, truly opposed to certain types of behaviors, then you won't commit those behaviors even after having too much to drink. Do you think this is true?

Last Answer : I think it's true for the most part. There are always exceptions.. for some people. I've never slept with a woman because of being drunk never stabbed anyone.. never slept in the middle of the highway.. ... would never drink so much that I couldn't walk.. to me that's at least 13 levels of stupid.

When a user process fails, what background process cleans up after it?

Description : When a user process fails, what background process cleans up after it?

Last Answer : PMON

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Description : Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?

Last Answer : All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

Is it possible to link two groups inside a cross products after the cross products group has been created?

Description : Is it possible to link two groups inside a cross products after the cross products group has been created?

Last Answer : no

Is the After report trigger fired if the report execution fails?

Description : Is the After report trigger fired if the report execution fails?

Last Answer : Yes.

When a user process fails, what Oracle background process will clean after it?

Description : When a user process fails, what Oracle background process will clean after it?

Last Answer : PMON

What’s the best way you can think of to commit all seven deadly sins?

Description : What’s the best way you can think of to commit all seven deadly sins?

Last Answer : drink to excess

Which argument for healthcare policy, Democratic or Republican could have convinced this couple not to commit murder-suicide over worries on treatment costs?

Description : Which argument for healthcare policy, Democratic or Republican could have convinced this couple not to commit murder-suicide over worries on treatment costs?

Last Answer : To take the cynical side of this: Some Republican party supporters - mostly Tea Party and fiscal conservatives, would not have made any effort to prevent these people from commiting murder-suicide. Their rationale: ... come up to address these dead peoples' needs,, I wouldn't trust it for a second.

If Epstein was on suicide watch, how did he manage to commit suicide?

Description : If Epstein was on suicide watch, how did he manage to commit suicide?

Last Answer : I am convinced that this is one of these “He shot himself in the head. From behind. With his hands tied behind his back. From a 10m distance. How tragic.” situations. He was murdered, to tie up loose ends.

What would make you tell someone it's better for him or her to commit suicide?

Description : What would make you tell someone it's better for him or her to commit suicide?

Last Answer : I think that borders on conspiracy to commit murder.

Do animals agree to commit euthanasia, when they are taken as pets?

Description : Do animals agree to commit euthanasia, when they are taken as pets?

Last Answer : My dog is pretty tight lipped about the subject.

Why do people shame a person who wants to commit suicide when they have not gone through what he has?

Description : Why do people shame a person who wants to commit suicide when they have not gone through what he has?

Last Answer : Because it’s cheaper than a universal health care program that includes mental health.

If you own a super car, or a hyper fast muscle car does it mean you are eventually going to commit major traffic crimes?

Description : If you own a super car, or a hyper fast muscle car does it mean you are eventually going to commit major traffic crimes?

Last Answer : You're Canadian, so I'm going to spoon-feed this to you. Cars can only be driven when registered, insured, and piloted by a licensed, demonstrably competent individual. The right to pilot a ... of the American population is vehemently against, and the reason why those things don't exist here.

If someone has split personality and threatens that he or she will commit suicide, can it be considered as holding hostages?

Description : If someone has split personality and threatens that he or she will commit suicide, can it be considered as holding hostages?

Last Answer : No, I highly doubt it, because split personalities or not, it’s still only one person.

Have you ever had a customer you wanted to verbally abuse of commit acts of violence against?

Description : Have you ever had a customer you wanted to verbally abuse of commit acts of violence against?

Last Answer : answer:What people who deal with customers need to understand is the cost of re-acquiring a lost customer is prohibitively expensive while keeping a customer happy costs relatively little. Businesses sometime ... who are on the front lines with customers and by not having policies that support that.

Inspired by a movie I watched: If you were falsely convicted of a crime and done the time, should you, upon release, have the right to commit the crime you were falsely convicted for, without being punished?

Description : Inspired by a movie I watched: If you were falsely convicted of a crime and done the time, should you, upon release, have the right to commit the crime you were falsely convicted for, without being punished?

Last Answer : answer:Well, and just how's that gonna work for you? If you are the only one that knows, in their heart, you were truly innocent and the legal system disagreed, well .all you'd gain is a repeat ... , much better to swallow your bitter pill and move on. Unless you've come to enjoy prison life. lol

How should we talk to those who are having thoughts about and have made attempts to commit suicide?

Description : How should we talk to those who are having thoughts about and have made attempts to commit suicide?

Last Answer : Frankly, I always refer them to a mental illness suicide line or depression line because they are trained on how to deal with these things as a profession.

Could you commit murder?

Description : Could you commit murder?

Last Answer : answer:I could not. I’ve thought about it, and could not get past the theoretical level. I could plan. I could not execute. Knowing I could not execute, I wouldn’t bother to plan. There are other ways to solve problems, so it’s hard to imagine a situation where murder would make sense.

Why do teens commit suicide when they only have 4 years of high school?

Description : Why do teens commit suicide when they only have 4 years of high school?

Last Answer : I didn't realize until I was out of HS that I didn't have to be bound to the label that had been placed on me by the HS crowd. I'm sure that many HS students feel the same way ... people get stuck with I can imagine it would feel pretty hopeless, especially if it's coupled with mental illness.

Do you think that a person who lies to convict a person of a crime they did not commit should spend time in prison themselves?

Description : Do you think that a person who lies to convict a person of a crime they did not commit should spend time in prison themselves?

Last Answer : Abso-freaking-lutely. They should get the same amount of time as well. That person’s life was ruined because of them.

If you were the Judge and the Jury, and it were totally up to your judgement and opinion, what would be the punishment for the kid whose webcam spying caused his roommate Tyler Clemente to commit suicide?

Description : If you were the Judge and the Jury, and it were totally up to your judgement and opinion, what would be the punishment for the kid whose webcam spying caused his roommate Tyler Clemente to commit suicide?

Last Answer : He's 18? And he caused another person's death because of his thoughtless douchebaggery? Hmmmm. I'd likely sentence him to a long prison sentence. That other boy is dead because of him; that' ... prison sentence. With a gay cellmate nicknamed Shirley who gets really lonely in the middle of the night.

What are 100 reasons not to commit suicide?

Description : What are 100 reasons not to commit suicide?

Last Answer : 2. I want to see what tomorrow brings.

Could sibling rivalry lead a 14 year old to commit suicide?

Description : Could sibling rivalry lead a 14 year old to commit suicide?

Last Answer : How can any of us, not knowing the details and the child himself, dare to speculate?

What can we do when a large group of people commit a crime?

Description : What can we do when a large group of people commit a crime?

Last Answer : Um… build a large jail? : )

Do people who commit suicide imagine that they are about to enter an improved version of life?

Description : Do people who commit suicide imagine that they are about to enter an improved version of life?

Last Answer : It’s about the deep desire to end their suffering.

Did Kurt Cobain really commit suicide?

Description : Did Kurt Cobain really commit suicide?

Last Answer : First off I just have to say that I love Kurt Cobain. ♥ But I honestly think he committed suicide. I have heard from differen’t places that he might have been murdered. But I do not believe so.

Would you ever confess to a crime you did not commit?

Description : Would you ever confess to a crime you did not commit?

Last Answer : Nope

Can fishes commit suicide?

Description : Can fishes commit suicide?

Last Answer : Some fish jump. I’ve had fish jump out of the pond to their death. It happens and it’s not abnormal.

What do you believe is the best punishment for people who commit sexual crimes against children?

Description : What do you believe is the best punishment for people who commit sexual crimes against children?

Last Answer : Lifetime jail or just be executed.

Do you think the human species could be trying to commit suicide?

Description : Do you think the human species could be trying to commit suicide?

Last Answer : I don’t think that we’re trying to commit suicide, at least, in this moment – I just think that some of us are too lazy to realize what is happening and are unwilling to take the necessary steps to make changes.

Why commit suicide ?

Description : Why commit suicide ?

Last Answer : answer:Suicide is a personal decision . There are a lot of justifiable reasons to commit suicide ...just not justifiable to everyone. Remember we live in a culture where everyone must live no matter what ... do is talk to a therapist about this ..he can answer your questions better then Fluther .

Which of the seven deadly sins is the worst to commit in your eyes?

Description : Which of the seven deadly sins is the worst to commit in your eyes?

Last Answer : answer:It’s a tie for me between gluttony and greed. Both mandate that you take when it is unnecessary, and probably from someone that should have. The rest will mostly just make you kind of tacky.

Do you commit yourself to too much throughout the week? If you cut back, how has it affected your life?

Description : Do you commit yourself to too much throughout the week? If you cut back, how has it affected your life?

Last Answer : answer:This is irrelevant but I think Lisa is asleep so it might not get deleted right away. But my STFU script snagged your score. :-)

Should I commit to 5 days on the Appalachian trail?

Description : Should I commit to 5 days on the Appalachian trail?

Last Answer : Read A Walk in the Woods by Bill Bryson. It gives you a humorous and accurate view of this very thing.

Why don't guys commit?

Description : Why don't guys commit?

Last Answer : answer:If you are asking about guys in general in not committing, I believe it is an evolutionary thing. Men do not want to commit to just one partner right away especially at a young age because they ... level may complicate things for him and get him out of the comfort zone that he has with you.

What connection is there between perceived popularity of one's first name and tendency to succeed or commit crime?

Description : What connection is there between perceived popularity of one's first name and tendency to succeed or commit crime?

Last Answer : answer:I don’t care about people who haven’t committed crimes yet. When they do, I don’t care what their name is. As a personal observation, every guy I’ve known named Josh has been arrested for something.

What are creative ways to commit murder on the lunar surface?

Description : What are creative ways to commit murder on the lunar surface?

Last Answer : Forcing the astronauts to eat all that cheese at once, without any crackers and wine.