Total Pageviews

July 29, 2016

7/29/2016 08:29:00 PM



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. 


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.