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
As an overview VB5.0, user can select anyfile from directory and import into any access DB. a listbox will be filled up with the table names. They can import this file into one of the previous ta...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10083292.html
Zones:
Visual BasicDate Answered: 10/29/1998 Rating: 6.2 Views: 0
I have a table with a string field which is 6 characters in length. I want to change it to ten characters.
I need to do this at run time, so please don't suggest using Database Desktop!
Thanks.
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_10086471.html
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
Hi
I am just starting out with some html formatting using cgi.pm in a perl script. I can create a table and insert text into a row, I can set the cell background colour to Black, BUT I can't figure...
http://www.experts-exchange.com/Programming/Languages/Scripting/CGI/Q_10135887.html
Zones:
CGIDate Answered: 03/11/1999 Rating: 8.0 Views: 0
I have a section of code that essentially does the following: (I've mixed both psuedo code and perl together here)
open (SOMEFILE, $afile) or die "blah blah blah\n";
while (<SOMEFILE>)
{
buil...
http://www.experts-exchange.com/Programming/Languages/Scripting/Perl/Q_10145194.html
Zones:
PerlDate Answered: 04/26/1999 Rating: 8.2 Views: 0
hi
i have table1 variable (type TTable) that has fileds, all the fields i used the fileds editor (as usual);
now i have to use this SAME table1 Variable but replace Table1.tablename='asd.db';
th...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_10166927.html
I'm looking for a way to get all the names of tables that are available in a database...I know it can be done because if you set a TTable to use a databse and then go to the tablename property it g...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_10170726.html
I am designing an application where we have two computers connected to a Windows 95 Work group. These two computers run the same application and use the SAME TABLE for Read/Write procedures. The pr...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_10172744.html
