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.
This comment has been removed by the author.
ReplyDeleteHello,
ReplyDelete11/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,
Hey Brother,
ReplyDeleteThe 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
declare DOW with a length:
DeleteDOW varchar(10);
Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com
ReplyDelete