Posts

Introduction to SQL

Introduction : SQL stands for Structured Query Language. The Oracle Server supports ANSI standard SQL and contains extensions. What is SQL ? SQL is the language used to communicate with any Database. SQL is the standard language for Relation Database System. Why we use SQL? - Allow user to create new databases - Allow user to create tables in database - Allow user to create Schema objects - Allow user to create and manipulate data from database. What is table? Table is a basic unit of storage. Table is a combination of rows and columns. Here, we can store all the data information as cell format. We can use create statement to create table in database. --Basic of SQL : Select clause: Select statement is used extract data from the database or retrieves information from the database. with help of select clause we can restrict a column which you want to returned by your query. From clause: A From clause, which specifies the table containing the columns listed in the SELECT ...
Recent posts