Which command is used for locking a user from performing DML Operation?
Latest Answer: LOCK TABLE tablename IN EXCLUSIVE MODE;EX:LOCK TABLE emp IN EXCLUSIVE MODE; ...
Why is sys_context used for providing privileges in Oracle?
Latest Answer: The sys_context function can be used to retrieve information about the Oracle environment.The syntax for the sys_context function is:sys_context( namespace, parameter, [ length ] )namespace is an Oracle namespace that has already been created. If the ...
Latest Answer: "C" language ...
Is there any syntactical diff between Oracle 9i & 10g or any change in which the Queries are used....It uses SQL isn't it?
Latest Answer: In 9i we does not have the facility to brign the table that is been dropped, but in 10g we have something like flashback and also in 10g they have added one extra regular expression ...
SQL>DECLARE 2 dayofweek VARCHAR2(200); 3 BEGIN 4 SELECT TO_CHAR(sysdate,'Day') INTO dayofweek FROM DUAL ; 5 6 IF dayofweek = 'Tuesday' 7 THEN 8
Latest Answer: TO_CHAR(sysdate,'Day') is always return day name with some blank space, So its better to use TRIM function to exact match.Like TRIM(TO_CHAR(sysdate,'Day'))Or You can match initial 3 character in the by using substr function. ...
give the dbms_pipe commands in oracle of there execution,which are used to send & recieve messages what is the max size can sent at one go
Latest Answer: ------Funtions------DBMS_PIPE.CREATE_PIPE:- for creating a pipeDBMS_PIPE.SEND_MESSAGE:- For sending messageDBMS_PIPE.REMOVE_PIPE:- for removing messageDBMS_PIPE.RECEIVE_MESSAGE:- For receiving message------Procedures------DBMS_PIPE.PACK_MESSAGE:- for ...
This is odd and I fear I may be missing something basic. I am using the Oracle forms supplied pop up calendar widget. When I click on the calendar to select a date it returns a strange value. The year
What is the difference between the tools and utilities in Oracle 9i?
Latest Answer: Utility is something which comes along with software where it is intended to help us to solve a particular purpose but tool is something which enable us to develop more delebrately we can say as helpful for innovative development. ...
Latest Answer: When a user issues a update statement the server process checks for weather the same type of command is executed recently or not if that command is executed very recently then it directly proceed to the dictionary cache to fecth the metadata presented ...
Create a report for the HR department that displays employee last names, department numbers, and all the employees who work in the same department as a given employee. Give each column an appropriate label.
View page [1] 2 3 4 5 Next >>
Go Top
