Member Avatar for hatebin

Hello.

I've got an exaple data base for hr account from Oracle.
My goal is to create a view which contains empno,ename and deptno from EMP, but than i can only add rows with condition deptno=20.

I've cameup with

create or replace view d20emp as
select 
empno as num, 
ename as name, 
deptno as department 
from emp where deptno=20;

Any ideas how to add this cinde of condition ?

  • 2 Contributors
  • 1 Reply
  • 61 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

Your code is perfectly fine.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.