Updating data in a view oracle
DDL Statements are CREATE : Use to create objects like CREATE TABLE, CREATE FUNCTION, CREATE SYNONYM, CREATE VIEW. ALTER : Use to Alter Objects like ALTER TABLE, ALTER USER, ALTER TABLESPACE, ALTER DATABASE. DROP : Use to Drop Objects like DROP TABLE, DROP USER, DROP TABLESPACE, DROP FUNCTION. To create tables, views, synonyms, sequences, functions, procedures, packages etc.Example To create a table, you can give the following statement create table emp (empno number(5) primary key, name varchar2(20), sal number(10,2), job varchar2(20), mgr number(5), Hiredate date, comm number(10,2)); Now Suppose you have emp table now you want to create a TAX table with the following structure and also insert rows of those employees whose salary is above 5000. create table tax (empno number(5), tax number(10,2)); insert into tax select empno,(sal-5000)*0.40 from emp where sal 5000; Instead of executing the above two statements the same result can be achieved by giving a single CREATE TABLE AS statement.This training is offered in two different formats, instructor-led classroom or online training over the Internet.
If you only need to know it for your knowledge, typing in SQLPlus will tell you about the columns in the table. Note that selecting from USER_TAB_COLUMNS will only list the columns in tables in your own schema.In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.Students learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions.This course introduces students to the fundamentals of SQL using Oracle Database 11g database technology.In this course students learn the concepts of relational databases and the powerful SQL programming language.