Interested to Buy Any Domain ? << Click Here >> for more details...
What are different Oracle database objects?
- 1 Answers
- 2746 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 |
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What is raw datatype in oracle?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
if i am using dml statement in function. then i am writing select statement what was the output
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
What do you mean by redo log file mirroring?
What is a Tablespace?
What is a OUTER JOIN?
How to write numeric literals in oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is blob data type in oracle?
Oracle General 
