Home » SQL & PL/SQL » SQL & PL/SQL » Simple question - displaying value of a variable
Simple question - displaying value of a variable [message #7663] Sat, 28 June 2003 04:24 Go to next message
Rajeev Katyal
Messages: 55
Registered: April 2002
Member
I have got a small question..
Like i am getting the value in a variable from a cursor.

Suppose c1 is cursor name and c1.ename contains the names of employees and i just want to display the names of employees i.e. the value of c1.ename

what should i be writting ?
prompt c1.ename or something else
in an pl/sql block.

Pls help.

Report message to a moderator

Re: Simple question - displaying value of a variable [message #7666 is a reply to message #7663] Sat, 28 June 2003 12:39 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
 
dbms_output.put_line(c1.ename);


Make sure you have SET SERVEROUTPUT ON in SQL*Plus first.

Report message to a moderator

Previous Topic: sql command to find out number of columns in a tiger
Next Topic: SQL*Plus and IF Logic
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 07 03:40:17 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.