View is the table(temporary or permanent) which contains SQL query and it returns result set. It is of two types 1) Temporary View is used in the SELECT statement.This is temporary and it is not stored in disk . For eg.
with viewname as (select * from table) select * from viewname;
As comparison to normal query temporary view is fast. It generally used to […]
How can we write recursive query ? Lets suppose a case when you have to find all the child data of the given Parent and you don’t want need access java code or functions the recursive query would be the best option. You can write a simple query to find all records on basis of […]
What is a database? Database is the collection of data and information . It is organized in such a way that it can be easliy accessed, managed and updated. What is DBMS? DBMS mainly stores data in the files. There are tables but there is no relation between the tables. It stored in the hierarchical […]