Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 19 10:32:52 2019
- Copyright (c) 1982, 2005, Oracle. All rights reserved.
- SQL> create user parish identified by parish;
- SP2-0640: Not connected
- SQL> grant dba
- 2 grant dba;
- SP2-0640: Not connected
- SQL> connect sys as sysdba;
- Enter password:
- Connected.
- SQL> create table emp(empid int, ename varchar(50), title varchar(50), salary do
- uble, deptno int, mgrname varchar(50));
- create table emp(empid int, ename varchar(50), title varchar(50), salary double,
- deptno int, mgrname varchar(50))
- *
- ERROR at line 1:
- ORA-00905: missing keyword
- SQL> create table emp(empid number(10), ename varchar2(50), title varchar2(50),
- salary number(50), deptno number(10), mgrname varchar2(50));
- create table emp(empid number(10), ename varchar2(50), title varchar2(50), salar
- y number(50), deptno number(10), mgrname varchar2(50))
- *
- ERROR at line 1:
- ORA-01727: numeric precision specifier is out of range (1 to 38)
- SQL> create table emp(empid number(10), ename varchar2(50), title varchar2(50),
- salary number(10), deptno number(10), mgrname varchar2(50));
- Table created.
- SQL> insert into emp values(1,'Sabin','CSIT',500,7,'Parish');
- 1 row created.
- SQL> select *from emp
- 2 select *from emp;
- select *from emp
- *
- ERROR at line 2:
- ORA-00933: SQL command not properly ended
- SQL> select *from emp where empid=1;
- EMPID ENAME
- ---------- --------------------------------------------------
- TITLE SALARY DEPTNO
- -------------------------------------------------- ---------- ----------
- MGRNAME
- --------------------------------------------------
- 1 Sabin
- CSIT 500 7
- Parish
- SQL> insert into emp values(2,'Rajnish','CSIT',500,7,'Parish');
- 1 row created.
- SQL> insert into emp values(3,'Subodh','CSIT',800,7,'Parish');
- 1 row created.
- SQL> insert into emp values(4,'Pemba','CSIT',100,7,'Parish');
- 1 row created.
- SQL> insert into emp values(5,'Rabindra','CSIT',50,7,'Parish');
- 1 row created.
- SQL> commit;
- Commit complete.
- SQL> select ename,salary*12,&sabin from emp;
- Enter value for sabin: rajnish
- old 1: select ename,salary*12,&sabin from emp
- new 1: select ename,salary*12,rajnish from emp
- select ename,salary*12,rajnish from emp
- *
- ERROR at line 1:
- ORA-00904: "RAJNISH": invalid identifier
- SQL> select ename,salary*12,&sabin from emp;
- Enter value for sabin: deptno
- old 1: select ename,salary*12,&sabin from emp
- new 1: select ename,salary*12,deptno from emp
- ENAME SALARY*12 DEPTNO
- -------------------------------------------------- ---------- ----------
- Sabin 6000 7
- Rajnish 6000 7
- Subodh 9600 7
- Pemba 1200 7
- Rabindra 600 7
- SQL> select ename, &ram from emp where empid<3;
- Enter value for ram: mgrname
- old 1: select ename, &ram from emp where empid<3
- new 1: select ename, mgrname from emp where empid<3
- ENAME
- --------------------------------------------------
- MGRNAME
- --------------------------------------------------
- Sabin
- Parish
- Rajnish
- Parish
- SQL> select ename, &ram from emp where &condition;
- Enter value for ram: salary
- Enter value for condition: ename=Sabin
- old 1: select ename, &ram from emp where &condition
- new 1: select ename, salary from emp where ename=Sabin
- select ename, salary from emp where ename=Sabin
- *
- ERROR at line 1:
- ORA-00904: "SABIN": invalid identifier
- SQL> select ename, &ram from emp where &condition;
- Enter value for ram: mgrname
- Enter value for condition: ename='Sabin'
- old 1: select ename, &ram from emp where &condition
- new 1: select ename, mgrname from emp where ename='Sabin'
- ENAME
- --------------------------------------------------
- MGRNAME
- --------------------------------------------------
- Sabin
- Parish
- SQL> select ename, salary from emp where &condition;
- Enter value for condition: deptno=7
- old 1: select ename, salary from emp where &condition
- new 1: select ename, salary from emp where deptno=7
- ENAME SALARY
- -------------------------------------------------- ----------
- Sabin 500
- Rajnish 500
- Subodh 800
- Pemba 100
- Rabindra 50
- SQL> select ename, salary, &&condition from emp where &condition;
- Enter value for condition: empid=2
- old 1: select ename, salary, &&condition from emp where &condition
- new 1: select ename, salary, empid=2 from emp where empid=2
- select ename, salary, empid=2 from emp where empid=2
- *
- ERROR at line 1:
- ORA-00923: FROM keyword not found where expected
- SQL> select ename, salary, &&sanget from emp order by &sanget;
- Enter value for sanget: empid
- old 1: select ename, salary, &&sanget from emp order by &sanget
- new 1: select ename, salary, empid from emp order by empid
- ENAME SALARY EMPID
- -------------------------------------------------- ---------- ----------
- Sabin 500 1
- Rajnish 500 2
- Subodh 800 3
- Pemba 100 4
- Rabindra 50 5
- SQL> select ename, salary, &&sanget from emp order by &sanget;
- old 1: select ename, salary, &&sanget from emp order by &sanget
- new 1: select ename, salary, empid from emp order by empid
- ENAME SALARY EMPID
- -------------------------------------------------- ---------- ----------
- Sabin 500 1
- Rajnish 500 2
- Subodh 800 3
- Pemba 100 4
- Rabindra 50 5
- SQL> select ename, salary, &&sanget from emp order by &sanget;
- old 1: select ename, salary, &&sanget from emp order by &sanget
- new 1: select ename, salary, empid from emp order by empid
- ENAME SALARY EMPID
- -------------------------------------------------- ---------- ----------
- Sabin 500 1
- Rajnish 500 2
- Subodh 800 3
- Pemba 100 4
- Rabindra 50 5
- SQL> select ename, salary, &&sang from emp order by &sang;
- Enter value for sang: salary
- old 1: select ename, salary, &&sang from emp order by &sang
- new 1: select ename, salary, salary from emp order by salary
- select ename, salary, salary from emp order by salary
- *
- ERROR at line 1:
- ORA-00960: ambiguous column naming in select list
- SQL>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement