What is join view in sql?
Answer / Santosh Kumar Mishra
A Join View in SQL combines two or more tables, views, or query results based on a specified join condition. It allows you to create temporary virtual tables for use in the execution of a SELECT statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are few of the schema objects that are created using PL/SQL?
How to select all records from the table?
If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.
What is pivot query?
Explain two virtual tables available at the time of database trigger execution.
what is the difference between implicit and explicit trigger
Do you know the basic structure of PL/SQL?
Define overloaded procedure?
What are schema-level triggers?
how to enter characters as hex numbers? : Sql dba
what is bdb (berkeleydb)? : Sql dba
explain primary keys and auto increment fields in mysql : sql dba
Oracle (3253)
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)