Tech Discussed

Category: SQL/PLSQL

  • 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…

  • 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…