Notes

Write a Microsoft Windows [Version 10.0.18362.592]
(c) 2019 Microsoft Corporation. All rights reserved.

C:UsersIctSupport> sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Wed Jan 29 04:01:31 2020

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Enter user-name: system
Enter password:

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> connect
Enter user-name: system
Enter password:
Connected.
SQL> create user shubhankar identified by rajput;

User created.

SQL> grant all privilegs to shubhankar
2
SQL> grant all privilegs to shubhankar:
2
SQL> grant all privilegs to shubhankar;
grant all privilegs to shubhankar
*
ERROR at line 1:
ORA-00990: missing or invalid privilege


SQL> grant all privilgs to shubhankar;
grant all privilgs to shubhankar
*
ERROR at line 1:
ORA-00990: missing or invalid privilege


SQL> grant all privilges to shubhankar;
grant all privilges to shubhankar
*
ERROR at line 1:
ORA-00990: missing or invalid privilege


SQL> grant all privileges to shubhankar;

Grant succeeded.

SQL> create table stud1(roll number(3), name varchar(20), city varchar(20), age number(2), cgpa number(2,3));

Table created.

SQL> insert into stud1 values(101, 'Ram', 'Bhubaneshwar', 19, 9.0);
insert into stud1 values(101, 'Ram', 'Bhubaneshwar', 19, 9.0)
*
ERROR at line 1:
ORA-01438: value larger than specified precision allowed for this column


SQL> create table stud1(roll number(3), name varchar(20), city varchar(20), age number(2), cgpa number(3,2));
create table stud1(roll number(3), name varchar(20), city varchar(20), age number(2), cgpa number(3,2))
*
ERROR at line 1:
ORA-00955: name is already used by an existing object


SQL> drop table sql1
2
SQL> drop table sql1;
drop table sql1
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> drop table stud1;

Table dropped.

SQL> create table stud1(roll number(3), name varchar(20), city varchar(20), age number(2), cgpa number(3,2));

Table created.

SQL> insert into stud1 values(101, 'Ram', 'Bhubaneshwar', 19, 9.0);

1 row created.

SQL> insert into stud1 values(102, 'Hari', 'Bhubaneshwar', null, 6.7);

1 row created.

SQL> insert into stud1 values(103, 'Uday', 'jharkhand', 20, 8.97);

1 row created.

SQL> insert into stud1 values(104, 'Vikas', 'Uttar Pradesh', 19, 8.5);

1 row created.

SQL> insert into stud1 values(105, 'Sweta', 'Ranchi', 19, 9.2);

1 row created.

SQL> select * from stud1
2
SQL> select * from stud1;

ROLL NAME CITY AGE CGPA
---------- -------------------- -------------------- ---------- ----------
101 Ram Bhubaneshwar 19 9
102 Hari Bhubaneshwar 6.7
103 Uday jharkhand 20 8.97
104 Vikas Uttar Pradesh 19 8.5
105 Sweta Ranchi 19 9.2

SQL> select name, age from stud1;

NAME AGE
-------------------- ----------
Ram 19
Hari
Uday 20
Vikas 19
Sweta 19

SQL> select name, age+2 from stud1;

NAME AGE+2
-------------------- ----------
Ram 21
Hari
Uday 22
Vikas 21
Sweta 21

SQL> select name, age, age+2 from stud1;

NAME AGE AGE+2
-------------------- ---------- ----------
Ram 19 21
Hari
Uday 20 22
Vikas 19 21
Sweta 19 21

SQL> select name||city from stud1;

NAME||CITY
----------------------------------------
RamBhubaneshwar
HariBhubaneshwar
Udayjharkhand
VikasUttar Pradesh
SwetaRanchi

SQL> select name||''||city from stud1;

NAME||''||CITY
----------------------------------------
RamBhubaneshwar
HariBhubaneshwar
Udayjharkhand
VikasUttar Pradesh
SwetaRanchi

SQL> select name||' '||city from stud1;

NAME||''||CITY
-----------------------------------------
Ram Bhubaneshwar
Hari Bhubaneshwar
Uday jharkhand
Vikas Uttar Pradesh
Sweta Ranchi

SQL> select * from stud1 where city='Bhubaneshwar';

ROLL NAME CITY AGE CGPA
---------- -------------------- -------------------- ---------- ----------
101 Ram Bhubaneshwar 19 9
102 Hari Bhubaneshwar 6.7

SQL>