How do I use the 'INSERT' or 'SELECT' SQL to copy all records from one table to another table, assuming the two tables have the same schema and I have all the privileges?
http://www.experts-exchange.com/Database/Oracle/Q_10035592.html
Zones:
OracleDate Answered: 01/13/1998 Rating: 7.4 Views: 18
How can I copy long data from one table to another?
'Insert as select...' doesn't work if there is a long column in the source table. So I think only option is PL/SQL program.
Any help is welcome...
http://www.experts-exchange.com/Database/Oracle/Q_10124758.html
Zones:
OracleDate Answered: 05/05/1999 Rating: 8.0 Views: 0
We have two Oracle 7.3.4 sites, one master and one replicated. We use asynchronous replication and read-only snapshots. The interconnection is a 128 kbps leased line. The tables are grouped into tw...
http://www.experts-exchange.com/Database/Oracle/Q_10128675.html
Zones:
OracleDate Answered: 05/08/1999 Rating: 5.2 Views: 0
I want to see actual size(in bytes) of the row in a table.
Is it possible. we use oracle 7.3
Kindly help me for this.
Thanks
Saleem
http://www.experts-exchange.com/Database/Oracle/Q_10192170.html
Zones:
OracleDate Answered: 08/20/1999 Rating: 7.0 Views: 0
Hi, Experts
I have a table
every field is char
a 1111
b 2222
b 3333
c 2222
c 3333
c 4444
c 5555
I want to get another result
a 1111
b 2222,3333...
http://www.experts-exchange.com/Database/Miscellaneous/Q_10195860.html
Zones:
DatabasesDate Answered: 01/10/2000 Rating: 5.8 Views: 0
I allways wondered how SQL-Tools can retrieve the names of the DBs tables. Whenever I go into a DB I don't know I have to know the table-names BEFORE I can get any further Informations about them.
...
http://www.experts-exchange.com/Database/Miscellaneous/Q_10196015.html
Zones:
DatabasesDate Answered: 08/23/1999 Rating: 6.8 Views: 0
Is Access 97 or 2000 suited for a sales database containing over 1 millions records? If not, what would you suggest a company use?
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10201035.html
Zones:
MS AccessDate Answered: 09/02/1999 Rating: 5.8 Views: 0
How can we get all table names from a database?
http://www.experts-exchange.com/Database/Oracle/Q_10212378.html
Zones:
OracleDate Answered: 09/29/1999 Rating: 8.2 Views: 0
I'm trying to write some MS Access 2000 VB code that will add records to an MS Access 2000 DB from a text file.
The routine would:
1) Ask the user where the text file is (prob. use MS Common Di...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10218356.html
Zones:
MS AccessDate Answered: 03/09/2002 Rating: 6.6 Views: 0
I was told that if I use a small temporary table it is worthwile to hold it in the cache.
What do I do inorder for this to happen?
http://www.experts-exchange.com/Database/Oracle/Q_10218907.html
Zones:
OracleDate Answered: 10/17/1999 Rating: 7.2 Views: 0
