Compiled Messages:

------------------------------------------------------------
Message no. 575
Posted by Rhonda Nichols (renichols2) on Tuesday, October 10, 2006 10:08am
Subject: Project 7 Question
In project 7 we are creating table CUSTOMER in DBSEC schema.  We have already 
created this table before so I assume we should do the DROP TABLE CASCADE option in 
order to re-create.  Or do you think we need to re-name this one and leave previous one 
alone?  Anyone looked at this yet?

-Rhonda
------------------------------------------------------------
Message no. 576[Branch from no. 575]
Posted by Sagun Piya (srpiya2) on Tuesday, October 10, 2006 10:45am
Subject: Re: Project 7 Question
hi Rhonda,
I think we don't have to drop this table. we can add the columns for this table as we don't 
have populate this table. So, I think we just have to populate this table.
Sagun
------------------------------------------------------------
Message no. 581[Branch from no. 575]
Posted by Lakshmikar Padmaraju (lpadmaraju) on Tuesday, October 10, 2006 1:22pm
Subject: Re: Project 7 Question
Hi Rhonda,
for project 7 I am droping the  sechema and recreating schema DBSEC again to avoid any further 
problems, you don't need do this, you can drop table and recreate the table itself.

Raju.
------------------------------------------------------------
Message no. 582[Branch from no. 575]
Posted by Naziya Shaik (snaziya) on Tuesday, October 10, 2006 3:28pm
Subject: Re: Project 7 Question
Rhonda,

You can use Alter command to add new column. You dont have to drop the table.
and then you can populate.

Naz
------------------------------------------------------------
Message no. 583[Branch from no. 575]
Posted by Gnaneshwar Bukka (gbukka) on Tuesday, October 10, 2006 3:33pm
Subject: Re: Project 7 Question
Hi Rhonda,

You can use ALTER command to insert the single column but according to
the project, Dr. Liu is expecting us to recreate the table, this is what
I understood. So, it is better to drop the table and create it again as
Dr. Liu is very specific with his projects. Hope this helps.

Gnaneshwar Bukka.

------------------------------------------------------------
Message no. 584[Branch from no. 575]
Posted by Krishnamurth Ashwini (kashwini) on Tuesday, October 10, 2006 5:00pm
Subject: Re: Project 7 Question
I would say..drop the table and create it again. 

The 2nd question clearly says: "CREATE" a customer table with the
following columns:

Ash
------------------------------------------------------------
Message no. 586[Branch from no. 584]
Posted by Rhonda Nichols (renichols2) on Wednesday, October 11, 2006 9:37am
Subject: Re: Project 7 Question
Ok..you have me convinced.  I plan to drop the table and re-create it.  Thanks for your 
input!!!

-Rhonda
------------------------------------------------------------
Message no. 588[Branch from no. 586]
Posted by Ravinder Gaur (rgaur) on Friday, October 13, 2006 10:41am
Subject: Re: Project 7 Question
Thanks Ash for explaining!
- Ravi 
------------------------------------------------------------
Message no. 590[Branch from no. 584]
Posted by Paras Pradhan (ppradhan) on Friday, October 13, 2006 7:36pm
Subject: Re: Project 7 Question
I think as ash said to drop and re create the table again.


Paras.
------------------------------------------------------------
Message no. 594[Branch from no. 575]
Posted by Suresh Methuku (smethuku) on Saturday, October 14, 2006 2:14pm
Subject: Re: Project 7 Question
Thanks for the information guys..

suresh
------------------------------------------------------------
Message no. 597[Branch from no. 584]
Posted by Anjana Divakar (adivakar) on Saturday, October 14, 2006 6:28pm
Subject: Re: Project 7 Question
Thanks ash,
I followed your advice and now it works fine!
------------------------------------------------------------
Message no. 601[Branch from no. 581]
Posted by Eric Knuth (elknuth2) on Saturday, October 14, 2006 7:36pm
Subject: Re: Project 7 Question
Hello
I am also planning on dropping this schema. I want to start fresh.
Eric
------------------------------------------------------------
Message no. 602
Posted by Eric Knuth (elknuth2) on Saturday, October 14, 2006 7:38pm
Subject: The truth Hurts
A customer comes into the computer store. "I'm looking for a mystery Adventure Game 
with lots of graphics. You know, something really challenging." 

"Well," replied the clerk, "Have you tried Windows Vista?"
------------------------------------------------------------
Message no. 604[Branch from no. 590]
Posted by Venkat Munagala (vrmunagala) on Saturday, October 14, 2006 10:41pm
Subject: Re: Project 7 Question
Thanks for the information guys.
------------------------------------------------------------
Message no. 605[Branch from no. 602]
Posted by Gnaneshwar Bukka (gbukka) on Saturday, October 14, 2006 10:43pm
Subject: Re: The truth Hurts
Nice one Erick.

Gnaneshwar Bukka.

------------------------------------------------------------
Message no. 606[Branch from no. 605]
Posted by Ravinder Gaur (rgaur) on Sunday, October 15, 2006 8:33am
Subject: Re: The truth Hurts
Good one Eric.
Thanks,
- Ravi
------------------------------------------------------------