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

How to Detect it is public_html or httpdocs?
How to check whether it is cPanel or Plesk?

If it found public_html perform <?php incl

Month String to Numeric?
Hi guys,

Given a month as a string, is there a simple way to find the numeric representation

Php - mysql store data and use it later?
Hi, i' making a login page at the moment, however my username + password is stored many different pl

Undefined offset when using a flat file with pipe symbols
Hi, I've got a flat file/text file which I'm currently using as a member database for my site (not a

php/xmlrpc class issue
I am working on xml-rpc in php to start with.

I have a class that only has variables defined

Convert Binary String to Decimal
Trying to Get:
Decimal: 305419896

Out of:
Binary String: xV4

classic dynpro : hide area and auto adjust hights
Hi,

I want to develop a similar user interface as is used in standard transaction MIGO.

Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I

use an array from 1 class in a second class
I have a class that adds data to an array

Then I have a second class and I need to check if t

Create or replace package is ending ORA-21700
Database 9.2.0., patch 8 (9.2.0.8.0).
I trying run
create or replace package ....etc.