এই ব্লগটি থেকে জনপ্রিয় পোস্টগুলি
How to install Apex
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...
INSERT INTO SELECT Statement in sql
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';
মন্তব্যসমূহ
একটি মন্তব্য পোস্ট করুন