Problem : Divide a given string into individual characters and display these characters into separate rows through a SQL query. For example , the given string is 'Paper', display it as :
Given_String
--------
P
a
p
e
r
The query is :
select substr(&string,rownum,1) given_string
from all_objects
where rownum<=length(&string)
no salary should be 25x higher than the lowest salary
-
This is common sense How to enforce this in a recent Oracle version? create
assertion x25 check (not exists(select * from emp e where sal*25<any(select
sal...
2 days ago

No comments:
Post a Comment