Add Icon to webpage url

To add an icon to your URL:

1. You need an icon. There are plenty of icons on your pc to pick from. Use windows search and look for *.ico Or you can create one go here
2. Upload the icon to your directory on line the same location of the index.html
3. Rename the icon on line to favicon.ico
4. Add both lines below to the head of your index.html page

<.link rel="icon" type="image/ico" href="favicon.ico"><./link>
<.link rel="shortcut icon" href="favicon.ico"><./link>


Also you can add an animated icon, just create an animated gif 16 x 16 and upload it to the root directory and add this code. It works only with Firefox browser. 


<.link rel="shortcut icon" type="image/gif" href="animated_favicon.gif">


They all will look like this 


<.link rel="shortcut icon" type="image/ico"favicon.ico">
<.link rel="shortcut icon" type="image/gif" href="animated_favicon.gif">
<.link rel="shortcut icon" href="favicon.ico">


Also just upload the favicon.ico to the root directory of the site all new browsers will find it.

Read More

Creating a trigger based on two tables

SQL>
SQL>
SQL> CREATE TABLE myTable1 (a INTEGER, b CHAR(10));

Table created.

SQL>
SQL> CREATE TABLE myTable2 (c CHAR(10), d INTEGER);

Table created.

SQL>
SQL>
SQL> CREATE TRIGGER trig1
  2 AFTER INSERT ON myTable1
  3 REFERENCING NEW AS newRow
  4 FOR EACH ROW
  5 WHEN (newRow.a <= 10)
  6 BEGIN
  7 INSERT INTO myTable2 VALUES(:newRow.b, :newRow.a);
  8 END trig1;
  9

Trigger created.

SQL>
SQL> insert into myTable1 values(1,'a');

1 row created.

SQL> insert into myTable1 values(2,'b');

1 row created.

SQL>
SQL> select * from myTable1;

  A B
---------- ----------
  1 a
  2 b

SQL> select * from myTable2;

C D
---------- ----------
a 1
b 2

SQL>
SQL> drop table myTable1;

Table dropped.

SQL> drop table myTable2;

Table dropped.

Note:-Please comment and reply me.

Read More