Blogs

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.


Difference between delete and truncate video

Jun 11 2017 04:58 AM by Kishan Mashru

This blog discusses the differences between a delete statement and a truncate statement in Oracle SQL


How to solve ORA-28000: the account is locked? video

Jun 06 2017 11:34 AM by Kishan Mashru

This blog helps you to solve the error ORA-28000: the account is locked error by executing an ALTER USER statement to unlock the user, also the blog gives query to update password of any user account.


Sequences in Oracle video

Jun 04 2017 04:06 AM by Kishan Mashru

This article is targeted for understanding the concept and usage of sequences in Oracle SQL.


Deleting duplicate records from a table video

Jun 03 2017 11:22 PM by Kishan Mashru

This article shows an example of deleting duplicate records from a table using three different techniques such as using GROUP BY and HAVING, an analytical function such as row_number, and the third one by using the correlated subquery.


Difference between procedure and function in Oracle PL/SQL video

Jun 02 2017 02:38 PM by Kishan Mashru

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


Palindrom Program video

May 13 2017 12:36 AM by Kishan Mashru

This article is to illustrate how to find palindrome number in Oracle PL/SQL


Factorial Program video

May 13 2017 12:36 AM by Kishan Mashru

This article is to illustrate factorial program in Oracle PL/SQL.