How to Resolve SQL Injection /Second Order Injection Attack in PL/SQL

When the PL/SQL Code is detected with SQL Injection Error, How to Resolve?

SQL  Injection is simple type of attack and can be avoided with basic coding practices.

Below are some of the ways of best coding practices.

Avoid Dynamic SQL's rewrite them into static SQL.

If you must use dynamic SQL, try not to construct it through concatenation of input values. Instead, use bind arguments.

If you cannot avoid input concatenation, you must validate input values

1. Execute Immediate: This should not be used as it is vulnerable for hacker and hence should be replaced with DBMS_SQL for dynamic execution of the sql queries.

2. Parameters: If the concurrent program is using a procedure which has  a parameter that can be hacked by the user, then you need to sanitize the parameter using .

You can filter the input values using DBMS_ASSERT Functions.

DBMS_ASSERT .QUALIFIED_SQL_NAME is used to verify that the string is a simple SQL name.

DBMS_ASSERT .ENQUOTE_LITERAL should be used if you want to pass the character variable values in quotes. This is used to enclose the string literal within single quotation marks

How to Maintain an Easy Life at Villa Just Like Apartment Life

 

                      HOW TO MAKE LIFE AT EASE @ VILLA

Have you ever experienced the conversation where someone buys a new villa and was excited to share the news with friends or families and the reaction you often see from others is Congratulations!!!!!, We also planned to buy a villa but turns out maintaining a villa was not so easy as we thought it was.

It will be fascinating to buy and become a proud owner of a big house. If you also plan to  manage the big independent home, then it will surely be a magnificent home to live a happy and a healthy life.

When you wish for something then you own it and have a will to find ways to Enjoy.

Below are few easy things that you can plan everyday to  reduce strain

1. Reduce the trips to first floor which needs climbing stairs frequently.

2. Take Bath once a week , in each washroom , this way you can maintain all the washrooms without the need of any maid or help.

3. Have a Basket with rope , this helps to pass on the needed things to upper floors.

4. Book Urban clap for home cleaning every 6 months as a package, this helps to restrain yourself from too much of cleaning ,which might have impact on your health in future.

5. Have a used clothes bin near every wash room.

6. Spend at least 5 minutes of time for each bedroom in the morning which includes quick make over of the bed, arranging misplaced items .

7. Do not use the age old cloth curtains for windows they need lot of maintenance efforts of washing .You can go for latest trend of roller blinds, which only needs dusting and at the same time gives chic look to home with customizations and is also lot maintenance free.

That's all it takes ,bingo!! you are done for the day.