View the Exhibit and examine the data in the PROMOTIONS table.
PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr.
You need to produce a report that provides the name, cost, and start date of all promos in the POST
category that were launched before January 1, 2000.
Which SQL statement would you use?
A.
SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
WHERE promo_category = ‘post’ AND promo_begin_date < ’01-01-00′;
B.
SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
WHERE promo_cost LIKE ‘post%’ AND promo_begin_date < ’01-01-2000′;
C.
SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
WHERE promo_category LIKE ‘P%’ AND promo_begin_date < ‘1-JANUARY-00’;
D.
SELECT promo_name, promo_cost, promo_begin_date
FROM promotions
WHERE promo_category LIKE ‘%post%’ AND promo_begin_date < ‘1-JAN-00’;
why is B incorrect? Please help pls.
Because of the format used in promo_begin_date < ’01-01-2000′;.
It should be DD-MON-RR
D
> select to_date(’01-01-2000′, ‘DD-MON-RR’, ‘NLS_DATE_LANGUAGE=ENGLISH’) from dual;
01843. 00000 – “not a valid month”
> select to_date(’01-Jan-2000′, ‘DD-MON-RR’, ‘NLS_DATE_LANGUAGE=ENGLISH’) from dual;
00-01-01
> select to_date(’01-Jan-00′, ‘DD-MON-RR’, ‘NLS_DATE_LANGUAGE=ENGLISH’) from dual;
00-01-01
B is not correct since Month is not correct.
In option D promo_category LIKE ‘%post%’ i think it shud b ‘P%’ as the category POST
For the option B:
promo_cost LIKE ‘post%’ / it is not the promo_cost it is the promo_category 😉
Assuming there no other category with ‘POST’ in its name, D is correct.
My wife and i were so joyful that John could round up his investigation through the precious recommendations he was given from your web pages. It is now and again perplexing to just be giving for free strategies which many people could have been trying to sell. And now we keep in mind we’ve got the website owner to give thanks to because of that. The entire illustrations you’ve made, the simple site navigation, the relationships you can help to engender – it’s got all terrific, and it’s assisting our son in addition to our family consider that the topic is thrilling, and that’s truly mandatory. Many thanks for the whole lot!
http://www.sitiosdecitas.es/meetic
great resources here. Ill be back for the next your posting. keep writing and happy blogging.
http://www.huntingnet.com/forum/members/evelinausb.html
You made some respectable points there. I seemed on the web for the difficulty and located most people will go together with together with your website.
http://www.aeriagames.com/user/myrledanes/
very good post, i definitely enjoy this amazing site, carry on it
http://www.colourlovers.com/lover/bernardinah
I have to get across my appreciation for your kindness giving support to people that actually need help with this concept. Your personal commitment to getting the solution across had become really effective and has continuously made some individuals like me to realize their desired goals. Your own insightful advice denotes this much to me and somewhat more to my office workers. Many thanks; from all of us.
http://gusillham.livejournal.com/
I’ll be back as soon as once more inside the potential to examine out your blogposts down the road.
https://www.plurk.com/JadwigaPencek
Whats up very cool web site!! Man .. Beautiful .. Superb .. I will bookmark your web site and take the feeds additionally…I am happy to find a lot of useful information here in the put up, we want develop extra techniques on this regard, thank you for sharing.
http://www.scoop.it/t/click-link-by-odiliawontorq
Get two plants, and set both of them in two different locations. One plant should be put in a box with a light so it can grow. The other plant should be put in a dark box so it will not grow.
http://forum.kryptronic.com/profile.php?id=115051
I must say, i believed this was a pretty fascinating browse when it involves this subject. Liked the material
https://www.interspire.com/forum/member.php?u=425788
??? ?????? ?? ?? ????? ?? ??? ?? ????? ?? ????? ????? ,????? ??????? ????? ?? ??? ??????? ?????? ??????? ??????? ??????.
http://hedwigabora.beepworld.de/
Thanks for the great post on your blog, it really gives me an insight on this topic.~,*-,
https://app.box.com/s/ccr3o7y4opggbki8oq9mekctq7qva9pr
You made some decent points there. I looked on the net for that problem and discovered most people will go coupled with using your web site.
https://www.evernote.com/shard/s339/sh/43632232-05c8-4e92-9b6f-36667b60cf01/b721201022d84cb1725274a76908c35a
Have you ever thought about creating an e-book or guest authoring on other blogs? I have a blog based upon on the same ideas you discuss and would love to have you share some stories/information. I know my visitors would enjoy your work. If you are even remotely interested, feel free to shoot me an email.
http://www.colourlovers.com/lover/larisarundst
i just didn’t need a kindle at first, but when receiving one for christmas i’m utterly converted. It supply genuine advantages over a book, and makes it such a lot additional convenient. i might undoubtedly advocate this item:
http://articles.org/catrinafarinl/
When you overpay a taxation through yr, you could be allowing government entities a no cost mortgage loan.
http://www.pearltrees.com/larisarundstro#item187280681
What your saying is completely proper. I know that all people must say the incredibly exact same issue, but I just presume that you put it in a way that everyone can totally grasp. I also actually like the photographs you position in the adhering to. They match so nicely with what youre attempting to say. Im guaranteed youll accomplish so quite a couple of men and women with what youve acquired to say.
http://www.pearltrees.com/sinamaustxz#item187216507
Oh my goodness! a fantastic write-up dude. Thank you However My business is experiencing problem with ur rss . Don’t know why Struggling to enroll in it. Possibly there is anybody finding identical rss difficulty? Anyone who knows kindly respond. Thnkx
http://www.aeriagames.com/user/meganlatin/
very nice publish, i certainly love this web site, carry on it
https://justpaste.it/zef2
the Gilmore Girls are really gorgeous, and that is the main reason why i watch that tv show,
http://articles.org/evelinausb/
I ask all my friends to visit this blog…. and I hope they will definitely like..
https://www.diigo.com/user/bernardinaheling
This sort of in search of get the enhancements made on this special lifestyle and diet, begin your L . a . Shifting the pounds diet solution is a huge procedure into accesing which usually hope. weight loss
http://www.colourlovers.com/lover/bernardinah
Thank you for sharing this good write-up. Very inspiring! (as always, btw)
http://articles.org/bridgetnavar/
Document Article. Was’t whatever i ended up specifically hunting for however My husband and i did some searching Aol your posting showed up i really tested versus eachother and additionally wished to no less than thanks a ton.
http://pregame.com/members/karlelvishtsr/userbio/default.aspx
Beyonce, who headlined Glastonbury on Sunday evening, was spoken about on social bookmarking network internet pages far more compared with various other musician at the festival this particular year, according to Brandwatch
http://www.herbaltricks.com/Articles/latest-trend-under-eye-wrinkle-treatment
aluminum curtains rods are much lighter than those steel rods that we previously used;;
https://justpaste.it/zfm2
There are some fascinating time limits here however I don’t know if every one of them center to heart. There exists some validity however I’ll take hold opinion until I look into it further. Good article , thanks and now we want extra! Combined with FeedBurner as properly
http://www.inmethod.com/forum/user/editDone/58939.page
Hey there, You have done a fantastic job. I will definitely digg it and personally suggest to my friends. I’m sure they will be benefited from this web site.
https://www.plurk.com/LarisaRundstro
Can I just say what a aid to seek out someone who actually is aware of what theyre talking about on the internet. You undoubtedly know tips on how to deliver an issue to mild and make it important. Extra people have to read this and understand this facet of the story. I cant imagine youre no more widespread because you definitely have the gift.
https://www.evernote.com/shard/s469/sh/efb02218-17f5-4bbc-b6ca-a3cefa159d30/a2365409d5ea325d45b4083432ff5b3e
Uncertain concerning your own text. It appears to be okay, yet some thing can be missing
http://www.colourlovers.com/lover/karlelvishtsr
Wow! This could be one particular of the most helpful blogs We’ve ever arrive across on this subject. Actually Excellent. I am also an expert in this topic therefore I can understand your effort.
http://www.fontspace.com/profile/sinamau
Good blog! I really love how it is easy on my eyes as well equally the info are well written. I am wondering how I could be notified whenever a young position has been made. I experience subscribed to your rss flow which must do the trick! Experience a nice day!
http://www.aeriagames.com/user/chauschn/
This site is actually a walk-through rather than the knowledge you wanted in regards to this and didn’t know who to ask. Glimpse here, and you’ll absolutely discover it.
http://www.inmethod.com/forum/user/editDone/58935.page
Nice post. I understand some thing more difficult on diverse blogs everyday. It will always be stimulating you just read content from other writers and exercise a specific thing from their site. I’d would rather apply certain with all the content in this little blog no matter whether you don’t mind. Natually I’ll provide you with a link for your web weblog. Thank you for sharing.
http://www.fitday.com/fitness/forums/members/jadwigapenc.html
very nice post, i undoubtedly love this fabulous website, continue it
https://www.plurk.com/LarisaRundstro
That’s a wonderful event. How can one support it financially?
http://www.herbaltricks.com/Articles/15-difficult-things-about-good-skin-care-products
Thanks for this tremendous post, I am glad I discovered this site on yahoo.
http://url.org/bookmarks/bernardinaheling
Also a thing to mention is that an online business administration program is designed for college students to be able to well proceed to bachelor degree education. The Ninety credit college degree meets the lower bachelor education requirements when you earn your own associate of arts in BA online, you’ll have access to up to date technologies with this field. Some reasons why students have to get their associate degree in business is because they may be interested in this area and want to find the general education and learning necessary just before jumping into a bachelor college diploma program. Thanks for the tips you provide inside your blog.
http://url.org/bookmarks/chauschnur
I can see you are an expert at your field! I am launching a website soon, and your details will be really fascinating for me.. Thanks for all your assist and wishing you all of the success.
http://www.kiwibox.com/larisarundst/mypage/
I’d have got to talk with you here. Which is not some thing It’s my job to do! I enjoy reading a post that can get people to believe. Also, thank you for permitting me to comment!
http://www.fitday.com/fitness/forums/members/evelinausb.html
I always visit your blog everyday to read new topics.”`;”;
http://thehot.me/beauty-is-everywhere/
Kudos on your wonderful posting… We certainly liked reading this, you might be a terrific source I will always take a note of ones weblog and definitely will come back down the road I want to motivate yourself to continue this good posts, enjoy your weekend? OMG how about Gaddafi notable news! Thx ! Online Website Builder
http://thehot.me/beauty-is-everywhere/
Universial Studios offers one of the best studio in Hollywood, they also make great films*
http://thehot.me/beauty-is-everywhere/
Hello. i like the way you post on your blog.
http://thehot.me/how-to-be-beautiful/
Well, this Tuesday I read through a couple of your posts and this is probably one of your better ones. Keep it up!
http://thehot.me/transforming-your-skin/
I need yet to really understand together with comprehend that essence in the contents from your article
http://thehot.me/beauty-is-everywhere/
kitchen aids have a variety of different appliances that can help you cook your food easier`
http://thehot.me/how-to-be-beautiful/
It is very rare these days to find sites that provide info someone is looking for. I am glad to see that your website share valued info that can help to many readers. nice one and keep writing!
http://thehot.me/the-hidden-secrets-of-makeup/
“I’m a newbie and your accomplishment is quite a lot an inspiration for me”
http://thehot.me/beauty-is-everywhere/
Enjoyed examining this, very good stuff, thanks .
http://thehot.me/the-hidden-secrets-of-makeup/
I can’t really help but admire your blog, your blog is so adorable and nice ,
http://thehot.me/transforming-your-skin/
What i do not realize is in reality how you’re now not actually much more neatly-favored than you may be right now. You’re very intelligent. You recognize therefore considerably relating to this topic, made me in my view consider it from a lot of varied angles. Its like women and men aren’t involved until it’s one thing to do with Girl gaga! Your own stuffs excellent. Always maintain it up!
http://thehot.me/the-hidden-secrets-of-makeup/
I enjoy reading it. I fundamental to learn more on this subject.. Thanks for the sake theme this marvellous post.. Anyway, I am gonna subscribe to your silage and I wish you post again soon.
http://thehot.me/beauty-is-everywhere/
oh well, i always love the taste of chicken soup and other soups, i am a soup addict you know,,
http://thehot.me/the-hidden-secrets-of-makeup/