Scribd
Upload
4 views3 pages

SQL Categories: Conn System System User Create User Alter Grant Privileges

The document outlines various SQL data types, including character, number, and date types, along with their maximum lengths. It categorizes SQL commands into DDL, DML, TCL, DQL, and DCL, detailing operations like creating, altering, and manipulating data. Additionally, it mentions functions for single and multiple rows, providing examples of their usage.

Uploaded by

5147sharmista
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views3 pages

SQL Categories: Conn System System User Create User Alter Grant Privileges

The document outlines various SQL data types, including character, number, and date types, along with their maximum lengths. It categorizes SQL commands into DDL, DML, TCL, DQL, and DCL, detailing operations like creating, altering, and manipulating data. Additionally, it mentions functions for single and multiple rows, providing examples of their usage.

Uploaded by

5147sharmista
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

SQL

conn
system
system
user create
user alter
grant privileges

1. character datatypes -

max length 2000(Can be fixed.)

varchar - max length 4000(Variable

Clob

[Link] data types

number

blob

float

DATE

TIMESTAMP

SQL categories
DDL (Data definition language)

alter

drop

flashback

purge

SQL 1
comment

truncate

DML(data manipulation language)


insert- 1 without specifying column names (insert into tpces values(’a’));

2 with specifying column names (insert into tpces(snames)


values(’c’));
3 multiple rows in one table(insert all into tpces values(’d’))
into tpces values (’e’)
select *from dual;
4 insert all into tpces values(’h’)
into tps values(’i’)
into tpces values(’j)
select *from dual;

update - update tpces set name =’sharmista’ where name =’a’;

delete - delete from tpces where name

TCL- transaction control language


1 commit

2 rollback
3 savepoint

DQL - data query language/data retrieval language


select *from tablename;

SQL 2
DCL - data control language
1. Grant

2. revoke- revoke all privileges from

functions
single row
upper

lower

initcap

select upper(’sharmista’) from dual;

Multi row functions


multiple rows displayed in a single row.

SQL 3

You might also like