SQL First Query

Advertisements

Prev Tutorial Next Tutorial

SQL First Query

Before you start your first sql query, need to install any database software, here i will use oracle 10g. If you have no any database just download and install.

Note: At the time of installation give user name system and password: system.

Steps to get start with SQL

  • Run SQL
  • First connect with database.
  • For connect with database type: connect system and type password system
  • Now you can create table.

Create table

Syntax

CREATE TABLE table_name
(
column_name1 data_type(size),
column_name2 data_type(size),
column_name3 data_type(size),
....
);

Example

CREATE TABLE Employee
(
emp_id number(5),
name varchar(20),
salary number(10)
);

Employee table

emp_idnamesalary
   

Prev Tutorial Next Tutorial

Advertisements

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 9999595223

Pure VPN Privide Lowest Price VPN Just @ $1.65. Per Month with Non Detected IP Lowest Price Non Detected IP VPN

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

For Projects 9999595223

Google Advertisements


Buy Websites 9999595223

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs

Advertisements