Re: @ command does not work in SQL PLUS (OS HP-unix)

  • From: Adric Norris <landstander668@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 8 Feb 2011 08:02:00 -0600

Does the following query return anything?

select * from product_user_profile
   where attribute = '@';

On Tue, Feb 8, 2011 at 7:45 AM, <cbbakshi@xxxxxxx> wrote:

> Hi,
>
> I have a sql file (abc.sql) which contains some code. I am able to run this
> using "run" command as
> SQL> run abc.sql
> 1* select 1 from dual
>
> 1
>
> SQL>
>
> But not able to execute using "@" command. If i execute using @ it just
> return to the SQL prompt without executing this file.
> SQL> @abc.sql
> SQL>
> SQL>
>
> Could you please help me in resolving this issue?
>
> FYI, I m using Oracle 8.1.7.4.0 on HP-unix (Tru64 UNIX V5.1B (Rev. 2650)
> Content of abc.sql is
>
>  select 1 from dual
> /
>
>  Thanks and Regards,
> Chandra
>
>


-- 
"I'm too sexy for my code." -Awk Sed Fred

Other related posts: