SELECT statement for SQL

What is a Select Statement for SQL?

SELECT statement for SQL, sometimes referred to as a Query, allows you to retrieve the records you want from the database so that you can manipulate or analyze them further. In this article, we’ll cover how to write a SELECT statement in SQL and look at some examples of how they are used. When writing your own SELECT statement for SQL, it’s important to consider two factors as mentioned below:

  • the source (where you are pulling your data from) and
  • the columns (which data fields you want).

These can both be changed using clauses in your statement.

What is Select Query

A select query is used to get data from a … Continue Reading

SQL INSERT INTO 1

Insert query in SQL | SQL insert statement in Oracle

Insert query in SQL

Introduction to Oracle INSERT statement

In our previous post, we learned about how to create a table in SQL by CREATE TABLE statement. After CREATE TABLE we will learn how to INSERT INTO data in SQL table. To insert a new row into a table, you can use the Oracle INSERT statement as follows:

INSERT INTO table_name (column_list)
VALUES( value_list);

In the above statement, we can see COLUMN_LIST is the name of columns in which we wanted to insert the data. While value_list shows values that we wanted to INSERT INTO the columns of SQL table mentioned above. Also, it should be noted that every value and column name should be separated by comma.… Continue Reading

How to create a table in SQL | SQL tutorial for beginners |SQL create table

How to create a table in SQL

In this tutorial, we will learn how to create a table in SQL. For creating a new oracle table we will use CREATE TABLE statement in the oracle database. It must be noted that we should have privilege to CREATE TABLE in sql schema. Also the sql table should have quota for table space.

SYNTAX for CREATE TABLE
CREATE TABLE schema_name.table_name (
    column_1 data_type column_constraint,
    column_2 data_type column_constraint,
    ...
    ...
 );

In the above SQL code we can see

  • CREATE TABLE : It is the main clause under which other information is put.
  • schema_name.table_name : We will mention schema name and then table name which we wanted to create. There are some
Continue Reading

SQL data types for Oracle/PLSQL

PLSQL datatypes

In this article, we will understand briefly PLSQL datatypes. Each value in PL/SQL such as constant, variable, or parameter has a data type that defines their storage and calculation behavior. PL/SQL has basically two types of data types e.g scalar and composite.

Types of sql data types

Scalar data types

In scalar data type are those data type that stores a single value. Scalar data type has further four data subtypes

  • Number
  • Boolean
  • Character
  • Datetime
Composite data types

Whereas composite data type stores multiple values. There are two data sub types of composite data types are available.

  • Record
  • Collection

In this article, we will be discussing only scalar data type

Oracle number data type

The numeric data … Continue Reading

Oracle dual table: what is dual table in oracle

Oracle dual table

Oracle dual table is a table automatically created by oracle database along with the data dictionary. DUAL is in the schema of the user SYS but is accessible by the name DUAL to all users.

Why dual oracle table is required

In oracle, SELECT statement requires FROM clause, which fetches data from oracle table. But in some scenarios, we have constant values which is not available in any table and we need to refer to these values in our SQL queries as additional value. To use these we require SQL DUAL table.

select lower('I AM AN ANALYST') from dual;

In the above example, we wanted to use a constant value ‘I AM AN ANALYST’ in a small … Continue Reading

Oracle SQL developer download : How to install oracle sql developer

SQL developer download

In this article we will be learning sql developer download for windows 10. Oracle sql developer installation is very easy and I will be explaining it in step by step method. We will also be learning how to create connection in SQL developer with SQL database which we learned in our previous article.

how to install oracle sql developer

To install SQL developer we will first go this link the download on Windows 64-bit with JDK 8 included if we don’t have java installed on our system else we can download Windows 32-bit/64-bit.

Oracle SQL developer download
Oracle SQL developer download

We click on the download icon it will redirect to other page for Sign In. If you already have … Continue Reading

How to install Oracle database: Easy steps to install Oracle database in windows

How to install Oracle database

Types of Oracle database

Oracle is providing three types of databases to download.

  • Enterprise Edition – It is a common and expensive edition of oracle database. There is no limit on memory or database size, and it provides many features that are not available to other editions.
  • Standard Edition – It is a limited edition of enterprise edition, and it also has no limit on memory or database limit. It also provides many features but less than oracle enterprise edition.
  • Expression Edition – It is a free-to-use version of oracle database and has very limited features. Like it uses a maximum of 2GB of RAM and has 12GB of user data.

A Step By Step

Continue Reading

How to Install Anaconda for Windows

How to Install Anaconda for Windows

Are you a data geek? Want to know how to install Anaconda for windows. Also want to write your first python or R code with the best distribution platform which arranges code for both.

So I am here with this blog, we will learn about the complete Anaconda setup method (Download and Install Anaconda Python) for Windows.

What Is Anaconda?

Anaconda is a tool that is used in Machine Learning and Data Science. It is a free open source distribution for R and Python Programming Language. It contains the source of software for heavy data processing, data analytics, and many more.

In the below blog, I will be guiding you step-by-step through downloading as … Continue Reading

How to create multiple worksheets from a list of cell values using VBA

How to create multiple worksheets from a list

In our earlier article, we learned about how to create multiple worksheets in excel without using VBA. In this article, we will be learning How to create multiple worksheets from a list of cell values using VBA.

First, we will create a list of names that we wanted to name the worksheets.

How to create multiple worksheets from a list of cell values using VBA
How to create multiple worksheets from a list of cell values using VBA

After making the list we will select the range as our VBA code will work on the selection method.

Sub AddWorksheetsFromSelection()
Dim Ws As Worksheet
Dim Sr As Range
Dim c As Range

Sub AddWorksheetsFromSelection()
    Dim Ws As Worksheet
    Dim Sr As Range
    Dim c 
Continue Reading

How to create multiple worksheets from a list of cell values without VBA

Creating Worksheets from a List of Names

Creating multiple worksheets from a list of values is very easy and it could be created by multiple methods. In this article, we will explore ways of creating it by using the following method. Though manually creating worksheets will be very time-consuming and using some tricks could make easy the task.

The first step in creating the task is to list all the values that we wanted to name the worksheets.

list the names for the worksheet
list the names for the worksheet

After listing the name insert a pivot table by using the newly created list as data range. After inserting the pivot table put the name of worksheet column in pivot table Filter as illustrated in the … Continue Reading

fb-share-icon