Posts

Image
                       CREATE TABLE We use sql   CREATE TABLE   statement to create table in a database. Sql statement is used to create  table, delete table,  insert  and update  table,delete data in table . T he structure consists of the name of a table and names of columns in the table with each column's data type. The datatype specifies the type of data the column can hold (e.x. varchar, integer, date, etc . ).     syntax of the SQL  CREATE TABLE  statement is: create   table   table_name(    column1   data type ,   column2   data type ,   column3   data type ,  column4   data type , ...  columnN   data type );   NOTE ➗ •    Column   → The column specify the names of the columns of the table. •    table_name → it is the name of the  table. •...
Post a Comment
Read more
Image
        * HOW TO CONNECT ON ORACLE SQL* Now to connect to ORACLE SQL and to run PL/SQL program we have to  first install ORACLE RDBMS server. *RDBMS→ { R elational Database Management System} It is a collection of data which stores,manage and retrieve data in a relational database.  Now before connecting to oracle first we have to install   O racle Database XE { 21C Express Edition} .  Below are following steps how we can Install Oracle Database XE.Below is the Direct  link to Download oracle database.   Oracle Database 21c Express Edition for Windows x64 You can also install this  through oracle website, Steps are i]     Go to   Oracle Download ii]    Select Database from Developer Downloads  iii]  click on Database Express Edition from Database Section. iv] Click on   the latest version for Windows from the  Oracle Database 21c Expression Edition These are the ste...
Post a Comment
Read more
Image
                                                                         SQL Intro In this today's technology   there has been a growing demand for SQL.  SQL developers are in high demand across a wide range of industries, from health care to retail to finance .         Now before Comming to sql ; first we have to know what is DBMS  * DBMS - Data Base Management System      (A Software designed to store define retrieve and manage data in database) * Database- A database is a collection of interrelated data and information e.x.            NAME            ROLL           DOB   ...
Post a Comment
Read more