Tuesday, April 19, 2011

Oracle SQLPlus



  1. Connect to sqlplus: sqlplus => system => password1 OR sqlplus system/password1@sonlmdb


  2. Show current user: show user;


  3. Show current database: select * from global_name;


  4. OR select instance_name from v$instance;


  5. Create user: create user identified by ;


  6. Grant permission for user: grant connect,resource to ;

Sunday, April 3, 2011

css & html tips


  1. Center align: margin-left: auto; margin-right: auto;

  2. html page always has toolbar: body { overflow-y: scroll; }

  3. Auto redirect to other page: META HTTP-EQUIV="Refresh" CONTENT="0; URL=html-redirect.html">

How to use SingTel BroadCom

1. Plug in the device to USB
2. An drive is mapped to your computer. Run the setup.exe file in there.
3. When be asked for prepaid or postpaid. Select post paid one.
4. Restart the computer
5. Wait for the driver to load completely then click on "Broad Band on Mobile" short cut on desktop.
6. Click connect and you're ready to use.