Home » SQL & PL/SQL » SQL & PL/SQL » passing varable in a sql statament
passing varable in a sql statament [message #19777] Tue, 09 April 2002 08:03 Go to next message
Anupam
Messages: 62
Registered: July 2001
Member
i m facing a problem
let
var1='>='
and
i want to run sql with this var1
ie
select * from table where sal var1 2000;

how can i do it.
pls help

Report message to a moderator

Re: passing varable in a sql statament [message #19781 is a reply to message #19777] Tue, 09 April 2002 09:41 Go to previous message
Cindy
Messages: 88
Registered: November 1999
Member
Try this:

set SERVEROUTPUT on

DECLARE
var1 varchar2(3);

BEGIN

var1 := '=>';

DBMS_OUTPUT.PUT_LINE(var1);

END;
/

SQL> @a.sql
=>

PL/SQL procedure successfully completed.

Report message to a moderator

Previous Topic: Finding Business days in a month.
Next Topic: How can I create synonyms iteratively ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 22:12:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.