Happy New Year 2018

I know that I am not updating this site at all now but I still have tons of new content to share with you guys. The only problem is that I am not getting enough time to churn out new content for maintaining this one. I know I can hire external writers but you know they are costly 🙂

But worry not I will be back very soon with new content. So stay tuned till then…

BTW Happy New Year 2018

Flipkart resolved the bug in their website which prevents Navi Mumbai customers to order from sellers other then WSRetail

As most of the Flipkart customers from Navi Mumbai must have known or experienced, that most of the times their area pin code was not working for most of the sellers on Flipkart except for one, that is WSRetail.
Continue reading “Flipkart resolved the bug in their website which prevents Navi Mumbai customers to order from sellers other then WSRetail”

UB7.NET launched the all new 64 slots pure rush battlefield 4 server in Asia

Hi all,

UB7.NET had recently launched the all-new 64 slots Battlefield 4 Pure Rush server in the Singapore region. We have collaborated with Ignite ESports clan from India and presently our server is running under their banner.

The server is first of its kind for the Asian region where hardly there is any proper rush server for BF4. We will soon be shifting the server to another provider in order to resolve some of the issues.

So enjoy your stay on our server.

How to create an identity column in Oracle 11 g?

Hi all,

I was just wondering about the fact that how to create an auto increment column in oracle. It is quite easy to create an auto increment column in sql server but in oracle’s old version that is 11, it is bit of an overwork for you. Well it is not that difficult if you are using SQL developer but in case you are creating the table from CLI on Unix or other CLI based operating system than you need to know that to create an auto increment column in oracle you need to first declare a sequence using the below structured query:

create sequence name_of_sequence

Once you have executed the above query you will have to create a trigger of type before on the newly created table where you want the auto incremented column. The structured query for the same is mentioned below:

create or replace trigger name_of_trigger before insert on new_tbl_name
for each row
begin
select name_of_seq.nextval into :new.auto_incremented_col_name from dual
end

Congrats you have just created the column with auto incremented values

What are some of the basic permissions which you need to grant to a newly created user in Oracle?

Well this is not a difficult answer at all but i was facing some weird issues with Oracle .Net provider when i had tried to login with the newly created user. Before you try to login with a newly created user in Oracle .NET provider, please first give that user some basic set pf permissions.

 I don’t know which is the key permission below, which had successfully helped me in login into the .NET provider interface but here are the permission

 

GRANT create session TO demo_user;

GRANT create table TO demo_user;

GRANT create view TO demo_user;

GRANT create any trigger TO demo_user;

GRANT create any procedure TO demo_user;

GRANT create sequence TO demo_user;

GRANT create synonym TO demo_user;