I have given the following statement to create a view.
CREATE OR REPLACE VIEW vw_divisiondetails
( divisioncode, divisionname)
AS
SELECT "divisioncode","divisionname"
FROM cmsdivsionmaster
It was created successfully. My doubt is how it accepted column names in double quotes? Generally we use double quotes in select statement to give alias name. But here it treats it as column name. Could any body explain how it works?