SQL objects


SQL objects are

1) schemas,

2) data dictionaries, 

3) journals,

4) catalogs, 

5) tables, 

6) aliases, 

7) views, 

8) indexes, 

9) constraints, 

10) triggers, 

11) sequences, 

12) stored procedures, 

14) user-defined functions, 

15) user-defined types, 

16) and SQL packages. SQL creates and maintains these objects as system objects. 

A brief description of these objects follows:

Comments

Post a Comment

Popular posts from this blog

AIOMgr: Preparing flush failed with VERR_NOT_SUPPORTED, disabling async flushes

AIOMgr: Preparing flush failed with VERR_NOT_SUPPORTED, disabling async flushes If you get error like this while Installing Windows 8.1 as guest OS using Oracle VirtualBox /VirtualMachine Then check your RAM Allocation for the Guest OS. Example: First time i gave 5120 (5 GB) of RAM for Guest OS. while installing i got the error like this in log file AIOMgr: Preparing flush failed with VERR_NOT_SUPPORTED , disabling async flushes. Now i changed the RAM size to 4096(4 GB) , now the error gone, the guest OS installed successfully. My Suggestion is to set RAM size in EVEN  for this kind of errors.
Read more

How to install Node.js, npm, socket.io and use them?

1 Go to  http://nodejs.org  and click on Install button,  2.. Download node and install it 3.. Create an empty folder on your hard disk      3.1) check environment path of nodejs using command prompt             a) C:\>set %PATH%              If it is not showing any path regarding node then set the environment path             b)  C:\>set path=%PATH%;C:\Program Files\nodejs\ 4.. Create an package.json file with the following content       Ex: C:\Program Files\nodejs\package.json { "name" : "App" , "version" : "0.0.1" , "description" : "App" , "dependencies" : { "socket.io" : "latest" }, "author" : "developer" } 5.. Open windows's command prompt (press Windows key + R and type  cmd ) 6.. Navigate to your newly created directory with  cd  command 7.. Type...
Read more

MAGENTO::Sales Order Grid Customization - Add SKU list and customer email column to the grid

Add SKU list and Customer Email column to the grid Supposed you had copied your code\core\Mage\Adminhtml\Block\Sales\Order\Grid.php to code\local\Mage\Adminhtml\Block\Sales\Order\Grid.php because you want to display the subtotals, credit card types, total of items ordered for the sales order. The new version of Magento which is 1.4.1 in code\local\Mage\Adminhtml\Block\Sales\Order\Grid.php change like this protected function _prepareCollection() { $collection = Mage::getResourceModel($this->_getCollectionClass()); $collection->getSelect()->joinLeft( array('sfoi'=>'sales_flat_order_item'), 'main_table.entity_id=sfoi.order_id', array( 'sku' =>'sfoi.sku' ) ); $collection->addExpressionFieldToSelect ( "sku", "GROUP_CONCAT(sku SEPARATOR ' , ')", $fields="" ); $collection->getSelect()->group("entity_id"); $collection->getSelect()->join...
Read more