Answer / muhammad wali ullah

***An inline view is a subquery with an alias (or
correlation name) that you can use within a SQL statement.
***A named subquery in the FROM clause of the main query is
an example of an inline view.
***An inline view is not a schema object.

Answer / guest

You can find an example at:
http://forums.oracle.com/forums/thread.jspa?
messageID=1473644

Answer / guest

You can find an example at <a
href="http://forums.oracle.com/forums/thread.jspa?
messageID=1473644">http://forums.oracle.com/forums/thread.js
pa?messageID=1473644</a>

Answer / ravi kulkarni

A query which uses data as source is called inline view.
for example in select statement , query can be used to
represent table name .

Answer / sreekanth

An inline view is a SELECT statement inside another SELECT
statement.

What is the difference between the implicit and explicit cursors?

0 Answers  

what is inline command?

2 Answers  

What is the different between Stored Procedure and Procedure?

7 Answers   Informatica, MIS,

Hi All, I am new to both this blog and technology. I was able to see a response for one of the questions on triggers as below. I would like to know why are we using " if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then" instead, can't we use " if sysdate = 'sunday' then". I can understand the use of "rtrim", but dont know y v r using to_char. I have seen this in many cases but did not get a convincible explaination. Please help me with this and do excuse if this question sounds silly. Thanks in advance...... create or replace trigger trg_sun before insert on <table name> begin if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then raise_application_error(-20345,'no transaction in sunday'); end if; end trg_sun;

2 Answers  

What is keys and its types?

0 Answers  

What is full join?

0 Answers  

Is sql port 1433 encrypted?

0 Answers  

How do you delete data from a table?

0 Answers  

What is difference between inner join and self join?

0 Answers  

What are synonyms in sql?

0 Answers  

what the meaning of sql

8 Answers  

difference between pl/sql table and normal pl/sql table

2 Answers