Logo 
Search:

oracle Interview FAQs

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

Oracle
Comments: 0

In Oracle, how can you find out what tables and views you own?

By selecting from USER_CATALOG or CAT. The name of the data dictionary object will vary by implementation, but all versions have basically the same information about objects such as tables and views.
Posted By:Shruti Sharma      Posted On: Dec 21

  1  2  3