Home » SQL & PL/SQL » Client Tools » not to display first two columns
not to display first two columns [message #246795] Fri, 22 June 2007 00:50 Go to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member

create table xx(id number(4),name varchar2(20);
insert into xx values(1,'aa');
insert into xx values(1,'bb');
insert into xx values(2,'cc');
insert into xx values(3,'gg');
insert into xx values(4,'uu');







i dont want to display the fist two rows of this table

so,


declare
cursor c1 is select name from xx where id=1 and rownum not in(1,2);
begin
 dbms_output.put_line('begun');
 for rec in c1 loop
  dbms_output.put_line(rec.name);

end loop;

end;




but this is not working, how to make sure i dont retrieve
the first two rows of this table??

Re: not to display first two columns [message #246797 is a reply to message #246795] Fri, 22 June 2007 00:52 Go to previous messageGo to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
ok atlest forget about the where part of the cursor,
i dont want to see the first two rows of the table

can anyone please help
Re: not to display first two columns [message #246798 is a reply to message #246795] Fri, 22 June 2007 00:56 Go to previous messageGo to next message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
I have a basket full of apples.
Which apples in the basket are NOT the 1st two apples?
Your problem statement is nonsensical.
>i dont want to see the first two rows of the table
>not to display first two columns
Please clarify 1st 2 colunms or 1st 2 rows?

[Updated on: Fri, 22 June 2007 01:00] by Moderator

Report message to a moderator

Re: not to display first two columns [message #246799 is a reply to message #246795] Fri, 22 June 2007 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Define "the first two rows of this table".

Regards
Michel
Re: not to display first two columns [message #246817 is a reply to message #246795] Fri, 22 June 2007 01:43 Go to previous messageGo to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
SQL> SET UNDERLINE ON
SQL> @my
Enter value for fi_shortname: SS
Enter value for fi_shortname: SS
Enter value for fi_shortname: SS

FI Name   Customer Name  User Name
--------------------------------------------
"INTFI73","GCUST13","CUSER1"
"INTFI73","GCUSTCORP1","CUSERSB1"
"INTFI73","CUST_CORP1","DUPUSER1"
"INTFI73","CUST_CORP2","DUPUSER2"
"INTFI73","GCUST12","CUSER1"
"INTFI73","GCUSTSB1","CUSERSB1"
"INTFI73","CUST_SB1","DUPUSER1"
"INTFI73","CUST_SB2","DUPUSER2"





i dont want to see the column headers and the underline
as i am saving this as a report...in another program

i am getting the data via a cursor (similare to the one i
showed above).in which a column has all this data

i dont want the first 2 rows of the "data", meaning the
col header and underline
Re: not to display first two columns [message #246820 is a reply to message #246795] Fri, 22 June 2007 01:48 Go to previous messageGo to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
in a temporary table, the data is already stored in the
above format, i just want to exclude the top 2 rows
meaning the header and underline
Re: not to display first two columns [message #246823 is a reply to message #246795] Fri, 22 June 2007 01:53 Go to previous messageGo to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
the col header and underline is a part of data
Re: not to display first two columns [message #246824 is a reply to message #246817] Fri, 22 June 2007 01:53 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
set heading off

Regards
Michel
Previous Topic: Report in SQLPLUS
Next Topic: spool without user respons
Goto Forum:
  


Current Time: Tue Dec 06 08:47:40 CST 2016

Total time taken to generate the page: 0.05483 seconds