Using Sequences in SQL

Using Sequences in SQL

Consider the BOOK_LOAN table. Here we list all the details about the books borrowed by the borrower. In this table we can have multiple...
Handling Duplicates in SQL

Handling Duplicates in SQL

Even though databases are designed to avoid duplicate rows/records, one cannot avoid duplicates in the columns. We have real time datas which can have...
SQL Injection in SQL

SQL Injection in SQL

When we write a sql queries, there is a possibility of inducing any unwanted query or conditions in the query. These induced query/ conditions...
Normalization in SQL

Normalization in SQL

Consider the library database that we are going to construct. We have identified the tables of the database. Even though we have created all...

Stay connected

9,228FansLike

Latest article

Multiplication of two matrices

Multiplication of two matrices

Given two matrices, this function will multiply the two matrices and prints the result. Here, necessary and sufficient condition is the number of columns...
Subtraction of two matrices

Subtraction of two matrices

Given two matrices, we will write a function that subtracts the given matrices. Example INPUT A = { {1, 4, 7, 9}, {1, 6, 7, 6}, {6, 3, 7,...
Check if two given matrices are identical

Check if two given matrices are identical

Given two matrices, we will write a function to check whether the two matrices are identical or not. That is, if all the elements...