BTechPath Blog

Explicit Datatype Conversion in SQL statement

Explicit Datatype Conversion in SQL statements like TO_CHAR, TO_DATE, TO_NUMBER Explicit means that you must specify how the data type should be converted. If you don’t specify how SQL Server should convert the data...

conversion functions in SQL

In this post, we are going to learn conversion functions. Using conversion functions and conditional expressions In addition to Oracle datatypes, columns of tables in an Oracle8 database can be defıned usiıiü ANSI. DB2,...

Datetime Function in SQL queries

what is a datetime function in SQL Datetime function operates on date (DATE), timestamp (TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE), and interval (INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH)...

sql functions

In this post, we are going to learn about SQL functions.SQL Server has many built-in functions. We are now going to discuss some of the functions like string, numeric, date, conversion, and advanced functions in SQL Server. There are two...

SQL Order by clause to sort the output

In this post, we are going to learn how to sort the output using SQL order by clause. SQL Order by clause: If you want to sort the rows by some kind of attribute,...

Logical Operators SQL AND OR and NOT in SQL

In the previous post, we learned about how we restrict the results using where clause, now we will learn more about sql where clause with logical operators in SQL. The three important logical operators...

Restricting the data using sql where clause

In the previous post, we learned about projection in which we restricted the oracle to display only certain columns. Now we learn about restricting the rows using SQL where clause. when retrieving data from...

Retrieving Data Using SQL Select Statement

In this post, we are going to learn about SQL Select statement. A SQL select statement retrieves information from the database. With a SELECT statement, you can use the following capabilities. Projection: Select the columns...

Installing HR schema Oracle 12c

In this post, we are going to install a new schema in Oracle database to practice the Oracle SQL commands. Throughout this SQL tutorial course, we are going to use HR schema for learning SQL. When...

Introduction to Oracle SQL

In this SQL tutorial, we are going to learn the basics of Oracle SQL. we are going to understand what is SQL, what is RDBMS and the basic introduction of SQL. Introduction to Oracle...