Logo 
Search:

Interview FAQs

Submit Interview FAQ
Home » Interview FAQsRSS Feeds
Oracle
Comments: 0

COUNT(*)

returns the number of rows in the table,including Duplicates and Those with NULLS.

SELECT COUNT(*) FROM Customers;


Posted By:Shruti Sharma      Posted On: Dec 17

Oracle
Comments: 0

GROUP FUNCTIONS (AGGREGATION FUNCTIONS)

functions that act on a set of values and returns a single value.

e.g. SUM,AVG,MIN,MAX,COUNT
Posted By:Shruti Sharma      Posted On: Dec 17

Oracle
Comments: 0

Explain sysdate with example

- Sysdate is a pseudo column that contains the current date and time.

- It requires no arguments when selected from the table DUAL and returns the current date.

SELECT sysdate FROM dual;
Posted By:Shruti Sharma      Posted On: Dec 17

Oracle
Comments: 0

Dual table in oracle

- Dual is a small oracle worktable,which consists of only 1 row and 1 column and contains the value x in that column.

- Besides arithmetic calculations,it also supports date retrieval and its formatting.

- For output of Arithmetic calculations ...
Posted By:Shruti Sharma      Posted On: Dec 17

Oracle
Comments: 0

EXAMINING OBJECTS CREATED BY A USER

EXAMINING OBJECTS CREATED BY A USER

SELECT * FROM TAB;
Posted By:Shruti Sharma      Posted On: Dec 17

Oracle
Comments: 0

Provide syntax to rename a table

RENAME TO ;
Posted By:Shruti Sharma      Posted On: Dec 17

  12  13  14  15  16  17  18  19  20  21  22