Home » SQL & PL/SQL » SQL & PL/SQL » Converting Views to Tables...PLEASE HELP ASAP
Converting Views to Tables...PLEASE HELP ASAP [message #36736] Sat, 15 December 2001 07:35 Go to next message
Keri
Messages: 2
Registered: December 2001
Junior Member
How do I convert a view that joins multiple into a denormalized table? Is there a special snytax? Or is it the same as the CREATE TABLE...syntax. I know that I will need triggers to keep the new table updated.

Thanks for your help.

----------------------------------------------------------------------
Re: Converting Views to Tables...PLEASE HELP ASAP [message #36739 is a reply to message #36736] Sun, 16 December 2001 08:57 Go to previous messageGo to next message
Ronaldo
Messages: 1
Registered: December 2001
Junior Member
Well, if I understand your question, itīs simple !
make this ...
Create Table My_Table as Select * From My_View

[[]]īs

Ronaldo.

----------------------------------------------------------------------
Re: Converting Views to Tables...PLEASE HELP ASAP [message #36741 is a reply to message #36739] Sun, 16 December 2001 11:36 Go to previous message
Keri
Messages: 2
Registered: December 2001
Junior Member
Thx Ronaldo...but will that table be denormalized? I am still a bit confused on normalized and denormailzed tables....thanks again

----------------------------------------------------------------------
Previous Topic: How to spell the numbers
Next Topic: Re: pl/sql-urgent
Goto Forum:
  


Current Time: Fri Mar 29 00:17:07 CDT 2024