basic sql information

SIMLE QUERY use in sql

spool g:/database/oracle/first  // save in given path

commit;//save outomatic

show pagesize;disply  pagesige

set pagesize (value);set pagesige

show linesige;show linsize

set linesize (value);set linesize

SELECT *FROM TAB;list of table

DESC tablename;Given structure

SELECT *FROM tablename; Information of define table

CQL++

·                Cql++  is editor

·                It have many user accesses all data at a time

·                Provide more  flexibility then sql

·                Database can be shared in efficient manner

DATA TYPE ->

1.           NUMBER

·                Used to store floating(real) or negative or positive value

·                Precisions can be up to 38 digit

2.           CHAR

·                Store character string or fix length

·                Maximum length is 255.

      3     VARCHAR

·                More flexible then character

·                Maximum length is 255

4                  VARCHAR2

·                it’s length is 2000

·                no default size will be consider

·                size must be specified

·                it is lover to accesses

5                  DATE

·                used to store date &time

·                standard format of   date is DD-MM-YY

6                  RAW

·                store binary type data

·                maximum size is up to 255 bytes

7                  LONG RAW

·                store large amount of binary type data

·                maximum length is up to 2 gb

SIMPLE SYNTEX USED IN SQL:

NEW CREATE TABLE-

CREATE TABLE tablename (columname1 datatype(size));

INSERT DATA/VLUES

INSERT INTO tablename values(‘&columname1’,’&columname2’);

View data in table

ALL ROW AND ALL COLOUM

SELECT *FROM tablename;

SELECTED COLOUM & ALL ROW

SELECT coloumname1,coloumname2 FROM tablename;

SELECTED ROW&ALL COLOUM

SELECT *FROM tablename WHERE condition;

SELECTED COLOUM&SELECTD ROW

SELECT coloumname1,coloumname2 FROM tablename WHERE condition;

UPDATE ROW/

UPDATE tablename SET coloumname= expretion WHERE condition;

MODIFY TABLE(coloum)

ALTERTABLE tablename MODIFY (coloumname newdatatype(size));

DROP COLOUM

ALTERTABLE tablenme DROPCOLOUM coloumname;

ADDNEW COLOUM

ALTERTABLE tablename ADD (coloumname datatype(size));

TRUNCATE &DELET

DROPTABLE tablename;

TRUNCATETABLE tablename;

DUPLICATE NOT SHOW

SELECT DISTINC coloumnme  FROM tablename;

ASCENDING/DESCENDING

SELECT *FROM tablename ORDER BY coloumname(order);//desc  --asce

DELETE PERTICULAR ROW

DELETE FROM tablename WHERE condition;

CREATE TABLE FROM ANOTHER TABLE

CREATE TABLE newtablename (coloumnamename1,coloumnname2)AS SELECT coloumnname1,coloumnname2 FROM oldtablename WHERE condition;    // where condition is use particular row have

INSERTING DATA INTO TABLE FROM ANOTHER TABLE

INSERT INTO newtablename (coloumname1,coloummname2) SELECT  coloumname1,coloumname2 FROM oldtablename WHERE condition;