File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Joined: Nov 07, 2003
Mar 07, 2004 23:49:00
I wanna create a table by fetching columns from two other tables?
I wanna create a 3rd table with the following fields
Any kind of help will be appreciable?
Joined: Feb 05, 2001
Mar 08, 2004 10:09:00
Actually Oracle makes it very simple. You can create a table from a query as in
CREATE TABLE myTable AS SELECT tableA.fieldA, tableB.fieldB FROM tableA, tableB WHERE tableA.primaryKey = tableB.foreignKey
Hope that helps.
Perfect World Programming, LLC
How to Ask Questions the Smart Way FAQ
I agree. Here's the link:
subject: create table!
part2 ~ study group
Proceeding to Part2
SCEA Part2 (Use Case)
Procedure for applying SCEA part2
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015