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:

Comments

Post a Comment

Popular this month

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 »

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 »

Love is an overrated emotion

Nothing here is a fact, this is only opinion, no just rant of a young adult idiot. Turn around now, if you don't like rant or profanity or profanity-laced rant. When I say love, I strictly mean the romantic form of it; and I hate that I even have to say that, why do people have to add love to everything? parental love, baby love, candy love and so on... that's just plain stupid. Love is problematic not just because some people use it to manipulate others, but because it is a powerful emotion. So how it is problematic for everyone if only some use it to manipulate, the rest plain minded people will be bound by a strong feeling for each other, isn't it good? No, because even though love is strong emotion it starts to wear down after the purpose is fullfiled, and that brings me to the purpose of love. Purpose of love is to pro-create, you can decorate it, put a shiny gown, powder it with glitters, but the truth remains the same, love exists so that we don't become extinct....
Post a Comment
Expand post »

The Oath of the Vayuputras – Debacles

Shiva Trilogy – Tells all the mythologies we already know and poorly explains way that all are humans – what else can you expect from an atheist. Yes Amish Tripathi as we know is not a spiritual guy, he was an atheist but grew faith as he wrote book – an absolute marketing stunt. Thus Lord Shiva smokes marijuana/chillum/meth/ganja or in whichever term you want to identify tobacco. Poor Millennial crowd caught the least message drew tattoo and smoked marijuana. Coming to this book by reading the title I was sure that Vayuputras will have a great role to play in this last book but just one man from their tribe did and we know him by the name Shiva all along. Starting the review with so much negativity gives away all the content that will follow so let’s not do that. Oath of Vayuputras - this time arrow was of use Zipped Plot: Nagas guides Shiva to Vasudevs place, they all join together. Branga, Kashi also forms alliance with Shiva. Shiva sends his sons to conquer Ayodhya; the...
Post a Comment
Expand post »

Shame of Sabarimala : Annadhanam under TDB

Annadhana Prabhuve, Saranam Ayyappa It means "The noble who donates food, Ayyappa save us". The legend is not clear about how or why Lord Ayyappa is called so, coincidentally the third step of the Pathinetu padi stands for Annapoorna (the God of food) by crossing this step Ayyappamar assure that they have followed Ayyappa by donating food to peers and made sure any Ayyappamar coming to Sabarimala for Punya Dharishanam is not hungry. I'm sure this year many Ayyappamar did not fullfil this deed to proudly step on it, they neither received nor gave; they were curbed. Though it was ABASS*   who started it all many sangam took up the responsibility to feed the hungry Ayyappamar, people have crossed the toughest times by taking supplies to impossible mountain peak like Karimala, Azhutha; now with roads easing pain kerela government and travancore devaswom board(tdb) is pulling the rug on Seva Sangams. Image edited from The Hindu Double standard of kl govt and tbd ...
Post a Comment
Expand post »