Home » SQL & PL/SQL » SQL & PL/SQL » Sub-Queries , count table name n records
Sub-Queries , count table name n records [message #296925] Tue, 29 January 2008 08:55 Go to next message
adilsami
Messages: 46
Registered: October 2007
Member
hi there,

i need to get the TABLE NAME , TOTAL RECORDS in every table
shown like this using Sub-Queries:

ive found other ways to do that.. but i want to do it using the Sub-Queries ... NEED Help

.....................

Table Name-----Total Records
aaa------------------------- 10

bbb------------------------- 10

ccc------------------------- 11

Re: Sub-Queries , count table name n records [message #296928 is a reply to message #296925] Tue, 29 January 2008 08:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post what you already tried.
Of course the question, why you want to do it with subqueries is silly?

By the way, read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code.
Use the "Preview Message" button to verify.
Always post your Oracle version (4 decimals).

Regards
Michel

[Updated on: Tue, 29 January 2008 09:00]

Report message to a moderator

Re: Sub-Queries , count table name n records [message #296946 is a reply to message #296925] Tue, 29 January 2008 10:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Instead of insulting me in PM, you should answer to my question: why you want to do it with subqueries?

Regards
Michel
Re: Sub-Queries , count table name n records [message #296969 is a reply to message #296946] Tue, 29 January 2008 13:01 Go to previous messageGo to next message
adilsami
Messages: 46
Registered: October 2007
Member
anybody can help with sub-queries ?
Re: Sub-Queries , count table name n records [message #296972 is a reply to message #296969] Tue, 29 January 2008 13:33 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Why?

Show some ways you already found

[Updated on: Tue, 29 January 2008 13:34]

Report message to a moderator

Re: Sub-Queries , count table name n records [message #297024 is a reply to message #296925] Tue, 29 January 2008 23:14 Go to previous message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Why cant you analyse the table and find the result directly from data dictionary views ?

Thumbs Up
Rajuvan.

[Updated on: Tue, 29 January 2008 23:15]

Report message to a moderator

Previous Topic: Doubt in parsing expression using REGEXP_REPLACE
Next Topic: How to convert BLOB to RTF and RTF to BLOB in oracle
Goto Forum:
  


Current Time: Sat Dec 10 18:36:19 CST 2016

Total time taken to generate the page: 0.05576 seconds