Count number of records in all the tables with a querry URGENT PLEASE...


Posted on 16th Feb 2014 07:03 pm by admin

I downloaded ORACLE 9I DATA DUMP into my comp. There are number of tables. I need to find out the tables with records more than say 100 or so at on go. Can it be possible... If so kindly let me know.

Secondly, from the database which I downloaded I found out that Audit_ Trial was not enabled by firing
"select name,value from v$parameter
where name like 'audit%' and it turned out to be false.
Can we take it for granted that in the database in the server also the audit_trial has been disabled...

No comments posted yet

Your Answer:

Login to answer
315 Like 27 Dislike
Previous forums Next forums
Other forums

How to use php and sql to check if values match the ones in a table (for logins)
How would I code it that the script takes two variables that are passed to it (UserID and PIN), and

HTML Viewer HIDE scrollbar
How can I disable scrollbars in a HTML Viewer control? I can't hide them. Even i have enough space b

calendar dates and hours compare problem
i have a calendar in wordpress, everything works great except that i can make 2 meetings at the same

Entering Data Problem
Code: $result = mysql_query("SELECT * FROM flights");
while ($row = mysql_fetch_array($

FFmpeg Images 2 Video conversion problem ??
I got folder full of images , number of images = 600 , I want to make a video which plays one image

Multiple while loops
I have several DB queries that I know should be returning results and aren't. I have a feeling it ha

multiple recipients + dbuser mail recall
Hello,

I am building a php login script.

When the user registers the script will send

To change the name of label on SAP screen XK02.
Hi All,

Can one suggest me how to change the label of an input field of a sap standard s

What exactly is net neatrality?
What exactly is it? I think it's anti-censorship and... stuff... but I don't really understand it

URL Rewrite issue
Im created a series of Rewrites and on page checks to make sure the correct url is being called. But

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash