Re: Granting priveleges
Posted by: Marion Gordon
Date: August 19, 2014 04:39AM

You have like to create a table means use the following syntax

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

You have to update temporary table means use the following syntax
UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;

Options: ReplyQuote


Subject
Written By
Posted
July 30, 2014 10:41AM
August 01, 2014 01:44PM
August 02, 2014 01:58AM
August 03, 2014 09:34AM
Re: Granting priveleges
August 19, 2014 04:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.