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...

Your Answer:

Login to answer

Other forums

problem with GROUP BY and ORDER BY
i usually use this query to display the last 10 entries from a sql table:

Code: $query = &quo

Help with page encoding issue and weird characters
I'm trying to write a screen scraper and when I pull out the lines of the html file that I'm interes

DirectoryIterator and Hacked Website
Hi Everyone.

My problem:
Some one has been sneaking in to my website hidden Iframes. I've

Perplexing problem showing a .jpg
Please disregard..........I figured it out

some query on multilingual website
Hi all,

Which is the simplest and easiest method to make a website multilingual,
is it put

$_POST
Hi, I have 2 seperate php files, and i want my $_POSt["fname"] To go into both of them, Fo

registration form
first time posting. did some searches but didnt find exactly what i am looking for. dont flame cause

Relative path
I have a absolute path to an image - like so: C:/Program Files/Apache Software Foundation/Apache2.2/

Strange HTML Tag?
I recently noticed some odd HTML appear in some of the websites I host. Not all of them are run on a

FILTER_CALLBACK -- Files?
Hi All,

I'm using the php filter functions to validate my form data. For custom filters, I'm