This winter holiday season, give a precious gift to your career by upgrading your skills. | Get Flat 15 - 20% OFF on All Courses | Save Today

[iqquestion id=24]

7 thoughts on “Database : Database Operations Discussion 5

  • karim

    CREATE TABLE Records
    (ID int(10),
    Name char(20),
    Address Char(50),
    Phone int(10), );

    INSERT:

    INSERT INTO Records
    (ID, Name, Address, Phone),
    VALUE (581, john, 43809 Blossom hill Ashburn va, 7032915060);

    UPDTE:
    UPDARE Records
    SET Name=Mike, Address= 2131 lees mill hill Dallas tx 75211, Phone=2713396905,
    WHERE ID=581;

    SELECT ALL:

    SELECT * Records;

    SELECT ID AND NAME:

    select name, address from records;

    ALTER TABLE:
    to add column to a table:
    alter table Records
    add personal_contact varchar2(20);

    DELETE:
    delete records;

  • Pamela halbhavi

    Most of these tested on Oracle 10 and working

    Create a Table name as RECORDS, Where columns are- Id, Name, Address, Phone. –

    Create table RECORDS(
    id Int not null,
    Name varchar2(30),
    Address varchar2(55),
    Phone varchar2(20));

    INSERT –
    Insert into RECORDS
    values(01,’Alex’,’AAAAAAA’,’7031112222′);

    UPDATE –
    Update RECORDS
    set Name =’Alexis’ where Id=01;

    SELECT all –
    Select * from Records;

    SELECT Id and Name –
    Select Id, Name from Records;

    SELECT with WHERE clause –
    Select * from RECORDS where id = 04;

    DELETE –
    Delete RECORDS where Id = 05;

    ALTER table –
    ALTER table RECORDS
    add Mobile varchar2(20);

  • nasir

    Create Table RECORDS(PersonID int, Name varchar(255), Address varchar(255), Phone varchar(20),);

    INSERT
    (id,name,address,phone),
    value(‘001′,’ali’,’2391 rolling fork circle herndon va’,’2027585300′);

    UPDATE
    set name=’palwinder’where id=010;

    SELECT all
    SELECT * from Records;

    SELECT Id and Name
    SELECT Id,Name from Records;

    SELECT with WHERE clause
    SELECT * from RECORDS where Id=10;

    DELETE
    Delete RECORDS where ID=10;

    ALTER Table
    add postalcode varchar(10)

  • Palwinder

    CREATE TABLE Records
    (ID int(15),
    Name char(25),
    Address Char(60),
    Phone int(10), );
    INSERT:
    INSERT INTO Records
    (ID, Name, Address, Phone),
    VALUE 100, TONI1,(817,walker rd, great falls va 22066);
    UPDTE:
    UPDATE Records
    SET Name=toni,2262 stone wheel dr reston ,va ,22066
    WHERE ID=100;
    SELECT ALL:
    SELECT * Records;
    SELECT ID AND NAME:
    select name, address from records;
    add personal_contact varchar2(27);
    DELETE:
    delete records;
    ALTER TABLE:
    to add column to a table:
    alter table Records

  • Olubunmi Ogunsola

    CREATE TABLE
    (ID(10), Country Char(30),Name Char(45)
    Insert INTO records
    (ID, Country, Name)
    (1, Brazil, Juninho);

    Update Records
    SET Name=Juninho, Brazil
    WHERE ID=1;

    Select all
    SELECT *
    WHERE Country=Brasil;

    Delete
    delete records;

    Alter Table

    Add City varcahr(25);

    – Tomiwa

  • sivi ramesh

    CREATE TABLE Records
    (ID int(20),
    Name char(30),
    Address Char(50),
    Phone int(15), );

    INSERT:

    INSERT INTO Records
    (ID, Name, Address, Phone),
    VALUE (001, Ram, 12941 waterparkview,herndon va, 7032223333);

    UPDTE:
    UPDARE Records
    SET Name=TOM, Address= 12920 sand lake Reston 20168, Phone=5404556666,
    WHERE ID=009;

    SELECT ALL:

    SELECT * Records;

    SELECT ID AND NAME:

    select name, address from records;

    ALTER TABLE:
    to add column to a table:
    alter table Records
    add personal_contact varchar2(40);

    DELETE:
    delete records;

  • Jay

    delete will remove particular record from table, truncate will remove all rows but save table, drop will remove table (table and data will be lost)

Leave a Reply