| |

VerySource

 Forgot password?
 Register
Search
View: 24|Reply: 1

Urgent: Why is there an error in the statement when there is UNION when creating a view?

[Copy link]

1

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-1-13 12:40:01
| Show all posts |Read mode
create or replace view v_all_limit
as
(


 select * from all_limit
 union
  select * from all_limit2

)
Reply

Use magic Report

0

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 Australia

Post time: 2020-1-23 14:09:01
| Show all posts
create or replace view v_all_limit
as



 select * from all_limit
 union
  select * from all_limit2
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list