Oracle 如何创建一个带参数的视图,求大神们帮忙。
select orgtype from sys_org where orgname = (
select org from sys_orgmenber where member = '75' and membertype = 'leader');
帮忙完成用这个语句来创建视图。
select orgtype from sys_org where orgname = (
select org from sys_orgmenber where member = '75' and membertype = 'leader');
帮忙完成用这个语句来创建视图。
select org from sys_orgmenber where member = '75' and membertype = 'leader');试试