Re: ENTRY LEVEL question

vikram.karmarkar_at_internetMCI.com wrote:
: HELP needed in writtin a PL/SQL proc. which takes a letter as input and
: prints out all the employess(from scott.emp table) whose name has that
: letter as second letter.

select * from emp
where name like '_'||'&&2'||'%'

or
select * from emp
where substr(name,1,2) = '&&2' Received on Sun Jul 28 1996 - 00:00:00 CEST