45,000 Jobs - Get an Interview Call, Post Your Resume Here
SURESHKUMAR.NET FORUMS
Registered Member Login:
Not a member? Register today!



Welcome to the SURESHKUMAR.NET FORUMS.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.


Go Back   SURESHKUMAR.NET FORUMS > TECHNICAL DISCUSSIONS > ORACLE , SQL SERVER , SYBASE & Others -> Oracle...(count no of record in table without using count function)


Oracle...(count no of record in table without using count function)

        

Reply
 
LinkBack Thread Tools Display Modes
Old 11-07-08, 01:08 AM   #1 (permalink)
Junior Member
 
Join Date: Jul 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 2 Srikanta is on a distinguished road
how can u get no. of records in the table without using count function in oracle?
Hi all...
can anyone tell me..how can u get no. of records in the table without using count function in oracle?
just mail me..srikantaparida@gmail.com


Regards
srikanta

Last edited by Srikanta; 15-07-08 at 03:19 PM..
Srikanta is offline Offline   Reply With Quote
Old 13-11-08, 12:22 PM   #2 (permalink)
Junior Member
 
Join Date: Nov 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 2 ka.vetrivel is on a distinguished road
Re: Oracle...(count no of record in table without using count function)
Hi Dear,

try it max(rownum)

select max(row) from table_name

with Regards,

Vetrivel Karuppan
ka.vetrivel is offline Offline   Reply With Quote
Old 17-11-08, 10:37 AM   #3 (permalink)
Junior Member
 
Join Date: Sep 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 3 srikantaparida@gmail.com is on a distinguished road
Re: Oracle...(count no of record in table without using count function)
Hi,
Thanks for reply..


Regards
Srikanta
srikantaparida@gmail.com is offline Offline   Reply With Quote
Reply

Tags
count , function , oraclecount , record , table

« Need material to prepare for OCP | important interview questions for oracle dba »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
ORACLE India - Walk-In For BSc and BCA freshers of 2005 & 2006 (0-2 yrs.) sridhar Walk-ins 2 04-08-08 10:49 PM
ORACLE placement paper 16 sridhar ORACLE Placement Papers 0 09-02-07 07:38 PM
ORACLE placement paper 12 sridhar ORACLE Placement Papers 0 09-02-07 07:23 PM
ORACLE placement paper 11 sridhar ORACLE Placement Papers 0 09-02-07 07:22 PM
ORACLE placement paper 7 sridhar ORACLE Placement Papers 0 09-02-07 06:44 PM


All times are GMT +6.5. The time now is 04:27 PM.




Contact Us - SURESHKUMAR.NET - Archive - Privacy Statement - Top
More Interview Questions Here...

Content Relevant URLs by vBSEO 3.3.0