Logo 
Search:

oracle Interview FAQs

Submit Interview FAQ
Home » Interview FAQs » oracleRSS Feeds
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

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

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

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

COUNT(field_name) with example

returns the number of rows where field_value is NOT NULL.

SELECT COUNT(rating) FROM Customers;
Posted By:Shruti Sharma      Posted On: Dec 17

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

  1  2  3