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

NOCYCLE sequence

SQL> -- A NOCYCLE sequence
SQL>
SQL>
SQL> CREATE SEQUENCE StudentNumSeq
  2 INCREMENT BY 50000
  3 START WITH 50000
  4 MAXVALUE 99999
  5 NOCACHE
  6 NOCYCLE;

Sequence created.

SQL>
SQL>
SQL> select studentNumSeq.nextVal from dual;

  NEXTVAL
----------
  50000

SQL> select studentNumSeq.nextVal from dual;
select studentNumSeq.nextVal from dual
  *
ERROR at line 1:
ORA-08004: sequence STUDENTNUMSEQ.NEXTVAL exceeds MAXVALUE and cannot be instantiated


SQL> select studentNumSeq.nextVal from dual;
select studentNumSeq.nextVal from dual
*
ERROR at line 1:
ORA-08004: sequence STUDENTNUMSEQ.NEXTVAL exceeds MAXVALUE and cannot be instantiated


SQL>
SQL>
SQL> drop sequence studentNumSeq;

Sequence dropped.


Note:-Please comment and reply me.

Read More

Sequence cache option

Sequence cache option 

SQL> -- the cache option specifies how many sequence values will be stored in memory for
faster access
SQL>
SQL>
SQL> CREATE SEQUENCE mySequence
  2 MINVALUE 1
  3 MAXVALUE 999999999999999999999999999
  4 START WITH 1
  5 INCREMENT BY 1
  6 CACHE 20;

Sequence created.

SQL>
SQL> select mySequence.nextval from dual;

  NEXTVAL
----------
  1

SQL> select mySequence.nextval from dual;

  NEXTVAL
----------
  2

SQL> select mySequence.nextval from dual;

  NEXTVAL
----------
  3


Note:-Please comment and reply me.

Read More