Mar 10 2019 10:42 AM by
You cannot decrease the length of a column to an extent that any of the data present in the column gets affected. Got the following error when trying to alter the size of a column containing data.
This blog contains the article on the difference between Oracle PL/SQL function and procedure. Differences such as function would definitely some value back to the calling environment but a procedure may or may not return some value back to the calling environment, and much more are broadly discussed with examples, The same article is also well explained in a YouTube tutorial video on https://youtu.be/pofSn7lzqxA