what is inline command?
Answers were Sorted based on User's Feedback
Answer / nagender k
Inline view is a subquery in the from clause of your main
query.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / rajeshwaran
An inline command is nothing but and Inline view that act
as a data-source for an Query.
Another important info about the Inline command is that it
is not an Schema Object.
example : (select rownum,e.eno
from (select eno from emp) e
where rownum <=3)
The query will result the TOP_3_analysis .In which the query
(select eno from emp) is known as INLINE_view or
INLINE_Query
| Is This Answer Correct ? | 3 Yes | 1 No |
Explain foreign key in sql?
What is a constraint. Types of constraints ?
5 Answers Accenture, BirlaSoft,
difference between SQL and C
1 Answers Indus Software Technologies,
What are the benefits of using PL/SQL packages?
how to dump a table to a file with 'mysqldump'? : Sql dba
what is the different between unique+not null & primary key,
Is it possible to link two groups inside a cross products after the cross products group has been created?
SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows
Is merge a dml statement?
What are the triggers associated with image items?
How does stored procedure reduce network traffic?
Explain how to use transactions efficiently : transact sql
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)