Is there any way to get the table name,number of rows in the table, for all the tables in the database with a single query
http://www.experts-exchange.com/Database/Oracle/Q_20128833.html
Zones:
OracleDate Answered: 05/29/2002 Grade: A Views: 0
I have written a simple query that returns the ID and name from either of two tables. What I need is to also know which table the name came from. How can I modify the query below so that the tabl...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20156893.html
Zones:
MS AccessDate Answered: 07/25/2001 Grade: A Views: 0
I cannot access any table with the $ sign in its name. I can only access it from MS access and linking the table but not from PL SQL prompt and not from VB.net using DSN.
Any one has an idea on wh...
http://www.experts-exchange.com/Database/Oracle/Q_21648596.html
Zones:
OracleDate Answered: 12/09/2005 Grade: A Views: 0
Here's your chance to help my mental block!
For example: I have a User table. I have a Department table which represents names for groups of users. I have a table called Department_User wh...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21735463.html
Zones:
MS AccessDate Answered: 02/15/2006 Grade: A Views: 0
I'm getting the following error message when I parse the below script:
"Invalid column prefix 'master.': No table name specified"
Here is my sample code:
DECLARE @DB VARCHAR (50)
declare ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22737833.html
While inside a trigger I'd like to be able to insert into a table in a different database where the database is variable.
The use of EXEC does not work since "inserted" is local scope to the trigg...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10186013.html
I have 3 tables in my database(EMP, DEPT, SALGRADE), what is the statement that would show me, in my SQL command prompt window these tables(Note: not the table contents or description, only the tab...
http://www.experts-exchange.com/Database/Oracle/Q_10215639.html
Zones:
OracleDate Answered: 01/11/2000 Grade: C Views: 0
Hi everyone!
I was wondering if someone can help me do this task:
I have to create a job that runs every 1st day of year and does:
Copy the contens of a table into a table named backup_YYYY wh...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11369098.html
I have a schema called jagan, which has 1000 tables in it. I need to get a list of all tables and count(*) from those tables in the following format.
TABLE_NAME COUNT
--------------------- ...
http://www.experts-exchange.com/Database/Oracle/Q_11510118.html
Zones:
OracleDate Answered: 10/11/2000 Grade: A Views: 0
How to use multiple cursors in a pl/sql program?Can anybody give me example of a pl/sql program or a function?
My requirement is :
I have 150 tables in my database. I want to delete some of the r...
http://www.experts-exchange.com/Database/Oracle/Q_20246548.html
Zones:
OracleDate Answered: 06/13/2002 Grade: A Views: 0
