Answer Posted / sunil maurya
A view is simply the representation of a SQL statement that
is stored in memory so that it can easily be re-used. For
example, if we frequently issue the following query
SELECT empid FROM emp;
I might well want to make this a view (the reality is that
we would probably never create a view for a statement this
simple but we wanted to use an easy example).
To create a view use the create view command as seen in this
example
CREATE VIEW view_emp
AS
SELECT empid FROM emp;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to drop an index?
WHAT IS ecc 6.0
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What is the difference between postgresql and oracle?
Explain the use of grant option in imp command.
How to upsert (update or insert into a table)?
What is an oracle?
How to use "in out" parameter properly?
What is flashback in Oracle?
What are the limitations oracle database 10g xe?
how to do daily transactions with out sql* loader control file regesterd in apps?
What are the differences between primary key and unique key?
What is integrity and what is constraint??Explain with example
What is a nvl function? How can it be used?
What is a package ? What are the advantages of package ?