Oracle, Blog&Ubuntu

How to crack Office 2016 on Windows 10

2017-05-17T20:59:00.000-07:00

How to crack Office 2016 on Windows 10

:) Hi there,
Today i will share "How to crack Office 2016 on Windows 10"
I think it will come to piece of cake, then only thing that you need is downloading RE-Loader1.4RC3.

Then let us start!!!

1.

Shutdown your antivirus or you can just disable it.

2.

Disable Windows defender
Follow this way if you have difficulty in Disabling Windows defender :)
https://www.aplikasipc.com/cara-mengaktifkan-menonaktifkan-windows-defender-real-time-protection-di-windows-10/

3.

Run RE-Loader1.4RC3.
Choose checkbox "016"
Push Button "Active"

4.

Done!!!

How to Install AMD ATI Radeon Graphics Drivers in Ubuntu

2016-08-17T01:12:00.001-07:00

:) hi fellas
I have Lenovo G40 AMD A8 and i wanna install my laptop with Linux Mint 17.2
as like as ubuntu 14.20.
Unfortunately, i have a problem with graphics driver using ubuntu 14.20.

Now i will share you How to Install AMD ATI Radeon Graphics Drivers in Ubuntu.

1.

sudo add-apt-repository ppa:org-edger/ppa

sudo apt-get update

2.

sudo apt-get install fglrx

3.

Reboot your computer and done :)

Note :

If you installed the wrong driver or make some others mistake.
you should delete your driver using this command

sudo aticonfig --uninstall

Reboot your computer

sudo shutdown -r now

#source : https://www.youtube.com/watch?v=Ka5gBMlo-zo

DBlink from oracle 10g/XE to sql server

2016-06-16T23:55:00.001-07:00

How to create database Link Oracle 10g / XE to MYSQL Server

:) Hi there, a few days ago, i had a problem that makes me to use oracle 10g dblink to sql server.
This is my first time to do this and i do not sleep around 4 days for finding how to do this properly.
When i tried the procedures that i searched on google. . .there are so many errors i faced. at last fortunately i managed connecting oracle to MYSQL server. . . :)

I,m Using

OS: WIN7
ODBC DSN : hsodbc
DB1 : oracle XE
DB2 :MYSQL Server
DB2 : user "a" pass "a"

Database link from oracle 10g to sql server :

1.Setting up a system DSN(Data Source Name)
2.Setting hsodbc(oracle XE/10g)/dg4odbc(oracle11g-12c)
3.Setting tnsname.ora / listener.ora
4.Create db link to MYSQL
done!

1.

Configure ODBC by setting up a system DSN(Data Source Name)
Typically you can find this at
Start->Settings->Control Panel->Administrative Tools->Data Sources(ODBC)

2.

Look for inithsodbc.ora in $ORACLE_HOME/hs/admin/
Make a copy of it and rename it to init<your odbc Data Source Name>.ora
Remember we had chosen "hsodbc" as our DSN.
Open the file and enter the DSN that you just created recently i.e "hsodbc".
This is how $ORACLE_HOME/hs/admin/inithsodbc.ora should look like:

# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = hsodbc
HS_FDS_TRACE_LEVEL = 0

#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

3.

Configure listener.ora
$ORACLE_HOME/network/admin/listener.ora

SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = hsodbc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
      (PROGRAM = hsodbc)
    )
)

Note: SID_NAME should be your DSN name. PROGRAM=hsodbc or dg4odbc tells Oracle to use heterogenous services.

4.

Configure tnsnames.ora
$ORACLE_HOME/network/admin/tnsnames.ora

HSODBC =
(DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Lab)(PORT = 1521))
    (CONNECT_DATA = (SID = hsodbc))
      (HS = OK)
    )

HOST = Oracle Host
PORT = Oracle PORT
SID = your DSN name

Restart your listener to make sure the settings are in effect.

lsnrctl stop
lsnrctl start

You can now validate the connection to your SQL Server database by the normal Oracle tnsping utility.

tnsping hsodbc

TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 01-DEC-2004 13:19:54

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used TNSNAMES adapter to resolve the alias
Attempting to contact

OK (30 msec)

5.

Make sure that global_names parameter is set to false
SQL> sho parameter global_names

NAME TYPE VALUE
------------------ ---------------- -------
global_names boolean FALSE

Create a database link:

CREATE DATABASE LINK <<dblinkname>> CONNECT TO <<user MYSQLServer>> IDENTIFIED BY <<password MYSQLServer>> USING '<<connection string>>';

Example:
SQL> CREATE DATABASE LINK hsodbc CONNECT TO a IDENTIFIED BY a USING 'hsodbc';

Database link created.

We have completed our configuration.

Example:
SQL> desc emp@hsodbc

Name          Null?      Type
------------- --------   --------------
EMPID         NOT NULL   NUMBER(1)
EMPNAME                  VARCHAR2(60)
CREATED                  DATE

Note :

Check Whether HSODBC is Installed

The first common error is people do not check the OracleDB has installed hsodbc/dg4odbc on the DB or not.

The full text of the error reported to us was:

ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
You may get this error if:

Oracle fails to connect to DG4ODBC/HSODBC. DG4ODBC/HSODBC cannot retrieve the underlying error from the ODBC driver.

open command prompt / terminal go to $ORALCE_HOME/bin

cd $ORALCE_HOME/bin
hsodbc

you will see something similar to the following if HSODBC is installed:

hsoodbc: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV)

If you get HSODBC: empty, your version of Oracle does not include HSODBC.

if you find this error

ORA-00942 table of view does not exist

MYSQLServer is not case sensitive as long as you omit the quotes. The following names are all identical:
TEST2, test2, Test2, TeSt2

The following tables are different:
"TEST2", "test2", "Test2"

So, use double quote (") between your table name, because oracle will send upper case command by default.

:) i hope it will help your problem.

#http://www.dbforums.com/showthread.php?1662981-Must-double-quote-table-name

#http://www.databasejournal.com/features/oracle/article.php/3442661/Making-a-Connection-from-Oracle-to-SQL-Server.htm

How to convert mp4 file to mp3 on ubuntu

2015-08-31T00:31:00.001-07:00

How to convert mp4 file to mp3 on ubuntu

1.

open terminal and type this command

ffmpeg -i source_filename -vn -ab 192k -acodec libmp3lame -ac 2 output_filenamer

source : #http://askubuntu.com/questions/84584/converting-mp4-to-mp3
#http://askubuntu.com/questions/13737/what-packages-do-i-install-for-ffmpeg-and-libmp3lame

Unknown encoder 'libmp3lame'

2015-08-31T00:28:00.002-07:00

Unknown encoder 'libmp3lame'

How to solve "Unknown encoder 'libmp3lame'" message?

1.

sudo apt-get install ffmpeg

2.

you can also try to install the libmp3lame0 package:

sudo apt-get install libmp3lame0

sudo apt-get install libavcodec-extra-53

done!

i hope it solve your problem.

source : #http://askubuntu.com/questions/84584/converting-mp4-to-mp3
#http://askubuntu.com/questions/13737/what-packages-do-i-install-for-ffmpeg-and-libmp3lame

.mkv video files are not playing in the video player & VLC in Ubuntu 14.04

2015-03-31T20:40:00.002-07:00

.mkv video files are not playing in the video player & VLC in Ubuntu 14.04

.mkv file is not able to play in the default Video player in Ubuntu 14.04. It shows codec missing error.

Tried to play in VLC, again same issue.

In both the players audio is perfect. only the problem with the video.

Solve it with install

sudo apt-get install ubuntu-restricted-extras

#source : http://ubuntuforums.org/showthread.php?t=2224597

Ubuntu : How to solve "They have been ignored, or old ones used instead."

2015-02-04T21:55:00.000-08:00

Ubuntu : How to solve "They have been ignored, or old ones used instead."

When we use Ubuntu with higher version some time we will find this message
after typing sudo apt-get install . . .

"Some index files failed to download. They have been ignored, or old ones used instead."

Because ubuntu does not support the older versions any more.
:(
but do not worry about it.
We can install the older software on our hinger Ubuntu version.

1.

sudo wget "http://pastebin.com/raw.php?i=uzhrtg5M" -O /etc/apt/sources.list

2.

sudo apt-get update

3.

done!

#source : http://askubuntu.com/questions/329450/e-some-index-files-failed-to-download-they-have-been-ignored-or-old-ones-used

How to Add or create default gateway from terminal in Ubuntu

2014-07-14T21:35:00.000-07:00

How to Add or create default gateway from terminal in Ubuntu

I've been so rarely using terminal for my working in ubuntu, and sometime i have to use terminal to remote my server.

I ll share you "How to Add or create default gateway from terminal in Ubuntu"
because i have cased for changing default gateway on my server.
I had a little confused before but i found an article and it was helpful.

It,s piece of cake.

1.

open terminal

2

sudo route add default gw 192.168.1.251 eth0

3

sudo /etc/init.d/networking restart

done!

source : http://www.wikihow.com/Add-or-Change-the-Default-Gateway-in-Linux

How do I fix a “Problem with MergeList” or “status file could not be parsed” error when trying to do an update?

2014-06-03T21:48:00.002-07:00

How do I fix a “Problem with MergeList” or “status file could not be parsed” error when trying to do an update?

These terminal commands should solve your problem:

1.

Remove the Merge List by opening a terminal (Press Ctrl+Alt+T to launch) and run this command:

sudo rm /var/lib/apt/lists/* -vf

2.

Next, generate a new one by running a simple update:

sudo apt-get update

#source : http://askubuntu.com/questions/30072/how-do-i-fix-a-problem-with-mergelist-or-status-file-could-not-be-parsed-err

CSS text shadows for your blog

2013-11-17T03:38:00.001-08:00

Hi fellas, long time no see.
yeah, it,s my first time i touch my blog.
It has been 5 months i never updated my blog.
it's so long right?

Now i ll share a little bit about text shadow.

About Text Shadow

The text-shadow property is super easy to work with and works well across all modern browsers without even so much as a vendor prefix! However, as far as I can tell, IE support, even up through IE9, is zilch. However, using tools like Modernizr will help you pull off advanced CSS3 effects even in silly old IE.

Syntax

1.Standard

text-shadow: 2px 4px 3px rgba(0,0,0,0.3);

2.Quick and Dirty Letterpress

body {
    background: #222;
}

#text h1 {
    color: rgba(0,0,0,0.6);
    text-shadow: 2px 2px 3px rgba(255,255,255,0.1);
}Quick and Dirty Letterpress

3.Hard Shadow

text-shadow: 6px 6px 0px rgba(0,0,0,0.2);

4.Double Shadow

text-shadow: 4px 3px 0px #fff, 9px 8px 0px rgba(0,0,0,0.15);

5.Down and Distant

text-shadow: 0px 3px 0px #b2a98f,
                 0px 14px 10px rgba(0,0,0,0.15),
                 0px 24px 2px rgba(0,0,0,0.1),
                 0px 34px 30px rgba(0,0,0,0.1);

6.Close and Heavy

text-shadow: 0px 4px 3px rgba(0,0,0,0.4),
0px 8px 13px rgba(0,0,0,0.1),
0px 18px 23px rgba(0,0,0,0.1);

There are still many CSS text shadows that you can create.
Basically CSS text-shadows are simple to implement on basic form and you will find variety of different forms if you really put some work on them.

That's all for to day. mix and max your CSS text shadows and find more text effects on the source bellow.
:)

#source : http://designshack.net/articles/css/12-fun-css-text-shadows-you-can-copy-and-paste/

Oracle DataBase Cold Backup scritp

2013-08-15T19:12:00.001-07:00

Oracle DataBase Cold Backup scritp

Oracle DataBase Cold Backup scritp. . .
It will help your work and easy to use.
Please drop a comment to tell me, if U find the wrong script or this script is not working.

1.

file name : cold_backup.sh

#!/bin/sh
date
echo " Performing Cold backup . . . "
echo " --------------------------------"
echo " Shuting down the databse . . ."
echo " --------------------------------"
./shutdb.sh
echo " Copy data file . . . "
echo " --------------------------------"
cp -R -p /media/data1/oracle/oradata/ /media/data1/backup/oradata/
echo " --------------------------------"
echo " Restarting the database . . . "
echo " --------------------------------"
./startdb.sh

2.

file name : shutdb.sh

sqlplus / as sysdba << EOF
set feedback on
set echo on
shutdown immediate;

exit
EOF

3.

file name : startdb.sh

lsnrctl start
sqlplus / as sysdba << EOF
set feedback on
set echo on
startup;

exit
EOF

note :
i'm working under *Ubuntu 10.10 and using *Oracle 10g.

furiusisomount

2013-06-14T04:30:00.000-07:00

furiusisomount

Furius ISO Mount is a simple application for mounting ISO, IMG, BIN, MDF and NG image files even without burning them to disk.

It provides the following features:
- Automatically Mounts ISO, IMG, BIN, MDF and NRG image files.
- Automatically creates a mount point in your home directory.
- Automatically Unmounts the Image files.
- Automatically removes the mount directory to return your home
directory to its previous state.
- Automatically saves the history of the last 10 images mounted.
- Mounts multiple images.
- Burn ISO and IMG Files to optical disk.
- Generate Md5 and SHA1 checksums.
- Automatically retrieves any previously unmounted images.
- Automatically generates a log file of all commands needed to
mount and unmount images manually.

https://launchpad.net/furiusisomount

Sequence current value and next value

2013-05-21T01:07:00.002-07:00

Sequence current value and next value

SQL>
SQL> -- It is important to note that the value of CURRVAL is not populated until
after NEXTVAL has been used.
SQL>
SQL>

SQL> CREATE SEQUENCE StudentNumSeq
  2 INCREMENT BY 1
  3 START WITH 1100
  4 MAXVALUE 99999
  5 NOCACHE
  6 NOCYCLE;

Sequence created.

SQL>
SQL>
SQL> select StudentNumSeq.NEXTVAL from DUAL;

   NEXTVAL
------------------------
   1100.00

SQL>
SQL>
SQL> SELECT StudentNumSeq.CURRVAL FROM DUAL;

   CURRVAL
------------------------
   1100.00

SQL>
SQL>
SQL> drop sequence StudentNumSeq;

Sequence dropped.

SQL>
SQL>

source : http://www.java2s.com/Code/Oracle/Sequence/Sequencecurrentvalueandnextvalue.htm

How to Add Social Media Buttons to Blogger Posts

2013-05-11T08:50:00.002-07:00

Sometime we do not satisfied with the original Social Media Buttons on blogger.

We wanna mix the Original Social Media Buttons,

and hope our blog looks a bit different with others.

You know it is pretty simple.

How to Add Social Media Buttons to Blogger Posts?

1.

Go to Dashboard >> Design - Edit HTML >> Expand Widget Template

2.

Use (CTRL + F) to find this code:

<data:post.body/>

Button positioning :

1. To position the buttons at the bottom of post, place te code bellow <data:post.body/>

2. To position the buttons at the top of post, place te code above <data:post.body/>

Code :

<b:if cond='data:post.isFirstPost'>

var js, fjs = d.getElementsByTagName(s)[0];

if (d.getElementById(id)) {return;}

js = d.createElement(s); js.id = id;

js.src = "http://connect.facebook.net/en_US/all.js#xfbml=1";

fjs.parentNode.insertBefore(js, fjs);

}(document, 'script', 'facebook-jssdk'));

</script>

(function() {

var po = document.createElement('script'); po.type = 'text/javascript'; po.async = true;

po.src = 'https://apis.google.com/js/plusone.js';

var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(po, s);

})();

</script>

</b:if>

<a class='twitter-share-button' data-count='horizontal' data-lang='en' data-related='' data-via='' expr:data-text='data:post.title' expr:data-url='data:post.url' href='https://twitter.com/share'>Tweet</a>

</div>

<g:plusone annotation='bubble' expr:href='data:post.url' size='medium'/>

</div>

<fb:like colorscheme='light' expr:href='data:post.url' font='' layout='button_count' send='true' show_faces='false'/>

</div>

<b:if cond='data:blog.pageType == "item"'>

</div>

#pin-wrapper > a {background-image:none !important;}

</style>

</b:if>

</div>

3.

When done, save your template and exit.

Thanks for coming, and share this article if you find it useful.

source : http://www.digitalkonline.com/blog/how-to-add-social-media-buttons-to-blogger-posts/

How to Backup & Restore Blog Posts Using Blogger Import/Export Feature

2013-05-06T05:26:00.000-07:00

Blogger has an awesome feature to download and save blog posts on your computer. Of course, you can later restore the posts as well. Additionally, you can also move your posts to some other blogging platform using the export feature or to some other Blogger blog. I'd highly recommend to regularly backup your posts. Check out the instructions to see how to do it.

1- Export or Backup Blog Posts to Your Computer

1. Chose Settings from the list of options. You can press the drop down arrow button to see more options.
2. In the Settings section, click Other from the left menu.
3. You'll see 3 options in Blog Tools. Click Export blog. A window will open where you'd have to click the Download Blog button.
4. An .XML file will be downloaded to your computer. Make sure to give it a proper name and keep it safe. This file will be used to restore your posts later.

2- Import or Restore Blog Posts From Your Computer

1. Chose Settings from the list of options. You can press the drop down arrow button to see more options.
2. In the Settings section, click Other from the left menu.
3. You'll see 3 options in Blog Tools. Click Import blog. A window will open where you'd have to browse the file on your computer & click the Import Blog button.
4. If you're importing posts from some other blog then make sure that Automatically publish all imported posts is not checked.
5Now your posts have been imported or restored.

Automatically Mount Partitions on Ubuntu

2013-04-17T18:44:00.001-07:00

Automatically Mount Partitions on Ubuntu

There are broadly two aproaches -

Per-user mounting (usually under /media)

Systemwide mounting (anywhere, often under /mnt)

Per-user mounting does not require root access, it's just automating the desktop interface. Systemwide mounts (/etc/fstab) can allow access from before login, and are therefore much more suitable for access through a network, or by system services.

Viewing the system's physical information

To read the layout of the physical disks in the system, the 'fdisk' command is used. Before panicking, realize that fdisk will be used with only non-destructive options; specifically, it will be used with 'l' (lower-case 'L', not '1'), which lists the partition table of the specified disk.

sudo fdisk -l

Disk /dev/sda: 500.1 GB, 500107862016 bytes
255 heads, 63 sectors/track, 60801 cylinders, total 976773168 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 4096 bytes
I/O size (minimum/optimal): 4096 bytes / 4096 bytes
Disk identifier: 0x1baf0215

Device Boot Start End Blocks Id System
/dev/sda1 * 2048 7813119 3905536 82 Linux swap / Solaris
/dev/sda2 7815166 976771071 484477953 5 Extended
Partition 2 does not start on physical sector boundary.
/dev/sda5 7815168 56641535 24413184 83 Linux
/dev/sda6 56643584 447266815 195311616 83 Linux
/dev/sda7 447268864 976771071 264751104 83 Linux

If the system has multiple hard disk drives, multiple lists will be displayed.

Per-User Mounts

You can do the same thing on the command line with the udisks tool easily.

/usr/bin/udisks --mount /dev/sdb1

The bit after --mount is the device name of the partition you want to mount. (/dev/something)

Finding the UUID of your partition

A device name like /dev/sdb1 is based on where your physical drive is plugged in and the order the drives were made available to the computer, so if your computer changes the same command could mount a different partition. It's possible for this to happen just from a software upgrade.

The solution is to use a UUID. A UUID is a globally unique name for the partition. A UUID will remain the same if you put an internal disk into an external USB caddy, or change the name of the partition.

ls -al /dev/disk/by-uuid/

you will see an entry that matches the name :

total 0
drwxr-xr-x 2 root root 120 Apr 18 07:55 .
drwxr-xr-x 5 root root 100 Apr 18 07:55 ..
lrwxrwxrwx 1 root root 10 Apr 18 07:55 78a8d4f4-8739-407b-93fe-7fe23b560e74 -> ../../sda5
lrwxrwxrwx 1 root root 10 Apr 18 07:55 93b20629-db77-4a2f-998c-bc2df0227bbf -> ../../sda1
lrwxrwxrwx 1 root root 10 Apr 18 07:55 bb9a474e-a5a5-4b1c-9b98-e6becda49640 -> ../../sda6
lrwxrwxrwx 1 root root 10 Apr 18 07:55 f24b64fc-93df-4070-8181-4d3c1487763a -> ../../sda7

You can now determine the command you need for mounting the device by UUID. For our example it would be

/usr/bin/udisks --mount /dev/disk/by-uuid/78a8d4f4-8739-407b-93fe-7fe23b560e74

Of course you need to replace 78a8d4f4-8739-407b-93fe-7fe23b560e74 with the UUID of the device you want to mount.

Editing Ubuntu's filesystem table

Sometimes we need to mount our disk automatically.It needs to edit Ubuntu's FS table and

It is possible to break Ubuntu if some of the earlier lines in the file opened during this step are modified, so be sure to read this section carefully.

Ubuntu's filesystem table is located at '/etc/fstab'. Open this file for editing by running the following command for Ubuntu.

gksu gedit /etc/fstab

The file opened contains lines of the form
<device> <location> <Linux type> <options> <dump> <pass>.
Every element in this line is separated by whitespace (spaces and tabs).

# /media/data1 was on /dev/sda6 during installation
UUID=bb9a474e-a5a5-4b1c-9b98-e6becda49640 /media/data1 ext4 defaults 0 2

Save file and exit then restart your computer. It ll mount your disk automatically when your computer start.

source : https://help.ubuntu.com/community/AutomaticallyMountPartitions

How to dress up your popular post widget in blog with CSS

2013-04-08T19:33:00.003-07:00

How to dress up your popular post widget in blog with CSS

How to customize popular post on our blogger blog???

It looks not stylish so here we will see how to dress up this in simple steps.

This will change your fonts and colors and boarder also. And this will not effect on your page speed. Because we are using popular post given by the blogger itself. We are only styling our popular post widget using the cascaded style sheet.

1.

Go to Dashboard >> Design - Edit HTML >> Expand Widget Template

2.

Use (CTRL + F) to find this code:

]]></b:skin>

Now add below css code to above the code :

/*--- Careerandtricks.com Popular Posts --- */

.popular-posts ul{padding-left:0px;}

.popular-posts ul li {background: #FFF url(http://1.bp.blogspot.com/_7wsQzULWIwo/ SmodosCuJCI/AAAAAAAABh4/ZSXbVW9Qpa8/s400/261.gif) no-repeat scroll 5px 10px;

list-style-type: none;

margin:0 0 5px 0px;

padding:5px 5px 5px 20px !important;

border: 1px solid #dddddd;

border-radius:10px;

-moz-border-radius:10px;

-webkit-border-radius:10px;}.popular-posts ul li:hover {

border:1px solid #6BB5FF;

}.popular-posts ul li a:hover {

text-decoration:none;

}

Customization:

For the change of border color in static mode change #dddddd.
For the change of border color in mouse hover mode change #6BB5FF.

3.

When done, save your template and exit.

source : http://www.careerandtricks.com/2012/12/how-to-dress-up-your-popular-post.html

Oracle Function PLSQL: Conversion date to number (hour,min)

2013-03-25T22:54:00.000-07:00

Oracle Function : Conversion date to number (hour,min)

Use this function to get conversion date variable to number(hour,min) :

The function would generate date variable, (date1-date2) becomes number (hour,min)

FUNCTION GET_DURATION(d1 number) RETURN VARCHAR2 IS
--# d1 = tanggal awal
--# d2 = tanggal akhir
tmpvar VARCHAR2(100);
durdays NUMBER(20, 10); -- days between two dates
durhrs BINARY_INTEGER; -- completed hours
durmin BINARY_INTEGER; -- completed minutes
dursec BINARY_INTEGER; -- completed second
durhari PLS_INTEGER;
jhrs number;
jmin number;
thrs number;
BEGIN
durdays := d1;

durhari := TRUNC(d1);

durhrs := MOD(TRUNC(24 * durdays), 24);
durmin := MOD(TRUNC(durdays * 1440), 60);
dursec := MOD(TRUNC(durdays * 86400), 60);

jhrs :=(to_number(durhari)*24)+to_number(durhrs||'.'||lpad(durmin,2,'0'));
thrs :=jhrs;
RETURN(thrs);
END get_duration;

How to use :

select GET_DURATION(date_variable) from dual;

example :

select GET_DURATION(date1-date2) from dual;

select GET_DURATION((date1-date2)-(date3-date4)) from dual;

Oracle Designer 6i: How install SQLLDR on win xp

2013-03-25T20:38:00.002-07:00

Oracle Designer 6i: How install SQLLDR on win xp

A few weeks ago, i was looking for some articles that discuss "How to install SQLLDR on windows xp?" but i did not get satisfactory results.

After studying some of the structures that exist within the application Designer 6i, I did a little improvisation.

Oracle Designer 6i: How install SQLLDR on win xp?

1.

Download SQLLDR package by this link below.
http://www.4shared.com/zip/YEkcRoB3/sqlldr.html?

2.

Exact the file and it contains 2 files "des_817" and "des_817.reg"

3.

Copy folder des_817 onto "C:\des_817"

4.

Run des_817.reg

5.

Set up the network connection by "regedit"
HKEY_LOCAL_MACHINE >> SOFTWARE >> ORACLE >> HOME2

TNS_ADMIN = "your networking path"

mine

TNS_ADMIN = C:\orades\net80\admin

How to use :

1.

Open command prompt (Run >> cmd)

2.

Type this script :

C:\des_817\bin\sqlldr userid=usr/pass@sid control=ctlfile

Oracle Form 6i: How to put database data into List Item(Combo Box)?

2013-03-19T22:12:00.001-07:00

Oracle Form 6i: How to put database data into List Item(Combo Box)?

Last days around, i just tried to make some List Item(ComboBox) that filed from database selected. . .
It's pretty good and easy enough.

1.

Create Program Unit :

PROCEDURE CREATE_Filenames_RG IS
-- Andrew Fraser v2.2 27th May 2010
-- Populate dynamic lookup

   it_id1 Item := Find_Item('block.my_list_item');

   group1_id RecordGroup;

   GRP_status NUMBER;

   V_Space varchar2(10) := ''''||'0'||'''';

BEGIN

  group1_id := Find_Group('FILENAMES_RG');

  IF NOT Id_Null(group1_id) THEN
   delete_group(group1_id);
  END IF;
  group1_id := Create_Group_From_Query('FILENAMES_RG',
   'SELECT field FROM table ORDER BY field') ;

   Grp_status := Populate_Group('FILENAMES_RG');
   IF Grp_status = 0 THEN
If Not Id_Null(it_id1) THEN
If Get_Item_Property(it_id1,Item_Type) = 'LIST' Then
Clear_List(it_id1);
Populate_List(it_id1,'FILENAMES_RG');
   END IF;
END IF;
END IF;

End;

2.

Create/edit triggers to call this:

On form startup:

When-New-Form-Instance on the form as a whole:

CREATE_Filenames_RG;

3.

And/or on mouse click if you want the database table requeried every single time the user clicks on the dropdown:

When-Mouse-Click on the new item itself:

Clear_List('CAS_UPLOAD');
Clear_Item;
CREATE_Filenames_RG;

easy right??

#source : http://andrewfraserdba.com/2010/05/27/oracle-forms-dropdown-list-item-values-populated-from-database-table/

How to set Oracle Database in Arcivelog Mode ::Oracle10g

2013-02-26T18:35:00.000-08:00

How to set Oracle Database in Arcivelog Mode ::Oracle10g

Here;s How to set Oracle Database in Arcivelog Mode ::Oracle10g :

1.

SHUTDOWN immediate;

2.

STARTUP mount;

3.

ALTER DATABASE FLASHBACK ON;

4.

ALTER DATABASE ARCHIVELOG;

5.

ALTER DATABASE OPEN;

The startup command will use a temporary file as pfile with the following init.ora parameters:

6.

ALTER SYSTEM SET log_archive_dest_10 = "LOCATION=/media/data2/oracle_kjks_backup/archivelogs
OPTIONAL REOPEN=300" SCOPE=SPFILE;
spfile='/media/data1/oracle/product/10.2.0/dboracle/dbs/spfileorcl.ora'

25 Things I did After Installing Ubuntu 12.04 LTS "Precise Pangolin"

2013-02-20T17:13:00.001-08:00

Ubuntu 12.04 LTS "Precise Pangolin" is proving everyone wrong. It is perhaps the most loved Ubuntu release since "Lucid Lynx". Unity is now an almost-finished product. The rock solid nature of Ubuntu 12.04 LTS along with bold moves such as the introduction of features like HUD is winning the hearts and minds of geeks and normal-users alike. Here are the things you could do after installing Ubuntu 12.04 to make it an even more useful and finished OS.

Top Things To Do After Installing Ubuntu 12.04 Precise Pangolin

I know, it's late. Usually I come up with this post as and when a new major Ubuntu release happens, which has proved helpful to hundreds of thousands of newbie Ubuntu users to get things rolling in an otherwise alien world. Because of reasons you all know by now, I was not able do it this time around, till now. And since it's already late, I have decided to elaborate the article even further by including every bit of information I could collect regarding the things you could do in Ubuntu 12.04 LTS after installing. So here is it.

First Things First - Installing Restricted Extras During Installation

Starting from Ubuntu 11.04 release, you can install restricted codecs package (which include Adobe Flash, MP3 codecs and such) during installation of Ubuntu OS itself.

Notice the arrows pointing to the boxes in the screenshot above. If you tick both of them during the Ubuntu installation process (make sure you are connected to the internet before doing so), restricted extras package will be installed automatically and you will be able to play mp3's, avi's, mp4's etc. and watch flash videos (YouTube videos for example) right after Ubuntu installation is done with.

But there is a catch. If you have a slow internet connection (which is very rare these days), ticking the boxes shown in the screenshot above will unnecessarily lengthen the installation process. I for one prefer to do all that after installing Ubuntu. If you are like me, the next two steps are for you.

Update Repositories

After you install brand new Ubuntu 12.04, the first thing you need to do is to update repositories and make sure you have the latest updates installed (Like I said before, you need to do this only if you haven't ticked the boxes shown in the above screenshot).

Search for Update Manager in Unity Dash and launch the Update Manager app. Check for updates available and install them if any.

OR you can do this entirely using command line. Open Terminal (Ubuntu 12.04 Keyboard Shortcut: Ctrl + Alt + T) and copy-paste the following command into Terminal.

sudo apt-get update && sudo apt-get upgrade

Done. Ubuntu repositories have been successfully updated.

Install Ubuntu Restricted Extras

Install the "ubuntu-restricted-extras" package. This will enable your Ubuntu to play popular file formats like mp3, avi, flash videos etc. CLICK HERE (to install directly from Ubuntu Software Center) OR simply copy-paste the following command into Terminal to install the package (You need not do this if you have ticked the 'right' boxes before).

sudo apt-get install ubuntu-restricted-extras

Done.

Enable Full DVD Playback in Ubuntu 12.04 LTS

Though installing the restricted extras package will solve most of your problems, you may not be able to play dual layer dvds yet in your Ubuntu. Most commercial DVDs are encrypted with CSS (the Content Scrambling System), which attempts to restrict the software that can play a DVD.

For that, you need to install libdvdcss2 package from medibuntu repositories. Simply copy-paste the following commands into Terminal.

sudo wget --output-document=/etc/apt/sources.list.d/medibuntu.list http://www.medibuntu.org/sources.list.d/$(lsb_release -cs).list && sudo apt-get --quiet update && sudo apt-get --yes --quiet --allow-unauthenticated install medibuntu-keyring && sudo apt-get --quiet update
sudo apt-get install libdvdcss2

Let the process complete, might take some time.

Check for Availability of Proprietary Hardware Drivers

In my case, all the hardware drivers including graphics, sound and wireless drivers were enabled automatically (though, as you can see, I still have a proprietary wireless driver on offer, which I have not activated). But this may not be the case for everyone.

If you are among the not-so-lucky, open Unity dash (Ubuntu 12.04 Keyboard Shortcut: Super key) and search for 'Additional Drivers' application.

Check for additional drivers available and activate the ones you want. In 90% of the cases, this will do the trick. Those who were not able to get their hardware drivers enabled yet will have to do a fair amount of digging through ubuntuforums.

Enable 'Show Remaining Space Left' Option in Nautilus File Browser

Status bar towards the bottom of the Nautilus window shows not only the amount of free space left in the drive but also the number of items in that particular drive/folder. This is a simple yet very useful feature. Do the following to enable it.

Open Nautilus file browser. Go to View - Statusbar. Enable it and you're done.

Calculator Lens/Scope for Ubuntu 12.04

Calculator Lens/Scope for Unity Dash. Do the following to install it in Ubuntu 12.04.

sudo add-apt-repository ppa:scopes-packagers/ppa
sudo apt-get update
sudo apt-get install unity-lens-utilities unity-scope-calculator

Done. Log out and log back in (OR hit Alt + F2, type unity --replace and press Enter) .

Unity Cities Lens/Scope for Ubuntu 12.04

Unity Cities lens/scope for Ubuntu 12.04 is nifty. You just have to open up Dash and type in the city of your choice. It will show you the map, time, temperature and even the wind-speed right in your Unity Dash.

And it is available in the same PPA as above (Calculator Lens). So if you have already installed Calculator Lens from scopes-packagers PPA, all you need to do is this:

sudo apt-get install unity-scope-cities

Done. Log out and log back in.

Install Rotten Tomatoes Lens/Scope for Instant Movie Reviews

If you are a movie buff like me, this one is for you. This particular Unity Lens allows you to search for movie reviews directly from Unity Dash.

Only if this Lens/Scope could show data from IMDB.com as well.

Again, it is available in the same PPA as above (Calculator Lens). So if you have already installed Calculator Lens from scopes-packagers PPA, do the following in Terminal (otherwise, you have to run the first two commands as above).

sudo apt-get install unity-scope-rottentomatoes

Done. More Unity Lenses/Scopes can be found here.

Change Launcher Behavior, Size

No need for third-party apps to do very basic stuff like changing Launcher icon size, behavior etc. You can now do all of that directly from Appearance window.

Right click on the desktop, select Change Desktop Background and Appearance window will pop up. You know what to do (see screenshot above).

Install MyUnity, Packed with Tons of Useful Ubuntu 12.04 Tweaks

CLICK HERE to install MyUnity in Ubuntu 12.04 LTS.

OR copy-paste the following into Terminal.

sudo apt-get install myunity

Done.

Install Unsettings, More Ubuntu 12.04 Tweaking Options, Simpler UI

Unsettings is a newer application with similar tweaking options as MyUnity. More importantly, it has a useful 'Reset to Default' option.

Though unlike MyUnity, it is not available in default Ubuntu repositories. Copy-paste the following commands into Terminal to install Unsettings in Ubuntu 12.04.

sudo add-apt-repository ppa:diesch/testing
sudo apt-get update
sudo apt-get install unsettings

Done.

Ubuntu Tweak: The Most Comprehensive of Them All

Ubuntu Tweak is undoubtedly the most comprehensive tweaking tool for Ubuntu.

Apart from the usual Unity related tweaks, Ubuntu Tweak has a number of other options like a fully functioning Software Center, huge array of scripts to choose from, Computer Janitor to free up space etc. to name a few.

Do the following in Terminal to install Ubuntu Tweak.

sudo add-apt-repository ppa:tualatrix/ppa
sudo apt-get update
sudo apt-get install ubuntu-tweak

Done.

Install Open in Terminal Nautilus Extension

This extension adds a very useful 'open in Terminal' option to Nautilus right click menu.

CLICK HERE to install extension directly from Ubuntu Software Center.

Log out and log back in to enable it (OR hit Alt + F2, type nautilus -q and press ENTER).

And you're done.

Change Panel Transparency

I like my Unity's top panel to be semi-transparent.

In MyUnity, just goto Panel settings to change its transparency.

As you can see, there is also a 'Transparency maximized toggle' option. When it is set to ON, Panel transparency will be OFF for maximized windows. Very nice hack.

Enable Workspace Screen Edge Actions

This is one of my favorite features which can be enabled/modified easily using Ubuntu Tweak. What it does is, you can set each corner of your workspace to do different tasks (which you can choose) on mouse hover action.

Launch Ubuntu Tweak. Goto Tweaks - Workspace.

Install Weather Indicator Applet

CLICK HERE to install Weather Indicator Applet in Ubuntu 12.04 LTS.

After installation, search for weather indicator in Unity Dash and launch the Applet.

Install CPU/Memory Indicator Applet

Useful CPU/Memory load indicator applet that will reside in your top panel.

sudo add-apt-repository ppa:indicator-multiload/stable-daily
sudo apt-get update
sudo apt-get install indicator-multiload

After installing, just search for System Load Indicator in Unity Dash and launch the app.

Install Dropbox Client in Ubuntu 12.04

Apart from Ubuntu One, Dropbox is my favorite cloud storage service. Interface is slick and Dropbox has perhaps the best Linux support among other popular alternatives.

Download Dropbox for Ubuntu 12.04

Simple double click on the downloaded .DEB package to install it.

Afterwards, open Dash, search for Dropbox and launch the app. The daemon will take you through the installation steps further. More screenshots and details.

Install Synaptic Package Manager

With all its bling-bling, Ubuntu Software Center is not a finished product yet. It is still very slow to respond, crashes every now and then and cannot match the functionality aspects of Synaptic Package Manager.

CLICK HERE to install Synaptic Package Manager from Ubuntu Software Center.

Install Google Voice and Video Chat Plugin for Linux

I'm quite an heavy user of Gmail and use its video and voice chat features very often. Fortunately, Google video chat plugin is available for Linux along with Windows n' Mac.

Download Google Video and Voice Chat Plugin for Ubuntu

And simple double click the downloaded DEB file to install it.

Install Ubuntu Software Center Quicklist for Ubuntu 12.04

Ubuntu Software Center Quicklist lets you quickly add PPAs through the software-properties UI and update sources as well. And if you have Synaptic Package Manager installed, you can launch it directly using this quicklist. Do the following to install it.

Copy the original ubuntu-software-center.desktop file to your Home folder. For that, simply copy-paste the following command into Terminal.

sudo cp /usr/share/applications/ubuntu-software-center.desktop ~/.local/share/applications/

Open the file for editing with gedit.

sudo gedit ~/.local/share/applications/ubuntu-software-center.desktop

Copy-paste the following to the bottom of the file.

X-Ayatana-Desktop-Shortcuts=SoftwareUpdates;SoftwareProperties;Synaptic;

[SoftwareUpdates Shortcut Group]  
Name=Update Manager  
Exec=update-manager -c  
OnlyShowIn=Unity

[SoftwareProperties Shortcut Group]  
Name=Add/Edit PPAs  
Exec=gksu software-properties-gtk %u  
OnlyShowIn=Unity

[Synaptic Shortcut Group]  
Name=Synaptic Software Manager  
Exec=gksu synaptic %u  
OnlyShowIn=Unity

Save and exit. Restart Unity (Hit Alt + F2, type unity --replace and press ENTER).

If that doesn't work, log out and log back in.

Install Firefox Quicklist for Ubuntu 12.04

Do the following to install quicklist in Ubuntu 12.04 LTS.

Copy your original firefox.desktop file into your home directory using Terminal.

sudo cp /usr/share/applications/firefox.desktop ~/.local/share/applications

Open the copied file using editing.

sudo gedit ~/.local/share/applications/firefox.desktop

Find and edit the following line (Use CTRL + F shortcut to search for the text).

X-Ayatana-Desktop-Shortcuts=NewWindow;

Replace it with this:

X-Ayatana-Desktop-Shortcuts=NewWindow;SafeMode;ProfileManager;

Done. Now, copy-paste the following lines to bottom of the file.

[SafeMode Shortcut Group]
Name=Open Firefox in safe mode
Exec=firefox -safe-mode
TargetEnvironment=Unity

[ProfileManager Shortcut Group]
Name=Firefox Profile Manager
Exec=firefox -ProfileManager
TargetEnvironment=Unity

Save and exit. Restart Unity (Hit Alt + F2, type unity --replace and press ENTER).

If that doesn't work, log out and log back in.

More useful quicklists can be found here.

Bleeding Edge Script for Ubuntu 12.04 Lets You Install a *Lot* of Useful Apps

Bleeding Edge is a simple script for Ubuntu that lets you install a multitude of applications NOT available in official Ubuntu repositories.

Detailed instructions on how to use Bleeding Edge script in Ubuntu 12.04.

Install GNOME Shell Desktop as an Alternative to Unity

GNOME Shell is available in the default Ubuntu repositories.

CLICK HERE to install GNOME Shell directly from Ubuntu Software Center (OR simply search for gnome-shell in Ubuntu Software Center/Synaptic).

Log out and choose 'GNOME' instead of 'Ubuntu' from login window.

:) That's all, Now you may have to consider to use Ubuntu 12.04 LTS "Precise Pangolin" to be your primary OS.

Just like what Terminator says "I ll be back!" :)

source : http://www.techdrivein.com/2012/06/25-things-i-did-after-installing-ubuntu.html

Counter Strike: Source, Closure, Psychonauts And Shank 2 Available On Steam For Linux

2013-02-06T02:06:00.001-08:00

After Counter-Strike 1.6 and Half-Life 1, another important game is now available in Steam for Linux: Counter-Strike: Source (CS: S), a popular first-person shooter developed by Valve.

Counter-Strike: Source is a remake of the original Counter-Strike, using the Source game engine, in which the gameplay is basically the same as in the original Counter Strike: the counter-terrorists team plays agains the terrorists in a series of rounds.

Counter Strike: Source

Since both Counter-Strike: Source and Team Fortress 2 use the Source engine, it is likely to see more games using this engine available on Linux, like Half-Life 2 and others.

For now, Counter Strike: Source doesn't show up when selecting Linux for the OS in Steam, but the game is available and can be played on Linux - simply don't select Linux for the OS when searching for it.

There's no news on Counter-Strike Global Offensive (CS:GO), the game released in 2012, but considering the rate at which Valve is making their games available on Steam for Linux, it shouldn't be too long until CS:GO will be available for Linux users.

Psychonauts

Shank 2

Along with Counter Strike: Source, Valve has made some other games available for Linux recently: Closure, Psychonauts and Shank 2 (this one doesn't seem to work right now, according to SteamDB, it's missing the executable), but just like CS: S, they don't show up in Steam for Linux if you restrict the search to Linux.

via reddit, game screenshots via store.steampowered.com

source : http://www.webupd8.org/2013/02/counter-strike-source-closure.html

Local Repository 12.10 Quantal Quetzal

2013-02-03T19:15:00.002-08:00

Local Repository 12.10 Quantal Quetzal

I ve been long time not touching this blog, and now i ll share about Local Repository 12.10 Quantal Quetzal, you can easily use it and update your lovely ubuntu by those servers!!!

Here they re :

# Repo lokal untuk ubuntu 12.10 via ITB

    deb ftp://ftp.itb.ac.id/pub/ubuntu/ quantal-proposed main restricted universe multiverse
    deb ftp://ftp.itb.ac.id/pub/ubuntu/ quantal-security main restricted universe multiverse
    deb ftp://ftp.itb.ac.id/pub/ubuntu/ quantal-updates main restricted universe multiverse
    deb ftp://ftp.itb.ac.id/pub/ubuntu/ quantal main restricted universe multiverse

# Repo lokal untuk ubuntu 12.10 via Kambing

    deb http://kambing.ui.ac.id/ubuntu/ quantal-proposed main restricted universe multiverse
    deb http://kambing.ui.ac.id/ubuntu/ quantal-security main restricted universe multiverse
    deb http://kambing.ui.ac.id/ubuntu/ quantal-updates main restricted universe multiverse
    deb http://kambing.ui.ac.id/ubuntu/ quantal main restricted universe multiverse

# Repo lokal untuk ubuntu 12.10 via UKDW

    deb http://repo.ukdw.ac.id/ubuntu quantal main restricted universe multiverse
    deb http://repo.ukdw.ac.id/ubuntu quantal-updates main restricted universe multiverse
    deb http://repo.ukdw.ac.id/ubuntu quantal-security main restricted universe multiverse
    deb http://repo.ukdw.ac.id/ubuntu quantal-backports main restricted universe multiverse
    deb http://repo.ukdw.ac.id/ubuntu quantal-proposed main restricted universe multiverse

# Repo lokal untuk ubuntu 12.10 via Komo

    deb http://komo.padinet.com/ubuntu/ quantal-proposed main restricted universe multiverse
    deb http://komo.padinet.com/ubuntu/ quantal-security main restricted universe multiverse
    deb http://komo.padinet.com/ubuntu/ quantal-updates main restricted universe multiverse
    deb http://komo.padinet.com/ubuntu/ quantal main restricted universe multiverse

source : http://www.teknologiterbaru.net/860/daftar-repository-lokal-untuk-ubuntu-12-10-quantal-quetzal/

Install Nmap 6 on Ubuntu 12.04

2013-01-09T00:50:00.004-08:00

How to install Nmap 6 on Ubuntu 12.04

Fyodor and the Nmap crew today have released the version 6 of the famous Network Mapper. This major release brings 600 significant improvements (see http://nmap.org/6/#changes), the top 6 are:

Nmap Scripting Engine (NSE) – 352 scripts!

Better Web Scanning

Full IPv6 Support

New Nping Tool

Better Zenmap GUI & results viewer

Faster scans
To install the latest Nmap on Ubuntu 12.04 please follow this steps, please note that I’m using Checkinstall to build the .deb package. Using CheckInstall will give an easy way to install or remove the files from the file system.

view sourceprint?

apt-get install build-essential checkinstall

wget http://nmap.org/dist/nmap-6.00.tar.bz2

bzip2 -cd nmap-6.00.tar.bz2 | tar xvf -

cd nmap-6.00

./configure

make

checkinstall

dpkg -i nmap_6.00-1_i386.deb

To try nmap.

nmap -A scanme.nmap.org

source : http://bailey.st/blog/2012/05/22/nmap-6-on-ubuntu-12-04/