Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Tuesday, 11 April 2017

SQL Rollback

This will undo the operation.
This will be applied in two methods.
  • Upto previous commit
  • Upto previous rollback

Syntax:
Roll or roll work;
Or
Rollback or rollback work;
* While process is going on, if suddenly power goes then oracle will rollback the transaction.
Share this article :

5 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. Hello,

    11/10!! Your blog is such a complete read. I like your approach with sql rollback. Clearly, you wrote it to make learning a cake walk for me.

    how to find first nonspace character from end of the string

    ex: 'abc def g '

    I should get 4 in this case. (the first nonspace character from backwards in the above example is g and the position is 4 from backwards.

    Could you help me in getting this?

    I am so grateful for your blog. Really looking forward to read more.

    Best Regards,

    ReplyDelete
  3. Hey Brother,


    The challenge however, is we don’t yet know how it will be used making to hard to assess their value proposition and consequently value.


    I am trying to write a if-else sql block as below :

    Code (Text):

    DECLARE
    DOW VARCHAR;
    BEGIN
    SELECT TO_CHAR(SYSDATE,'DAY') INTO DOW FROM DUAL;
    IF
    DOW = 'MONDAY'
    THEN
    DBMS_OUTPUT.PUT_LINE('TODAY IS MONDAY');
    ELSE
    DBMS_OUTPUT.PUT_LINE('TODAY IS NOT MONDAY');
    END IF;
    END;

    Code (Text):

    It is resulting in below error:
    ERROR at line 2:
    ORA-06550: line 2, column 8:
    PLS-00215: String length constraints must be in range (1. 32767)

    What is the problem here?





    Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.


    Grazie,
    Radhey

    ReplyDelete
    Replies
    1. declare DOW with a length:

      DOW varchar(10);

      Delete
  4. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com

    ReplyDelete