Recent content by ilev

Hi Fraser! What about my exaple? select ename from emp,dept where emp.ename like substr(dept.loc,1,1)||'%';

Comma is right, but i recommend to create table partly, to add 5 rows. Column names like TITLE or INITIALS are suspect.

sure(to my mind)

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.