Home / Index Page

DAY-1: EXAMPLE-1


Student Table

Key word: Select, Create, Insert
Schema:

Entity/Field Name
Data Type
Student_id
Number(10)
Name
Varchar2(30)
Program_id
Varchar2(15)
City
Varchar2(15)
Division
Varchar2(15)
Country
Varchar2(15)

DDL for Create Above Table:

SQL>create table student
(student_id number(10),
name varchar2(30),   
program_id varchar2(15),
city varchar2(15),
division varchar2(15),
country varchar2(15)
);

After created the student table, naturally we may try to insert some values or data. It’s a natural sense to keep data in database for further use. To see the inserted data, the SELECT command is only one way according to the SQL statement writing rule.

Insert Value for Above Table:

SQL> insert into student
    values(200819222,'Adina Bashar','English','Noakhali','Chittgong','Bangladesh');

Using the above command Insert some values as you like. After that or after some moments you may see your data. Use the below statement to see your inserted data or value/records. There are lots of styles of inserting values to the table. Visit HERE to get more ideas of insert command.


View or See Value from Above Table:

SQL> select * from student;
The above statement will return all records with all field from student table.

SQL> select student_id,name from student;
The above SQL command will return only student_id and name of all students.

SQL> select name, city from student where student_id=200819222;
The above SQL command will return only name and city of a student whose id is 200819222.

Click HERE to view more example of SELECT command


In Day-1, our target is to understand the SQL, not to know create, insert or any other SQL command. We will discuss for those with details. The day is only to understand the SQL and the three clauses of SQL statement. They are SELECT, FROM and WHERE and also their implementation.

Some Things You Must Know about Database Management related to SQL. <<CLICK HERE>>

5 comments:

  1. How To Insert Multiple values in a table between ???????????

    ReplyDelete
  2. https://www.dropbox.com/s/adihwq2g3sio8is/New%20Text%20Document.txt?dl=0

    ReplyDelete
  3. Gone through this wonderful coures called Salesforce Certification Training in Dallas who are offering fully practical course, who parent is Salesforce Training in USA and they have students at Salesforce Training classes in Canada institutes.

    ReplyDelete

  4. This article is really helpful for me. I am regular visitor to this blog. Share such kind of article more in future. Personally i like this article a lot and you can have a look at my services also: I was seriously search for a Salesforce training institutes in ameerpet which offer job assistance and Salesforce training institutes in Hyderabad who are providing certification material. It's worth to join Salesforce training institutes in India because of their real time projects material and 24x7 support from customer desk. You can easily find the best Salesforce training institutes in kukatpally kphb which are also a part of Pega training institutes in hyderabad. This is amazing to join Data science training institutes in ameerpet who are quire popular with Selenium training institutes in ameerpet and trending coureses like Java training institutes in ameerpet and data science related programming coures python training institutes in ameerpet If you want HCM course then this workday training institutes in ameerpet is best for you to get job on workday.

    ReplyDelete

Popular Posts