比如一视图如下
CREATE OR REPLACE VIEW V_ORG AS
SELECT ORG.ORGANIZATIONID,
ORG.NAME AS ORGANIZATIONNAME,
ORG.PARENTORGANIZATIONID AS PARENTID
FROM ORGANIZATION_ ORG
现在我想把(111,hah,222)这行数据合并到视图里,这一行从ORGANIZATION_查不到,也不是从别的表里查的,算特殊值吧,这个union all该怎么写哈
CREATE OR REPLACE VIEW V_ORG AS
SELECT ORG.ORGANIZATIONID,
ORG.NAME AS ORGANIZATIONNAME,
ORG.PARENTORGANIZATIONID AS PARENTID
FROM ORGANIZATION_ ORG
现在我想把(111,hah,222)这行数据合并到视图里,这一行从ORGANIZATION_查不到,也不是从别的表里查的,算特殊值吧,这个union all该怎么写哈
解决方案 »
- oracle与mysql如何互连
- sys_connect_by_path连接的字符串顺序反了?
- win7 64 sqlplus ORA-12154 TNS:无法解析指定的连接标识符
- ?关于oracle的监听器的问题。谢谢
- crontab
- 急,如何实现两台机器两个数据库的自动刷新?
- 大师接招
- 请教高人给写个oralce查询语句.
- 对于除了select * from table_name for update wait以外,其他的SQL语句有没有for update wait子句
- 高手请进,急急急!
- 如何提高oracle 插入效率?
- 用C#调用事务修改数据时报错ORA-24784: 事务处理已存在
INSERT INTO ORGANIZATION_ VALUES ('222','li lei',333);
INSERT INTO ORGANIZATION_ VALUES ('333','han mei mei',444);CREATE OR REPLACE VIEW V_ORG AS
SELECT ORG.ORGANIZATIONID,
ORG.NAME AS ORGANIZATIONNAME,
ORG.PARENTORGANIZATIONID AS PARENTID
FROM ORGANIZATION_ ORG
UNION ALL
SELECT '111' ORGANIZATIONID,'hah' ORGANIZATIONNAME,'222' PARENTID FROM dual;SELECT * FROM V_ORG;result:
ORGANIZATIONID ORGANIZATIONNAME PARENTID
000 niu xiong 111
222 li lei 333
333 han mei mei 444
111 hah 222
SELECT ORG.ORGANIZATIONID,
ORG.NAME AS ORGANIZATIONNAME,
ORG.PARENTORGANIZATIONID AS PARENTID,
111,hah,222
FROM ORGANIZATION_ ORG
SELECT ORG.ORGANIZATIONID,
ORG.NAME AS ORGANIZATIONNAME,
ORG.PARENTORGANIZATIONID AS PARENTID
FROM ORGANIZATION_ ORG
UNION ALL
SELECT '111' ORGANIZATIONID,'hah' ORGANIZATIONNAME,'222' PARENTID FROM dual;
SELECT ORG.ORGANIZATIONID,
ORG.NAME AS ORGANIZATIONNAME,
ORG.PARENTORGANIZATIONID AS PARENTID
FROM ORGANIZATION_ ORG
UNION ALL
SELECT '111' ,'hah' ,'222' FROM dual;