Interested to Buy Any Domain ? << Click Here >> for more details...
What are different Oracle database objects?
- 1 Answers
- 2681 Views
- I also Faced
- E-Mail Answers
Answer / parthasarathi
1)tables
2)views
3)sequences
4)synonyms
5)clusters
6)indexes
7)materialized views
8)procedures
9)functions
10)packages
11)triggers
| Is This Answer Correct ? | 1 Yes | 0 No |
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
What is a nvl function?
What is oracle analytical function?
What is the difference between SQL and SQL Server?
How to assign a tablespace to a users in oracle?
Explain the types of exception?
How to convert numbers to characters in oracle?
what is main def between plsql/table and array?
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
What are triggers in oracle?
What language does oracle use?
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
Oracle General 
