Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle CREATE VIEW to HiRDB

Remove “OR REPLACE”.

Oracle:

CREATE OR REPLACE VIEW view01 (C1, C2, C3) AS 
SELECT C1,C2,C3 FROM table1 ;

HiRDB:

CREATE  VIEW view01 (C1, C2, C3) AS 
SELECT C1,C2,C3 FROM table1 ;

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.