The SQL LIKE command’s output differs when you use it on CHAR and VARCHAR. Here is a post with an example.
Category: SQL
These two ways limit the number of rows return from an SQL query. These are helpful for Oracle and other SQL developers.
Here are SQL queries to insert single and multiple rows into a table. Helpful for SQL developers.
Explained SQL queries and syntax to drop a table or modify a table. And added SQL queries helpful to rename a table and truncate a table here.
Date conversion in SQL simplifies your work, and you will get the desired result. These two functions most people use in the production code.
Practical SQL queries to write Insert and Select in Single query explained with tables and queries.
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.
Srinimf 
You must be logged in to post a comment.