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

Labels

Labels:

Comments

Post a Comment

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...
Post a Comment
Expand post »

Up and Close with Sudalai Madan: The Encounter

Night of 13th April all the preparations for the rituals were done in the temple, Sudalaimadan swamy was decorated with flowers, fruits and coconuts; the dedications 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 also previous head priest and blessed the family members in room dedicated for God, then started towards the temple. People have already gathered in huge numbers and were waiting for the Sudalaimada Swamy's arrival at Temple. Different rituals were offered by people to the Lord in order to get the blessings. As it is believed Sudaimada Swamy, the son of Lord Siva used to consume meat in Kailash for this reason he is sent to earth, where he can satisfy his earthy hunger thereby not polluting Kailash. Sree Aaladi Padmanabha Sudalaimada Swamy Temple, Kumarapuram Offering meat to Sudalaimadan is the most important and watchful event of the festival. Many devotees off...
Post a Comment
Expand post »

Acid rain in Chennai

Don't panic it is not literal acid but a metaphorical one. Probably Poes Garden, maybe Gopalapuram I can't imagine any other area in Chennai to be drained. So why is this? every time? we pray for rain and when it comes we are always unprepared, even for moderate showers our roads are flooded. Is it because Chennai is an old city and its infrastructure not enough for information age or is that because of the vote bank politics? By now you'd have guessed what I quoted as 'Acid rain', it is that one created by the broadcasting network. Nowadays every political party is having its own network, you do the math and imagine the amount of 'Angel and Demon' perspective we are exposed to. From every network that is with the ruling party, we are shown the 'Angel face' emergency number, disaster recovery team, ambulance gushing thru flood, evacuation and so on. Other side which clearly outnumbers the ruling party in 4:1 ratio shows us flood, death, dengue, sew...
Post a Comment
Expand post »

RJ Balaji in as Vadacurry

Vadacurry is a perfect entertainment package – comedy, a romantic song, an item number, punch, villian, hero, noble cause – as we know, it is a masala movie. Movie revolves around lead male played by Jai and his immediate needs – getting Smart phone, the way he chooses to fullfill his need brings the neccesarily components to push the movie into vibration mode Director Saravana Rajan’s made the movie lighter enough to remove any sort of thrill from the movie, a team which has wide range of experience in providing laughter made this comedy-thriller into comdey-drama. The movie starts with RJ Balaji saying “my name is vadacurry, but I don’t have much to do here (ref. movie is titled as Vadacurry)”. Director gives Jai enough importance that almost any other character in the movie has little role to play, but when you leave the theater you know why its Vadacurry, without RJ Balaji movie might be rusty. Not a star cast unless you are going to consider Jei and Swathi as stars, whom I...
Post a Comment
Expand post »

Up and Close with Sudalai Madan: Warm up

Hollywood is just a movie industry for most people, but for some like me, it is the inspiration and life guide. I have watched many movies from all genres - action, thriller, comedy, drama, romance, but what I loved is a controversial subjects.  Mikael Håfström's 1408 was in my mind, when I travelled down south to my native for the holy annual festival, 'Sudalaimada Swamy Kodai'. I always keep track of what I do at what time when I'm away from home in my diary. I caught this habit after maintaining the track diary when we make the pilgrimage to Sabarimala every year. Back view of our Sudalaimada Swamy temple I travelled with Athai and Chitapa to Thirunelveli by train; festival takes place at summer, to keep his elder sister comfortable my uncle booked an AC room near Nellai railway junction we stopped by dropped luggage and refreshed. I was happy he was there, someone who can guess what will be running in my mind. We reached Kumarapuram after going to Udhayathur so...
Post a Comment
Expand post »