{\rtf1\ansi\ansicpg1252\cocoartf1038\cocoasubrtf350 {\fonttbl\f0\fswiss\fcharset0 Helvetica;} {\colortbl;\red255\green255\blue255;} \paperw11900\paperh16840\margl1440\margr1440\vieww14520\viewh8460\viewkind0 \pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\ql\qnatural\pardirnatural \f0\fs24 \cf0 set feedback off verify off\ set serveroutput on size 50000 \ \ PROMPT PLEASE GIVE ENTER TICKETID :\ ACCEPT ticket_id\ \ spool login_temp.sql\ DECLARE\ var 1 varchar2(10):= ticket_id;\ BEGIN\ -----Some Logic\'85\ END;\ \ /\ spool off\ set feedback on\ set serveroutput off\ \ --> currently it was asking for all the user who ever logs in. but i want to implement for a particular user.\ \ }