How to write a function or procedure that verify the correct email id entered by the user??
Type: Posts; User: sr_2407; Keyword(s):
How to write a function or procedure that verify the correct email id entered by the user??
my Query for this is as follows,
select * from dept
where rownum<=(select count(*)-1 from dept)
Here is my solution for ur query
try this.......
select * from
(select rownum, e.* from dept e order by rownum desc )
where rownum<=3