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

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 »

Setting up LAN with BSNL router AN 1020-21

An abstract overview for building a LAN is presented here, you can use the essence of article to build LAN with any other router you can lay your hands on. That said don't confuse modem with router, most routers are modem but a modem simply can't be router* Post is written in the hope that reader is equipped with basic knowledge about connecting line to splitter to router to device you want to use. It is assumed the your modem is configured for both wireless and ethernet access. My work requires that I interact daily with servers using putty or such terminal emulator, gradually I loved doing work the *nix way. This made me install Cygwin in almost every machine I use, thanks to MobaXTerm I need not do that anymore :) Off story on to TODO. 1. Connect the machines you want to use to Router That's all! Your router takes care of establishing (W)LAN Surprisingly simple to establish LAN, but the hard part is knowing how to use the systems connected in the network. Here...
Post a Comment
Expand post »

Wings of Fire

Though tagged under review I’m going to try and bring the essence of the book, in no means I have the guts to write a review on a book that’s written on/by Dr APJ Adbul Kalam. Unlike regular biographies the book is filled with information and facts on Indian Space research straight from Dr Kalam’s diary, has very limited information on his personal life. From Preface of the book, we can understand Mr Arun Tiwari co-author of this book had brought up this idea to write a book and put it work. The book is organized in seven sections but the core content is put inside 4 sections – Orientation, Creation, Propitiation, and Contemplation. While the rest cover how and why this book formed and what it intends to convey. Dr Kalam being a spiritual person has quoted poems and lines from the Quran throughout the book. Orientation starts with the birth of the legend Avul Pakir Jainulabdeen Abdul Kalam in Rameswaram to Ashiaamma and Jainulabdeen, Dr.Kalam’s father is a humble boat owner a...
Post a Comment
Expand post »

ENGEYUM KAADHAL - MOVIE REVIEW

With Engeyum Kaadhal, Prabhu Deva has tried to narrate yet another story using the most common and ubiquitous phenomenon in the world, Love. The opening titles with backdrop paintings followed by Prabhu Deva’s cameo for ‘Engeyum Kaadhal’ song are pleasant but from then on the movie couldn’t live up to its hype. Jayam Ravi as a young businessman fits perfectly in his tailor made role. He even impresses with his dazzling dance moves. Hansika Motwani looks refreshing in her vivid outfits but fails to impress in the acting department. Her dubbing is imbecile and out of sync at many places. Rajusundaram annoys you often under the pretext of making fun. Neither Suman nor Prakashraj have much to play. The only outstanding features of the movie are Nirav Shah’s brilliant cinematography which captures the exquisite and serene beauty of Paris with ease and Harris Jayaraj’s poignant music as almost all songs are pleasant to hear . 
Post a Comment
Expand post »