Guest User

Untitled

a guest
May 23rd, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. -- Is there any way to use a sequence within a view? This doesn't work
  2. create or replace view test_view
  3. (person_id, first_name, last_name, age)
  4. as
  5. select seq_sr_info_id.nextval, first_name, last_name, age
  6. from some_table
Add Comment
Please, Sign In to add comment