Question:
Storing information in multi language like Japanese, Chinese etc in particular column in the database.what is the processes to store these information
Solution :
Instead of using UTF8 for your entire database, you may consider to have some columns with type NVARCHAR
Question
Difference between 'SELECT ANY TABLE' privilege and 'SELECT' grant on table
Ans:
'select any table' allows you to select without naming the schema before the table name, for example:
select grant allows you to select * from scott.tiger(scott is schema name)
and
select any table grant allows you to select * from tiger.
select grant allows you to select * from scott.tiger(scott is schema name)
and
select any table grant allows you to select * from tiger.
Question:
What is Oracle Enqueue and Dequeue?
Ans:
Enqueue/Dequeue are used in Oracle Advanced Queues (AQ) to add an event/message to an agent/queue or take process the event from a queue.
