 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 : 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 : if DEFINE is isqlplus command then how do u define ACCEPT command. what is difference between them?i think define is a command in sql *plus which works same in isqlplus with ACCEPT.pls do forward the argument. ... Read Answers (5) | Asked by : suresh
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
