Forums.Sureshkumar.net : A Perfect Place to Share Knowledge         Blogs     Games    Magazines    

"Sharing knowledge does not lessen your store, often it gets you more. Sharing plays a key role in relationships and bonding, happens in small steps and is assisted through community membership."

Go Back   SURESHKUMAR.NET FORUMS > TECHNICAL DISCUSSIONS > ORACLE , SQL SERVER , SYBASE & Others
Register FAQ Members List Calendar Games Blogs Search Today's Posts Mark Forums Read

   

Reply
 
LinkBack Thread Tools Rating: Thread Rating: 5 votes, 5.00 average. Display Modes
Old 11-07-08, 02:08 AM   #1 (permalink)
Junior Member
 
Join Date: Jul 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 1 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 04:19 PM.
Srikanta is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 1 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  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 2 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  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



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

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 11: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 10:06 PM.





Search Engine Optimization by vBSEO 3.1.0