table creation
Mon May 27 2024 16:28:47 GMT+0000 (Coordinated Universal Time)
Saved by @user02
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 16 08:39:43 2024
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> create table passenger(
2 2 passenger_ID int primary key,
3 3 Ticket_no INTEGER,
4 4 Name varchar(10),
5 5 DOB date,
6 6 sex char(1),address varchar(50));
SP2-0640: Not connected
SQL> connect sys as sysdba
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
SQL> connect sys as sysdba
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
SQL> connect sys as sysdba
Enter password:
Connected.
SQL> create user Tharun identified by tharun;
User created.
SQL> grant dba to Tharun;
Grant succeeded.
SQL> show user;
USER is "SYS"
SQL> connect Tharun;
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> connect Tharun;
Enter password:
Connected.
SQL> spool 'C:\Users\CVR\Desktop\1252'
SQL> create table passenger(
2 2 2 passenger_ID int primary key,
3 3 3 Ticket_no INTEGER,
4 4 4 Name varchar(10),
5 5 5 DOB date,
6 6 6 sex char(1),address varchar(50)
7 ;
2 2 passenger_ID int primary key,
*
ERROR at line 2:
ORA-00904: : invalid identifier
SQL> create table passenger(
2 ;
*
ERROR at line 2:
ORA-00904: : invalid identifier
SQL> create table passenger(
2 2 passenger_ID int primary key,
3 3 Ticket_no INTEGER,
4 4 Name varchar(10),
5 5 DOB date,
6 6 sex char(1),address varchar(50));
2 passenger_ID int primary key,
*
ERROR at line 2:
ORA-00904: : invalid identifier
SQL> create table passenger(
2 passenger_ID int primary key,
3 Name varchar(20),
4 Ticket_No INTEGER,
5 sex char(1),
6 address varchar(50),
7 source varchar(30),
8 destination varchar(30) NOT NULL,
9 DOB DATE,
10 type varchar(3));
Table created.
SQL> insert into passenger(passenger_ID,Name,Ticket_No,type,sex,address,source,destination,DOB)
2 values('e001','tulasi','101','ac','m','Telangana hyderabad bn reddy','JBS','Yamjal',DATE '1980-02-21);
ERROR:
ORA-01756: quoted string not properly terminated
SQL> insert into passenger(passenger_ID,Name,Ticket_No,type,sex,address,source,destination,DOB)
2 values('e001','tulasi','101','ac','m','Telangana hyderabad bn reddy','JBS','Yamjal',DATE '1980-02-21');
values('e001','tulasi','101','ac','m','Telangana hyderabad bn reddy','JBS','Yamjal',DATE '1980-02-21')
*
ERROR at line 2:
ORA-01722: invalid number
SQL> insert into passenger(passenger_ID,Name,Ticket_No,type,sex,address,source,destination,DOB)
2 values(001,'tulasi',101,'ac','m','Telanganahyderabadbnreddy','JBS','Yamjal',DATE '1980-02-21');
1 row created.
SQL> insert into passenger(passenger_ID,Name,Ticket_No,type,sex,address,source,destination,DOB)
2 values(002,'snigdha',102,'nac','f','Telanganahyderabadbnreddy','MGBS','BN reddy',DATE '1984-11-26');
1 row created.
SQL> insert into passenger(passenger_ID,Name,Ticket_No,type,sex,address,source,destination,DOB)
2 values(003,'sherley',103,'ac','f','Telanganahyderabadbnreddy','MGBS','Kalwakurthy',DATE '1985-01-01');
1 row created.
SQL> insert into passenger(passenger_ID,Name,Ticket_No,type,sex,address,source,destination,DOB)
2 values(004,'jangaiah',104,'nac','m','Telanganahyderabadbnreddy','kalwakurthy','Srisailam',DATE '1986-09-13');
1 row created.
SQL> describe;
Usage: DESCRIBE [schema.]object[@db_link]
SQL> describe passenger;
Name Null? Type
----------------------------------------- -------- ----------------------------
PASSENGER_ID NOT NULL NUMBER(38)
NAME VARCHAR2(20)
TICKET_NO NUMBER(38)
SEX CHAR(1)
ADDRESS VARCHAR2(50)
SOURCE VARCHAR2(30)
DESTINATION NOT NULL VARCHAR2(30)
DOB DATE
TYPE VARCHAR2(3)
SQL> select passenger_ID FROM passenger
2 WHERE unique(;)
3 ;
WHERE unique(;)
*
ERROR at line 2:
ORA-00936: missing expression
SQL> select * FROM passenger
2 WHERE UNIQUE(passenger_ID);
WHERE UNIQUE(passenger_ID)
*
ERROR at line 2:
ORA-00936: missing expression
SQL> select * FROM passenger
2 select * FROM passenger;
select * FROM passenger
*
ERROR at line 2:
ORA-00933: SQL command not properly ended
SQL> select Name FROM passenger
2 WHERE sex == 'm';
WHERE sex == 'm'
*
ERROR at line 2:
ORA-00936: missing expression
SQL> select Name FROM passenger
2 WHERE sex = 'm';
NAME
--------------------
tulasi
jangaiah
SQL> select Ticket_No,Name FROM passenger;
TICKET_NO NAME
---------- --------------------
101 tulasi
102 snigdha
103 sherley
104 jangaiah
SQL> ALTER table passenger
2 ADD column timetaken(h);
ADD column timetaken(h)
*
ERROR at line 2:
ORA-00904: : invalid identifier
SQL> ALTER table passenger
2 ADD column timetaken(h) INTEGER;
ADD column timetaken(h) INTEGER
*
ERROR at line 2:
ORA-00904: : invalid identifier
SQL> ALTER table passenger
2 ADD column timetaken INTEGER;
ADD column timetaken INTEGER
*
ERROR at line 2:
ORA-00904: : invalid identifier
SQL> ALTER TABLE passenger
2 ADD timetravel INTEGER;
Table altered.
SQL> insert into passenger(timetravel)
2 values(12);
insert into passenger(timetravel)
*
ERROR at line 1:
ORA-01400: cannot insert NULL into ("THARUN"."PASSENGER"."PASSENGER_ID")
SQL> insert into passenger(passenger_ID,Name,Ticket_No,type,sex,address,source,destination,DOB,timetravel)
2 values(001,'tulasi',101,'ac','m','Telanganahyderabadbnreddy','JBS','Yamjal',DATE '1980-02-21',12);
insert into passenger(passenger_ID,Name,Ticket_No,type,sex,address,source,destination,DOB,timetravel)
*
ERROR at line 1:
ORA-00001: unique constraint (THARUN.SYS_C004028) violated
SQL> select source ,destination FROM passenger;
SOURCE DESTINATION
------------------------------ ------------------------------
JBS Yamjal
MGBS BN reddy
MGBS Kalwakurthy
kalwakurthy Srisailam
SQL> select Name FROM passenger
2 WHERE DOB > 1985-01-01;
WHERE DOB > 1985-01-01
*
ERROR at line 2:
ORA-00932: inconsistent datatypes: expected DATE got NUMBER
SQL> select Name FROM passenger
2 ORDER BY ASC;
ORDER BY ASC
*
ERROR at line 2:
ORA-00936: missing expression
SQL> select Name FROM passenger
2 ORDER BY Name ASC;
NAME
--------------------
jangaiah
sherley
snigdha
tulasi
SQL> select * FROM passenger
2 WHERE type IN('ac','nac');
PASSENGER_ID NAME TICKET_NO S
------------ -------------------- ---------- -
ADDRESS
--------------------------------------------------
SOURCE DESTINATION
DOB TYP
------------------------------ ------------------------------ --------- ---
TIMETRAVEL
----------
1 tulasi 101 m
Telanganahyderabadbnreddy
JBS Yamjal
21-FEB-80 ac
PASSENGER_ID NAME TICKET_NO S
------------ -------------------- ---------- -
ADDRESS
--------------------------------------------------
SOURCE DESTINATION
DOB TYP
------------------------------ ------------------------------ --------- ---
TIMETRAVEL
----------
2 snigdha 102 f
Telanganahyderabadbnreddy
MGBS BN reddy
26-NOV-84 nac
PASSENGER_ID NAME TICKET_NO S
------------ -------------------- ---------- -
ADDRESS
--------------------------------------------------
SOURCE DESTINATION
DOB TYP
------------------------------ ------------------------------ --------- ---
TIMETRAVEL
----------
3 sherley 103 f
Telanganahyderabadbnreddy
MGBS Kalwakurthy
01-JAN-85 ac
PASSENGER_ID NAME TICKET_NO S
------------ -------------------- ---------- -
ADDRESS
--------------------------------------------------
SOURCE DESTINATION
DOB TYP
------------------------------ ------------------------------ --------- ---
TIMETRAVEL
----------
4 jangaiah 104 m
Telanganahyderabadbnreddy
kalwakurthy Srisailam
13-SEP-86 nac
;
1 select * FROM passenger
2* WHERE type IN('ac','nac')
SQL> ^S^A^A;
SP2-0042: unknown command "" - rest of line ignored.
SQL> ;HERE type IN('ac','nac')
1 select * FROM passenger
2* WHERE type IN('ac','nac')
Comments