If we create a table having a column of BLOB data type then how we have to insert and retrieve the data?
Latest Answer: In the above code '-2' specifies that the only two digits before the decinmal points needs rounding up.and '+2' would mean two digits after the decimal point. ...
How to check intact, state of a particular index, what are the impacts of invalid index? How to recover it?
Give the count for each daemon when 150 sessions are connected to database provided only 200 concurrent sessions are allowed in that database ?
Latest Answer: hello dual is a table which is created by oracle along with the data dictionary. It consists of exactly one column whose name is dummy and one record. The value of that record is X. sql> desc dualName Null? ...
Latest Answer: V$backup : This status column of this view shows whether a tablespace in hot backup mode.The status 'ACTIVE' shows the datafile to be in backup mode.V$datafile_header : The fuzzy column also helps a dba to monitor datafile which are in backup mode. ...
Latest Answer: Raise_application_error(error number,error discription) ...
In oracle we are using dual table name for the temporary purpose. which table we are using in SQL server
Latest Answer: is it drived ? Are you sure ..I think is is Derived. ...
Latest Answer: when u create pfile from spfile then u can give ur perticular location according to u like create pfile = 'ur specified location' from spfile ; ...
View page << Previous 3 4 5 6 [7] 8 9 Next >>
Go Top
