Select Databases - Use Database

Select Databases – Use Database

Select Database We can create any number of databases in a system and we can use any one of them at a time depending upon...
Create Table

Create Table

Once database is created, we can login with our credentials and start create our own DB objects like tables, views, constraints, procedures etc. The...
Drop Table

Drop Table

Drop Table Suppose we need to delete any of the tables that we have created from the database. We can use DROP statement to drop...
Truncate Table in SQL

Truncate Table in SQL

Truncating the table will not drop the structure of the table from the database, but it will only remove the data stored in the...
Example of creating DB in SQL

Example of creating DB in SQL

Though we spoke about creating databases using syntaxes, oracle provides a GUI to create a database. Below is the screenshot of creating a database...
Insert Query in SQL

Insert Query in SQL

Let us consider the same example of library database to see how records will be inserted and selected from tables. All the tables in the...
Select Query in SQL

Select Query in SQL

After executing above sql file, all the tables in the library database have few records. Now how do we see these inserted records from...
Where Clause in SQL

Where Clause in SQL

Above select query pulls all the data from the table. But user requirement is not always to retrieve whole table data. We should be...
AND & OR Clauses in SQL

AND & OR Clauses in SQL

Consider the below query which retrieves the records borrower whose loan due date is in June. SELECT BRWR_ID, ISBN FROM BOOK_LOAN ...
Update Query in SQL

Update Query in SQL

Let us consider the same library database to illustrate update, delete, like and Top clauses. Update statements are used to update existing records in the...

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...