In my Oracle 8.0.6 I can create table and view with column
name VALUE , bot not VALUES.
create table aaa (code varchar(5), value number);
Table created.
create view ddd as select code,value,empno from emp,aaa;
View created.
create table aaa (code varchar(5), values number)...
6-1 Write a query to display the employeee name and hire date
or all employees in the same department as Blake. Exclude
Blake.
select ename, hiredate
from emp
Where deptno in -- May be Blake not in one depart
(select deptno...
I think you can put all your env in .cshrc
(if you use csh )
ORACLE_HOME, add to path $ORACLE_HOME/bin
ORACLE_SID and you can use TWO_TASK too.
You can create script with all these statments and
to run it when you need it.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.