Programming

The INSERT INTO SELECT statement selects data from one table and inserts it into an existing table. Any existing rows in the target table are unaffected. SQL INSERT Syntax The syntax for the SQL INSERT statement when inserting a  record using the another table.   INSERT INTO table (column1, column2, ... ) SELECT expression1, expression2, ... FROM source_table WHERE conditions;   SQL INSERT INTO SELECT Examples   Copy only a few columns from another table......   INSERT INTO suppliers (supplier_id, supplier_name) SELECT account_no, name FROM customers WHERE city = 'Newark';  

CREATE TABLE   in sql........... ########################################################### The SQL CREATE TABLE statement is used to create a new table. CREATE TABLE Syntax   CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ..... columnN datatype, PRIMARY KEY( one or more columns ) FOREIGN KEY () UNIQUE()   constraint constraint_name  ); Example: CREATE TABLE Persons ( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) constraint pk_persons primary key (PersonID), constraint fk_persons foreign key primary_key_of_another_table );

Oracle apex 4.0 installation in oracle database 11g quickly =========================================================== =========================================================== installation of oracle Database 11gr2 ====================================== you have moved the entire content of Components folder from File 2 (after unzipping Database > Stage > Components: ) to Component folder of file 1 (after unzipping F:\Oracle 11g EE R2\Oracle\database\stage\Components). Now you have got your complete Oracle Database 11g EE R2 Software in a single file. Now open setup.exe from Oracle Database 11g EE R2/database folder and continue the installation process. installation of Apex 4.0 into 11g =================================== 1)After downloading unzip it in the following directory : G:\app\apex_4_install\ its create a apex directory like :- G:\app\apex_4_install\apex 2) Now You need to create a Tablespace for apex data as below : SQL> CONN / AS SYS