To create a primary key

ALTER TABLE <table_name> ADD CONSTRAINT <primary_key_constraint_name> PRIMARY KEY (<column_name>) USING INDEX

To drop a primary key:

ALTER TABLE <tablename> DROP PRIMARY KEY

To view all the indexed columns includin the primarky key columns:

SELECT * FROM user_ind_columns WHERE table_name='<tablename>' ORDER BY index_name, column_position

To view the constraint names on a table (including the primary key name):

SELECT * FROM user_constraints WHERE table_name = '<tablename>'

To view the constraint columns and constraint names on a table (including the primary key):

SELECT * FROM user_cons_columns WHERE table_name = '<tablename>'

Good oracle reference:
http://www.psoug.org/reference/constraints.html

1. Hit either shift key five times.
2. Select settings.
3. On the keyboard tab, and under filter keys, make sure 'use filter keys' is NOT checked.
4. Under filter keys again, select settings. Uncheck every box.
5. Now click the general tab
6. Under Administrative options uncheck both check boxes if checked. If not checked check them, click apply, ok, and then go back into it, and uncheck them.

As of this article, no one has released a native Insteon IR remote control.  However since all Insteon devices are backwards compatible with X10, there is a solution.

Assigning an X10 address to an Insteon device and using an IR543 X10 Infrared Commander Center allows a programmable IR remote control to control your Insteon device.

I use a Harmony 880 remote to control my home theater and my Insteon lights.

It turns out because of the way the Harmony remotes work, they are not best suited for X10 in some situations because they do not allow for macros. For example you can add x10 commands to your activity startup/shutdown but can not have it send an x10 command after pressing the pause button.

Also for anyone else interested in using the IR543 X10 Infrared Commander Center with a Harmony Remote (The 880 in my case), see this link: http://www.remotecentral.com/cgi-bin/mboard/rc-harmony/thread.cgi?3765 which includes a few tips and tricks.

I hope this is helpful.

As of this article, no one has released a native Insteon RF remote control.  However since all Insteon devices are backwards compatible with X10, there is a solution.

For less than $30 I ordered RR501 Wireless RF Transceiver and a KR22A Credit Card Keychain Controller online from Automated Outlet.

I first used the free InHomeFre software application to receive the X10 signal on the powerline and convert it to an Insteon signal.  However there were two problems with this.  The first is that the room I wanted to control the lights in is on the opposite phase as the computer running the software.  Because I do not have a phase coupler and am not willing to invest to much money in legacy X10 technology I had to locate the RF receiver on the other side of the house near the computer.  The distance between the remote control and the X10 RF receiver caused about a 75% reliability factor.  This is unacceptable, granted we are talking X10 here so I don't expect 100%.  The second problem was that by using the InHomeFre software (along with an Insteon PowerLinc V2 USB) there was a delay of a second or two between pressing a button on the remote and the light responding.  So I deemed this solution just not acceptable on both counts.

Knowing that insteon devices are backwards compatible with X10 I decided to give that a try.  I moved the X10 RF receiver into the same room I wanted to control and used the remote to set the X10 address on each device.  This went very smoothly.  I then tested the remote on each device and it just worked.  It's about 99% reliable and the delay between pressing the button and the light reacting is barely noticeable.