Answered Questions

  • In Oracle varchar2 takes dynamic space for storage then why char is still in oracle?

    Vijay Shewale

    • Sep 11th, 2014

    The reason behind char is still in oracle that is some of the table and objects are stored in oracle in char data types. to support that data types for that it is still in oracle. one more thing that ...

    Paras

    • Feb 23rd, 2013

    To Provide backward compatibility. i.e. program written in older version of Oracle might have CHAR used in it. The newer version should be compatible with it. Thats why CHAR is still there in Oracle ..

  • Why are OLTP database designs not generally a good idea for a Data Warehouse

    Answer posted by Shri Dana on 2005-04-06 19:04:05: OLTP cannot store historical information about the organization. It is used for storing the details of daily transactions while a datawarehouse is a huge storage of historical information obtained from different datamarts for making intelligent decisions about the organization.

    jyotsna

    • Sep 6th, 2007

    OLTP databases are generally volatile in nature which are not suitable for datawarehouses which we use to store historic data

    1292033

    • Aug 2nd, 2007

    Because OLTP databases are transactional data related databases. The meaning of this is these databases are used in real time to insert, update and delete data. To accomplish these tasks in real time,...