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

Comments

Popular this month

Puththu kovilum Putho tilesum, as they are built

Its the grand Aadi season here in Tamil Nadu wherever you go you'd be followed by awful noise from no mercy speakers masqueraded as a devotional song. Yes, this is the first post dedicated to it. Hindu is not a religion but it's idealism, a way to unite people, that's perfectly constructed by assuming separate task to every God, no single God worship. Hindus moved from nature worship to idol worship, but that doesn't mean that we don't have nature worship we have created an idol for them and continued to worship them in a different form. Snake is a beautiful reptile, I have made friend with few too... Our ancestor found the natural law, 'every living creature on earth is important for the ecosystem to be balanced'. Maybe to make sure snakes are not killed fearing their venom they made them as God too! Not just idol snakes, they are worshipped as they are at their conquered (from rats and termite) nest or puthu . Puthu as it used to be in open

Expand post »

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 te

Expand post »

Perfect Farewell 2011 - New Year Welcome Bajan @ HOME FOR CHALLENGED CHILDREN

Every year from the month of November to January it is Ayyappa bajan season in my life. Usually the place where we perform Bajan would be home (residence) at times it would be temple if requested since we are not professionals neither we charge nor encourage it. Unlike ordinary Ayyappa bajan we do Samprathaya Bajan which follows a fixed format which has always received appreciation. A simple call from an acquaintance whom we met 4 years ago in train on pilgrimage to Sabarimala fixed a date for bajan in “HOME for challenged children” in Anna nagar, Chennai. Since I have just joined a job still in training period I was not allowed to take leave unless it is really an emergency. I decided not to go because I was getting tired of working hard, that week was really tough because of storm. After all that rain and storm on Friday my organization declared a holiday for us on 31 st (Saturday) also the last day of 2011. Without any further delay I decided to go there and update the same on

Expand post »

Volatile INDIA no more on Valiant's

Team India “a talented country as it was said” is no more the Ruler of the game called Cricket. India has crossed bars since 1983 but wasn't named as No.1 of the cricket world because the team is much attracted to Emotions, Hierarchy and Injuries than spirit of the game therefore being volatile. The guy from the football town himself got into the team through strong recommendations, but he ruled the world which gained him the nickname DADA. Not all players from that kind of background is able to withstand the pressure, there are many bad example standing tall against weak minor good examples. But after the World Cup’07 the things were changing a lot it is said that hierarchy is removed and also minor tournament will be given more importance to find distinctly talented young players. Now the situation is perplexed because of attraction towards the small tournaments; Reason is that Indians are much interested in seeing the combat between cities and states of their own country. T

Expand post »

Even bull shit can take you to top

Once there was a bird who was so complaining about its illness which is not letting it fly to the lowest branch of tree. The bull which was hearing this smacked some flies on its dick and started "well then have my shit you'd get better". On hearing this the bird sitting on the back of bull got shocked but hesitantly it was ready to give it a try. The day after bird overcame its thoughts and started pecking on the dunk, first day itself bird was able to fly to the lowest branch of tree. Excited the bird took more shit and the following day, its was becoming healthy and fat. Within a week it got so well that with few strokes its able to reach the top of tree. The farmer some feet away spotted the bird, went into home came out with air gun and shoot the bird down. Moral of the story: Even bull shit can take you to top, but it won't help you to stay there This story is pretty old but always good for a smile :) heard it in a 'inner management' video of Sadh

Expand post »

Scribble Shiva

Search This Blog