how-to create a generic autoincrement id trigger in oracle

--CREATE A SEQUENCE

CREATE SEQUENCE  "SEQ_TBL_NAME"  

MINVALUE 1 MAXVALUE 999999999999999999999999999 

INCREMENT BY 1 START WITH 1 

CACHE 20 NOORDER  NOCYCLE ;

-- CREATE  THE TRIGGER 

CREATE OR REPLACE TRIGGER "TRG_TBL_NAME" 

BEFORE INSERT ON "TBL_NAME"

REFERENCING NEW AS New OLD AS Old

FOR EACH ROW

   DECLARE

   tmpVar NUMBER;

BEGIN

   tmpVar := 0;

   SELECT SEQ_TBL_NAME.NEXTVAL INTO tmpVar FROM dual;

   :NEW.TBL_NAME_ID:= tmpVar;

END TRG_TBL_NAME; 

/

ALTER TRIGGER "TRG_TBL_NAME" ENABLE;

COMMIT ; 

list with the best chrome extensions

1. force background tab
2. Ctrl + PgDown and Ctrl + PgUp to move tabs
3. new tab at the end
4. might text - sms from computer
5. gliffy diagrams
6. window resizer - emulate different phone screens for html development
7. tabman tabs manager - Alt + Z , start typing to search your open tab , click with mouse to select the desired one ...

how-to decrypt oracle sql developer passwords you lost

1. Export your connections from the Sql Developer into a let say connections2.xml file
2. Copy the code from this link into a Decrypt.java file
vim Decrypt.java
3. Go to the dir holding this file
cd '/cygdrive/C/Users/KON0136/AppData/Roaming/SQL Developer/'
4. search for the decrypted pass by a word
grep -i -A 4 to search connections2.xml

java Decrypt 05FFAA7FB3D2158G0F3BA16BF8702F8ED7A83779C2E6B93986F6406EEA81F6FA11
5. Compile the class
javac Decrypt.java
# or in
'/cygdrive/C/Program Files/Java/jdk1.8.0_20/bin/javac.exe' Decrypt.java
6. Get the password
java Decrypt 05FFAA7FB3D2158G0F3BA16BF8702F8ED7A83779C2E6B93986F6406EEA81F6FA11