 Related Questions Latest Answer : Data Definition Language: Create, AlterData Modification Language: Update,insert, Delete, TruncateData Control Language: Commit, Rollback ... Latest Answer : There are 5 types of joins available in sql server1) inner join2) outer join( left outer join,Right outer join)3) Full Join4) Cross Join5) Self Join1) inner Join : Two tables having the common column values go with inner join.Example:select * from emp ... Latest Answer : Dec(p,s), desimal(p,s), double precision, foat, int, inteager, real, smallint, numeric(p,s), number(p,s), char(size), varchar2(size), long, raw, long raw, date, timestamp, urowid(size), rowid, boolean, nchar(size) , nvarchar2(size), bfile, blob, clob, ... Latest Answer : 1. DDL: Data Definition Language2. DML: Data Manipulation Language3. TCL: Transaction Control Language4. DCL: Data Control Language5. DQL: Data Query Language ... Latest Answer : UNION : It is a set operator which retrives all the matching records from two different tables and eliminates the duplicate rows.OUTER JOIN: It is used to retrive lacking records from one table against the existing records from the other table. egselect ... Latest Answer : LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN ... Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.Data Manipulation Language: INSERT,UPDATE,DELETE,LOCK TABLE,EXPLAIN PLAN & SELECT.Transactional Control: COMMIT & ROLLBACKSession Latest Answer : DDL: Data Defintion LanguageDML: Data Manipulation LanguageTCL: Transaction Control LanguageDCL: Data Control Language ... Join is a query which retrieves related columns or rows from multiple tables.Self Join - Joining the table with itself.Equi Join - Joining two tables by equating two common columns.Non-Equi Join Latest Answer : In Full Outer Join we get both matched and unmatched data from both the tables whereas Cartesian join is a join in which each row of one table is cross multiplied with each row of the second table ... CHAR,VARCHAR2,NUMBER,DATE,RAW,LONG and LONG RAW. Latest Answer : CHAR,VARCHAR2,NUMBER,DATE,RAW,LONG and LONG RAW,BLOB, CLOB,NCLOBFOR ORACEL 9I AND ABOVE.TIMESTAMP, TIMESTAMP WITH TIME ZONE, YEAR TO DAY, DAY TO SECOND ... Latest Answer : in cases where a very small table is being joind to large table ,the oracle hash join will often dramatically speedup the querry hash join are for faster than nested loops join same cashes.regards pratyush singh ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
