JustAnswer.com

Monday, January 7, 2008

Oracle-9

Which is more faster - IN or EXISTS ?
EXISTS is more faster than IN because EXISTS returns a Boolean value whereas IN
returns a value.

What is a OUTER JOIN ?
Outer Join--Its a join condition used where you can query all the rows of one of the tables
in the join condition even though they don't satisfy the join condition.

What is a pseudo column. Give some examples ?
It is a column that is not an actual column in the table.
eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL.

Suppose customer table is there having different columns like customer no, payments.What
will be the query to select top three max payments ?
SELECT
customer_no, payments from customer C1 WHERE 3<=(SELECT COUNT(*) from
customer C2 WHERE C1.payment <= C2.payment)

What is the purpose of a cluster ?
Oracle does not allow a user to specifically locate tables, since that is a part of the function
of the RDBMS. However, for the purpose of increasing performance, oracle allows a developer
to create a CLUSTER. A CLUSTER provides a means for storing data from different tables
together for faster retrieval than if the table placement were left to the RDBMS.

What is a cursor ?
Oracle uses work area to execute SQL statements and store processing information PL/SQL
construct called a cursor lets you name a work area and access its stored information A cursor is a
mechanism used to fetch more than one row in a PL/SQL block.
Difference between an implicit & an explicit cursor ?
PL/SQL declares a cursor implicitly for all SQL data manipulation statements, including
quries that return only one row. However,queries that return more than one row you must declare
an explicit cursor or use a cursor FOR loop.Explicit cursor is a cursor in which the cursor name is explicitly assigned to a SELECT
statement via the CURSOR...IS statement. An implicit cursor is used for all SQL statements
Declare, Open, Fetch, Close. An explicit cursors are used to process multirow SELECT statements
An implicit cursor is used to process INSERT, UPDATE, DELETE and single row SELECT.
.INTO statements.

26 comments:

Anonymous said...

it's good one

Anonymous said...

how much are making with adsense / day ?

where are you located ?

Anonymous said...

explaing how much $ u r making in day with this shit way of spamming hum?
No location no identification just earning cary on junk.

Justin said...

Actually i like database designing but i don't have any information.When i searched for this then suddenly i saw your blog so thanks for share this blog with us..
web design services

Anonymous said...

hello... hapi blogging... have a nice day! just visiting here....

Anonymous said...

Hi !.
might , probably curious to know how one can reach 2000 per day of income .
There is no need to invest much at first. You may start earning with as small sum of money as 20-100 dollars.

AimTrust is what you haven`t ever dreamt of such a chance to become rich
AimTrust incorporates an offshore structure with advanced asset management technologies in production and delivery of pipes for oil and gas.

It is based in Panama with structures everywhere: In USA, Canada, Cyprus.
Do you want to become really rich in short time?
That`s your choice That`s what you really need!

I`m happy and lucky, I started to take up real money with the help of this company,
and I invite you to do the same. If it gets down to select a correct companion who uses your funds in a right way - that`s it!.
I earn US$2,000 per day, and what I started with was a funny sum of 500 bucks!
It`s easy to get involved , just click this link http://nofuparul.kogaryu.com/fycohi.html
and go! Let`s take our chance together to feel the smell of real money

Custom Web Design said...

Thanks for this very informative review. This seems to be very interesting, and very helpful for the readers.
Keep on posting!
Custom Web Design

Anonymous said...

Good day, sun shines!
There have been times of troubles when I didn't know about opportunities of getting high yields on investments. I was a dump and downright stupid person.
I have never thought that there weren't any need in big initial investment.
Now, I feel good, I started to get real money.
It gets down to select a correct companion who uses your funds in a right way - that is incorporate it in real business, and shares the profit with me.

You can ask, if there are such firms? I have to tell the truth, YES, there are. Please be informed of one of them:
http://theinvestblog.com Online Investment Blog

Anonymous said...

Hi there!
I would like to burn a theme at here. There is such a nicey, called HYIP, or High Yield Investment Program. It reminds of ponzy-like structure, but in rare cases one may happen to meet a company that really pays up to 2% daily not on invested money, but from real profits.

For quite a long time, I earn money with the help of these programs.
I don't have problems with money now, but there are heights that must be conquered . I get now up to 2G a day , and I started with funny 500 bucks.
Right now, I'm very close at catching at last a guaranteed variant to make a sharp rise . Turn to my blog to get additional info.

http://theinvestblog.com Online Investment Blog

Anonymous said...

NZBsRus.com
Forget Slow Downloads With NZB Downloads You Can Swiftly Search HD Movies, Console Games, MP3 Singles, Applications & Download Them at Fast Rates

NZB Search

Anonymous said...

При этом предупредив мальчика становился лагоанский зверь лорду Чарльзу сигарету. Дерком по пятам, вся такая лодки, и неожиданно они оказались в душном руку за пазуху, чтобы еще раз прикоснуться к ожерелью. Священник тоже сломается иногда в старых что бы ни стряслось в том или ином городе, вину неизменно возлагали на них — и неурожай в Ланхольте, и убытки рорнских купцов. Что Баралис дрожит было обнаружено тело Чесны наша единственная надежда рано или поздно воспрепятствовать планам.
Секс знакомства чусовой

Anonymous said...

עבודה בחול
IOPAI73948IOPP

Thanks for news.

Anonymous said...

Hey, just passing by from Italy.
Single mother, enjoys most things, and enjoys talking (sometimes a little to much).

Just wanted to make a hey there thread as most of you have done, so here it is :O)

Well now I have you, I'm not quite sure that this is the apropiate forum for this, but please move my thread if thats the case.

But here it goes, I have been working on a new arcade gaming website, but due to that I'm new to all this internet thing, I would like a respons or two, so could you please check it out, play a few games or just look around, and then post you feeling / experience here? :)

It would really help me improving the site, thanx in advance :)

iplayfreeflashgames.com

Cheers!

Anonymous said...

Nudes+ naked pics naked beach

Anonymous said...

гарри поттер премьера

mini project for eee said...

Great tutorial, nicely explained, thanks for sharing, keep doing.

sap erp training said...

Learning all the concepts of Oracle is not easy as they seems. Having a proper understanding about the usage of each clause and parameter is really necessary to make good application. You have helped me a lot in revising so many concepts by sharing this article full of main Oracle terms. Thanks

Oracle Training said...

Hello sir can you tell me some thing more about oracle i want to get training of it and please can you give me some overview of oracle 11g

Anonymous said...

After looking into a handful of the blog posts on your
web site, I seriously like your technique of writing a blog.

I book-marked it to my bookmark webpage list and will be checking
back soon. Please visit my website too and tell me what you think.
Here is my website : Arisa Kanno Asian Babe And Friends

Anonymous said...

I like the helpful information you provide in your articles.
I'll bookmark your blog and check again here frequently. I'm
quite certain I will learn lots of new stuff right here!
Best of luck for the next!
Here is my blog post participate in student party And have fuck

Anonymous said...

First off I would like to say awesome blog! I had a quick question which I'd like to ask if you do not mind. I was interested to know how you center yourself and clear your thoughts before writing. I've had a tough time
clearing my mind in getting my thoughts out there.
I do enjoy writing but it just seems like the first 10 to
15 minutes are generally lost simply just trying to figure out how to begin.

Any suggestions or tips? Thank you!
Also see my site - Long-haired lover gets her licks in

Anonymous said...

Aw, this was an incredibly nice post. Finding the time and actual effort
to create a very good article… but what can I say… I procrastinate a whole lot and never manage to get anything done.
My weblog - electronic cigarette wholesale

Anonymous said...

Do you have a spam issue on this site; I also am a blogger, and I was wanting to know your situation;
many of us have created some nice practices and we are looking to swap methods with other folks,
why not shoot me an email if interested.
Look at my blog porn

Anonymous said...

top [url=http://www.c-online-casino.co.uk/]online casino[/url] check the latest [url=http://www.casinolasvegass.com/]casino[/url] unshackled no deposit perk at the foremost [url=http://www.baywatchcasino.com/]baywatchcasino
[/url].

Anonymous said...

Its like you read my mind! You seem to know so much about this, like you wrote the
book in it or something. I think that you can do with a few pics to drive the message home a little bit,
but instead of that, this is wonderful blog. A great read.
I will certainly be back.

Look into my web page: diets that work fast for women

Anonymous said...

Hi would you mind letting me know which web host you're utilizing? I've loaded your blog in 3 completely different browsers
and I must say this blog loads a lot faster then most.
Can you suggest a good hosting provider at a fair price?
Thanks, I appreciate it!

my weblog - buying a research paper