How to convert numbers to characters in oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
what is normalisation?what are its uses?
How many categories of data types in oracle?
How to manage transaction isolation level?
What is the usage of control file in oracle?
what is the scenario where you take the database to NoArchivelog mode?
Explain the use of show option in imp command.
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
select trunc(round(156.00,-1),-1) from dual;
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
Can we write insert statement in function in oracle?
What are the general rules on data consistency?