Can SYSTEM.CURRENT_BLOCK value be changed. If yes how? If no Why? Give with example
How to determine whether particular parameter of parameter file is static or dynamic?
Latest Answer: In v$parameter we can find one column ie. ISSYS_MODIFIABLE. This column
contains three phases 1) Immediate 2) DEFERRED 3) False
1. Immediate : We can change the parameter in fly database ie Dynamic.
2. DEFERRED : We can change the parameter in fly ...
What is the function BASECONV.CONVDATA(FILED_01,ARG_1,ARG_2) used for ?
What is the command to print the time taken by a query
Latest Answer: you need to use set operetor TO GET THE TIME..LIKE THIS..SQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08SQL> SET TIMING ONSQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08Elapsed: 00:00:00.00now it will show time.. ...
What will happen if you dont use Replace option in a Procedure when first creating it for first time?
Latest Answer: No problm. It successfully creates the procedure.But once it created ,if u modify it and compail without REPLACE ,it will give an error ...
How can we connect Oracle database with our C++ program. Explain with an example.
Latest Answer: hi i fil u can use pro c to connect the data base to the front end data condition: database should b oracle ... ...
How to set NLS_DATE_FORMAT for a database permanentlyfor example let's say I want to set : NLS_DATE_FORMAT= 'dd:mon:yyyy hh24:mi:ss' for the database and I am not supposed to give the ALTER
Can anyone please tell me what are the advanced features in 10g when compared to 9i
Latest Answer: Oracle 10g features are 1) Sys Aux Tablespace 2) ASM3) New Flash Recovery Area 4) CTWR (Change Tracking Writer) This is background process which writes the block change information to the change tracking file. 5) Server Manageability Components6) Unified ...
Latest Answer: If the database is running in archivelog mode then perform time-based recovery to recover the table. ...
Latest Answer: drop user ...
View page << Previous 4 5 6 7 [8] 9 10 11 12 13 Next >>
Go Top
