Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ilev
  • Order by date
  1. ilev

    Outer join on like

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

    Create Table error driving me mad!

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

    I can't get these queries?

    sure(to my mind)
  4. ilev

    Method for Using a Reserved Word

    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)...
  5. ilev

    I can't get these queries?

    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...
  6. ilev

    ORACLE_HOME on AIX 4.3.3

    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.

Part and Inventory Search

Back
Top