Self join-Its a join foreign key of a table references the same table. Outer Join--Its a join condition used where One can query all the rows of one of the tables in the join condition even though they
Latest Answer : Please let me know various joins available and description for every joinRegards,sireesha ...
Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not exist once the SQL statement is executed.
Latest Answer : Rename means give the new name to existed objectsalise is use to refrence to objects ...
A table can have only one PRIMARY KEY whereas there can be any number of UNIQUE keys. The columns that compose PK are automatically define NOT NULL, whereas a column that compose a UNIQUE is not automatically
Latest Answer : A table can have only one PRIMARY KEY where as can have numerous UNIQUE KEY . A PRIMARY KEY is a unique KEY with the extra constraint that all keycolumns must be defined as NOT NULL. But unique key column can contain null value only once. If UNIQUE ...
By using DISTINCT
Latest Answer : using distinct keywordanother is union operator ...
SQL*PLUS is a command line tool where as SQL and PL/SQL language interface and reporting tool. Its a command line tool that allows user to type SQL commands to be executed directly against an Oracle database.
Latest Answer : SQL keywords cannot be abbrevated but SQL*PLUS keywords can be abbrevated. ...
SUBSTR returns a specified portion of a string eg SUBSTR('BCDEF',4) output BCDEINSTR provides character position in which a pattern is found in a string. eg INSTR('ABC-DC-F','-',2)
Latest Answer : hi Buddy, Substr only give the sub part of the stringSubstr(String,'start postion','length')Substr('ABCDEFAG',3,7); /*out put is =cdefag */Instr to give only possion of letter in use in a stringInstr(String,'letter',possition ...
'' Should be used before '%'.
Latest Answer : select * from emp where instr('ename','%')!=0 ...
Outer Join--Its a join condition used where you can query all the rows of one of the tables in the join condition even though they don’t satisfy the join condition.
Latest Answer : outer join is that type of jon which retrives the matach & alson unmatached recores also from the tables ...
SELECT * FROM empWhere emp_no+' '=12345;i.e you have to concatenate the column name with space within codes in the where condition.SELECT /*+ FULL(a) */ ename, emp_no from empwhere emp_no=1234;i.e
Latest Answer : Its so distressing that no body could provide a better answer than a novice like me.In the where clause change the order of conditions in such a way that:Â 5 = value cond1 & value =5or value + 1 = 5 ...
Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?
SELECT customer_no, payments from customer C1WHERE 3
