Home » SQL & PL/SQL » SQL & PL/SQL » how to show total number of department
how to show total number of department [message #582568] Fri, 19 April 2013 08:33 Go to next message
pankajdurve
Messages: 18
Registered: April 2013
Location: MUMBAI
Junior Member
how to show total number of department with their department name assign to employee table.
Re: how to show total number of department [message #582571 is a reply to message #582568] Fri, 19 April 2013 08:47 Go to previous messageGo to next message
Roachcoach
Messages: 1215
Registered: May 2010
Location: UK
Senior Member
http://docs.oracle.com/cd/E11882_01/server.112/e17118/queries002.htm#i2053910

http://docs.oracle.com/cd/E11882_01/server.112/e17118/queries006.htm#i2054012

http://docs.oracle.com/cd/E11882_01/server.112/e17118/functions003.htm#i89203


Those will help you.
Re: how to show total number of department [message #582572 is a reply to message #582568] Fri, 19 April 2013 09:02 Go to previous message
Michel Cadot
Messages: 59289
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And you MUST feedback to people that answer and help you (to do your homework).
If you miss that you will no more have any help.

Regards
Michel
Previous Topic: How to Delete files from EXT Table Dir through SQL PLUS
Next Topic: query to find the number of alphabets
Goto Forum:
  


Current Time: Wed Oct 01 06:46:43 CDT 2014

Total time taken to generate the page: 0.06103 seconds