select statement

priya2k6 · 10-07-06, 04:39 PM

hi,

i have doubt regarding the select statement. some select query after the resultset displays "the no. of rows selected", but some select statement doesnot return the rows selected caption.

wat is the difference between about two?

Priya

rachana · 10-07-06, 05:26 PM

Hi Priya,

That is very keep observation, even i need the clarification, can any one help us.......

**sk_kireeti** · 11-07-06, 01:27 AM

Hi Priya / Rachana,

This behaviour can be controlled by the SQL*PLUS functions.

Try the followng -

SET FEEDBACK 1

Now, you will see that message even when 1 row is returned from you query.

But default, it will be set as below -

SET FEEDBACK 6

This means, if the number of rows returned were more than 6, then only it will tell you how many rows were selected.

Hope I answered your query.

NOTE - This functinality is specific to SQL*PLUS. If you use any other tools to access oracle DB, you will not find this command.

Thanks,
Krishna

Edited by: sk_kireeti

10-07-06, 04:39 PM	#1 (permalink)
priya2k6 Junior Member Join Date: Feb 2006 Location: India Posts: 31 Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 4	hi, i have doubt regarding the select statement. some select query after the resultset displays "the no. of rows selected", but some select statement doesnot return the rows selected caption. wat is the difference between about two? Priya
Offline

10-07-06, 05:26 PM	#2 (permalink)
rachana Senior Member Join Date: Jun 2006 Location: India Posts: 114 Thanks: 0 Thanked 2 Times in 2 Posts Rep Power: 7	Hi Priya, That is very keep observation, even i need the clarification, can any one help us....... __________________ A PEACEFUL MIND ALWAYS GENERATES POWER
Offline

11-07-06, 01:27 AM	#3 (permalink)
sk_kireeti Super Moderator Join Date: Feb 2006 Posts: 2,379 Blog Entries: 4 Thanks: 118 Thanked 319 Times in 238 Posts Rep Power: 60	Hi Priya / Rachana, This behaviour can be controlled by the SQLPLUS functions. Try the followng - SET FEEDBACK 1 Now, you will see that message even when 1 row is returned from you query. But default, it will be set as below - SET FEEDBACK 6 This means, if the number of rows returned were more than 6, then only it will tell you how many rows were selected. Hope I answered your query. NOTE - This functinality is specific to SQLPLUS. If you use any other tools to access oracle DB, you will not find this command. Thanks, Krishna Edited by: sk_kireeti __________________ Looking for trainees for a start up company
Offline

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)