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: It is developed in C not Java ...
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: dbms_pipe is a IPC methodology which allows processes to communicate with each other using pipes.
The important functions/procedures in this package are(1) CREATE_PIPE to create a new pipe ==> dbms_pipe.create_pipe(pipename) where pipename can be Oracle ...
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: During the execution of an update statement, the server process looks into library cache whether same kind of query is recently executed or not i.e. explain plan is ready for execution or not in shared pool and then search for that record block ...
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
