Latest Answer: Index are reference to data in tables's columns on what they are based. Index work exactly in way like we have book's index describing its chapters and what page # chapter can be found.They only contain reference to the data. There are two types on ...
Latest Answer: Hi,Lookup tables are like master tables which are static & will be referred by other Base tables for reference.Lookup tables are basically used for referring a predefined data which are stored in these tables.*** Innila *** ...
Latest Answer: Oracle uses all three files (tnsnames.ora, sqlnet.ora, listener.ora) for network configuration.tnsnames.ora A tnsnames.ora file maps net service names to connect descriptors. In simple words, tnsnames.ora file provides the ability to reference oracle ...
Latest Answer: If you are a DBA, login on the host using sqlplus to the database using sys as sysdba privilege.$ export ORACLE_HOME=$ export ORACLE_SID=$ sqlplus "/ as sysdba"Execute the Oracle-supplied utility to ...
Latest Answer: connect as sysdba and typeselect * from v$sgainfo; ...
A view is created on a table then i dropped the base table and created the base table once again with the same name then that view will works or not?
Latest Answer: New Features in 9i are 1.Multiple table inserts using a single statement2. Multilevel collections. ie. a nested table can be used in a nested table3. Case Expression - it's a extended form of decode4. Merge Statement5. Online index rebuild6. Online table ...
How will you get the executation time of procedures or fuctions in the package?.which one is taking somuch time?.
Provide names of classes that are used in database connection using Oracle,Access database, and MSDE
Latest Answer: TRUNC and TRUNCATE are 2 different functions, above you mentioned only the TRUNC functiontruncate table will delete all records of the table ...
View page << Previous 1 2 3 4 [5] 6 7 8 9 Next >>
Go Top
