Logo F2FInterview

SQL Plus Interview Questions

Q   |   QA

Drop Index Indexname 

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 - Joining two tables by equating two common columns.Outer Join - Joining two tables in such a way that query can also retrieve rows that do not have corresponding join value in the other table.

JOIN: Return rows when there is at least one match in both tables
LEFT JOIN: Return all rows from the left table, even if there are no matches in the right table
RIGHT JOIN: Return all rows from the right table, even if there are no matches in the left table
FULL JOIN: Return rows when there is a match in one of the tables 

  • CHAR,
  • VARCHAR2,
  • NUMBER,
  • DATE,
  • RAW,
  • LONG and
  • LONG RAW. 

select empno||' '||ename from emp;

select replace (column name,',','') from table name. 

if a view is update, deleted , or inserted wil the changes be refelected on the base table 

In order to link this F2FInterview's page as Reference on your website or Blog, click on below text area and pres (CTRL-C) to copy the code in clipboard or right click then copy the following lines after that paste into your website or Blog.

Get Reference Link To This Page: (copy below code by (CTRL-C) and paste into your website or Blog)
HTML Rendering of above code: