SQLDeveloper is not connecting to remote database

I have already written a post on SQL Developer connectivity problem. But recently I got one new error while connecting SQLDeveloper to remote database. First as I mentioned in my last post set proxy if you are using any in your SQLDeveloper and then try to connect it. But If it still gives the error then tried this workaround and I hope it will be helpful too. Sometime when we are connecting more than one internet connection due to any reason like client sides visit, home, office etc, our network connection get increased under network and sharing center and at a time more than one network remain Enable even if they are not connected to any network, so here comes the problem. Disable all of your network you are not using currently like I did in below screenshot and just Enable only network you are currently working with. After doing this try to connect your SQLDeveloper with remote DB again and it should work now and I hope it will be helpful too.

Read More

Create Sequence in SQL Oracle, Create Trigger on Insert and Update in Oracle

Sequence in Oracle SQL. Following is the basic code to create a sequence in Oracle SQL

CREATE SEQUENCE sequence_name
START WITH 1
INCREMENT BY 1
MAXVALUE 99999999
MINVALUE 1
NOCYCLE;

Trigger on insert and update on any table 

Following code can be used to create a trigger on any table, It will invoke and do what you want when any value will get inserted and update in table

create or replace trigger trigger_name before insert OR update on table
for each row begin

write you logic here what should happen when trigger gets invoke.
end;

Read More