Skip to main content

Learning curve: SQL writing by Unlocking HR schema

Its been a long time since I have studied anything with enthusiasm or a goal to achieve. The last time was when I took MarkLogic CCP but I don’t remember anything on that now, I never got an opportunity to work on it, not even a POC. Now I’m part of study group which has a goal, to get certified in SQL writing.

The learning is exiciting after all the java codes I write and debug its a refreshing change to use SQL. Wait a minute, does that mean I’m not using any SQL database at the back end? No, Yes – my application uses Oracle 11g but I’m not having any SQL developer to work with it, rarely I open SQL + to check if password is to expire.

The bad part is that I have to fill boring tables to query on them, quering is natural to human but not recording :D Some guy said “I’ll find the laziest person to do toughest job so he finds a shortcut” guess he was rit! I found the lazy easy way to query without to having to record.

Unlock the HR user

So I found there is a user called HR who is locked and kept in Oracle 11g Express edition by default. The user has around 7 tables pre-loaded with records – Jackpot! all you have to do is to issue the simplest statement by logging in an user with admin rights, say – SYSTEM or SYS (depends on version and installation)

ALTER USER HR ACCOUNT UNLOCK IDENTIFIED BY password;

Novice tip: Not just 11g its available in many versions; yes as you see password for HR user is password. Done, if you get a message that reads ‘User altered’ hi-five yourself else bring that hand to face and do a face-palm your system admin might have deleted that account

Popular posts from this blog

Up and Close with Sudalai Madan: The Encounter

Night of 13th April all the preparations for the rituals were done in the temple, Sudalaimadam swamies idol was decorated with flowers and fruits and coconuts dedicated to the lord reached above his chest.My cousin Sudalai muthu, senior priest of the shrine reached home by late night got blessings of his father Late Shanmugam Sundaram and blessed the family members in 8x10 room dedicated for God, then started towards the temple. There peoples in huge number were waiting for the Sudalaimada swamy's arrival. Different rituals were offered by people to the Lord in order to get the blessings. As its is believed Sudaimada swamy, son Lord Siva used to consume meat in Kailash for this reason he is sent to earth were he can satisfy his earthy hunger there by not polluting Kailash.



Offering meat to Sudalaimadan is the most important and an watchful event in the festival. Many devotees offer their goat & pig so as to please the lord and get his blessings. That midnight Sudalaimada swamy …

Training @ Cognizant

I received my Date of Joining mail on 16 Oct 2011, I was so happy that finally I got that. I was the only one from my college to get the mail to report on that particular day so I went pretty much alone. I reported in MEPZ on Oct 20th from the next Monday my training began in Siruseri. I was able to spot many people who studied with me in school on the first day of Induction.
Initially I was placed in customized batch then was moved to Advance JAVA or J2EE in a generic term. I got pinned to IME vertical that handles clients related to Information, Media and Entertainment domain.We were trained in batches of 24, curse or charm I got into a batch with 20 girls! Whatever it didn't last for long, I was pretty much comfortable after getting out of it. My school was co-ed but classes were separate for boys and girls never mind 8th and 12th grades, where I was put into co-ed classes because I'm a good boy :P In college I remember studying together with girls nope remember seeing girls…

why do people sweat more in chennai???

One of the famous ornament of chennai is its summer!. Everyone here would have at least once talked about its effect and the way they affected. People comes out with sweats flowing from the body is the usual scene of chennai noon. The sweat produced is not just due to the temperature of the region. It is in fact due to the high humidity of chennai.

To explain this lets see a fact, people in chennai sweats more than the people in delhi where the temperature is higher than the former.

This is because of chennai's location. Chennai is located near sea due to which sea water evaporation is high during summer which in turn increases the humidity (Amount of water vapour present in air).
Normally human blood temperature is about 35 deg Celsius. If the outside temperature is more than that, then our system tries to automatically cools down by releasing sweat from the body.

The sweat which is released cools the surrounding heat by converting into vapour thereby reducing the body temperature…