| Creating Tables & Inserting [message #67934] |
Fri, 19 July 2002 07:52  |
Alexi Brown
Messages: 1
Registered: July 2002
|
Junior Member |
|
|
Can I create a table with a view in OEM?
If so, how (e.g. CREATE TABLE xyz AS (SELECT blah, blah)?
If not, then how do I create a new table in OEM?
Can I drop the contents of a table in a view in OEM and then add new data (e.g. through an INSERT statement)?
If so, how?
Please feel free to reply to any part of this posting. I'm just getting started.
|
|
|
|
|
|
| Re: Creating Tables & Inserting [message #67945 is a reply to message #67934] |
Tue, 23 July 2002 12:31  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
in OEM, you go to SCHEMA MANAGER
Right Mouse Click on TABLES folder and selecr CREATE
then there is a radio button you can select that says DEFINE QUERY you need to select.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
