Oracle DB: Data Types
Oracle Built-In Data Types: Datatype Description VARCHAR2(size [BYTE | CHAR]) Variable-length character string having maximum length size bytes or characters. Maximum size is 4000 bytes or characters, and minimum is…
css-example
<style type="text/css"> .tableCell, .simpleTableCell, .simpleTableDarkCell, .subTable, .rowHeaderCell, .rowHeaderDarkCell, .columnHeaderCell, .columnHeaderDarkCell, .subRowHeaderCell, .subRowHeaderDarkCell, .subRowTotalCell, .subRowTotalDarkCell, .subRowCell, .subRowDarkCell { border:2px solid rgb(60,60,60); text-align:center; font-size:12px; font-family:Arial; padding:0px; margin:0px; border-collapse:collapse; } .simpleTableCell,.simpleTableDarkCell{ border:1px…
Joomla: Sections VS Categories
A Section contains one or more categories, and each Category can have articles assigned to it. One Article can only be in one Category and Section. For example, you might…
Joomla: Special VS Registered items
The difference between Special and Registered items in Joomla is that any user created as Author Editor Publisher Manager Administrator Super Administrator is considered a Special User, therefore can view…
HTML: Color Codes
aliceblue F0F8FF aliceblue aliceblue aliceblue aliceblue antiquewhite FAEBD7 antiquewhite antiquewhite antiquewhite antiquewhite aqua 00FFFF aqua aqua aqua aqua aquamarine 7FFFD4 aquamarine aquamarine aquamarine aquamarine azure F0FFFF azure azure azure azure…
MySQL: BackUp – Restore DB (mysqldump)
mysql> show databases; MySQL Export:-------------mysqldump -u root -p --databases myschema > /var/www/html/myschema/backup_db/MySchema_20101228.sqlMySQL Import:-------------mysql -u root -p --database myschema < /home/nista/myschema_temp/MySchema_20101228_1458.sqlMySQL Export just the schema:------------------------------mysqldump -u root -p --no-data myschema >…
MySQL: Data Types
MySQL data types: CHAR( ) A fixed section from 0 to 255 characters long.VARCHAR( ) A variable section from 0 to 255 characters long.TINYTEXT A string with a maximum length…
Oracle 10g: Create Heterogenous DBLink to connect to other databases
To create an heterogenous database link (to another database):1) set an odbc connection named testdb and in advanced put username/password (admin/admin)2) put inittestdb.ora in D:\oracle\product\10.2.0\db_1\hs\admin (* see below)3) put tnsnames.ora…
Oracle 10g: Clean SQL execution Cache
The statement below clears the cache, so you can run benchmarks against SQL execution: alter system flush buffer_cache
- Go to the previous page
- 1
- …
- 3
- 4
- 5
- 6