Here is an SQL query to alter an index in DB2. When to drop the index and when not required while altering the index, added guidelines for your reference.
Sorting is a tricky concept in SQL. How to sort rows and order them, need for the hour. Here are the easy ways to use sorting in SQL.
Here is an SQL query to get only Date from the Datetime column. This is tested in Oracle. Also, added SQL query to get both Date and Time.
In SQL, MERGE is the latest statement. You can include all UPDATE, INSERT and DELETE statement in single query. Major RDBMS databases support this statement.
Here are the top differences between named PLSQL and unnamed PLSQL and their usages.
Here are Srinimf’s top blog posts. These are popular for the year 2021.
Here is a sample sub-query. Here you will read records from two tables. Also explained how the query works.
Here are steps of how to create a procedure in SQL developer and how to call it.
Here’s a sample Explain plan query to find statistics of the execution plan. Useful for SQL and Data warehousing developers.
Check and Default constraints are both not the same. They create during create Table. Differences between these you can understand with these examples.
Here are top interview questions associated to SQL tables
You can modify Table data with thse SQL queries. Those are Insert, Update, Delete and Merge.