Union operator in structured query lanhuage

Ashwini

• Jan 25th, 2018

Union combines the results of two or more SELECT statements and eliminates the duplicate rows

Answer Question  Select Best Answer

Ashwini

• Jan 25th, 2018

Procedure - Definition - Procedure is a program unit or a module that performs a particular task. Execution - A stored procedure is executed explicitly by issuing procedure call Parameters - St...

qptopm

 Profile Answers by qptopm Questions by qptopm

• Nov 3rd, 2016

Commit cannot be done in case of triggers except for autonomous transactions. When you create a trigger you have to identify event and action of your trigger. Triggers are implicitly called by DB itself

Answer Question  Select Best Answer

Piyush Pathak

• Feb 1st, 2018

$$DBDATE$$ retrieves the current database or the server you using date
$$date$$ retrieves the current operating system or the current system you are working date.

palani

• Apr 26th, 2006

$$date$$ displaying local system date $$dbdate$$ displaying server date.

Answer Question  Select Best Answer

What are the three key properties of RDBMS

Prabhat Sahu

 Profile Answers by Prabhat Sahu Questions by Prabhat Sahu

• Oct 12th, 2018

Implicit properties of Relational Database. An RDBMS is easily accessible using Structured Query Language (SQL) commands in them to manipulate data. SQL is the ISO standard language for interacting w...

Answer Question  Select Best Answer

Only for 10 records.

Aman

• Mar 1st, 2021

Only for 10 records

Answer Question  Select Best Answer