Home » Other » Training & Certification » simple pl/sql questions ,
simple pl/sql questions , [message #356830] Sun, 02 November 2008 13:44 Go to next message
xost
Messages: 9
Registered: February 2008
Junior Member
hi people, i have exam in Oracle after few days ,
i need the solution for the following questions .

Q1) write pl sql block to accept 10 number in a loop and print sum of accepted odd numbers and even number seqarately.

Q2) write pl/sql to accept number and print following (e.g if inputtted number is 4 )
4321
432
43
4


Q3) write pl/sql to accept number and print whether it is even or odd



q4) weite a pl/sql block for following pattern
123
12
1



q5) write a pl/sql block which will print first five highes enames from emp table. (use cursor)

for who would help me , thanks in advance ,

[Updated on: Sun, 02 November 2008 13:45]

Report message to a moderator

Re: simple pl/sql questions , [message #356831 is a reply to message #356830] Sun, 02 November 2008 13:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68634
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Posr what you already tried.

Before please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter).
Use the "Preview Message" button to verify.

Regards
Michel
Re: simple pl/sql questions , [message #356833 is a reply to message #356830] Sun, 02 November 2008 14:07 Go to previous messageGo to next message
xost
Messages: 9
Registered: February 2008
Junior Member
i am sorry for formatting ,
i actually i tried nothing , because i know nothing about pl/sql programming and i can't start learning pl/sql in one day .

we have only theory parts about pl/sql , but i surprised with the previous question paper, they ask for programming.

[Updated on: Sun, 02 November 2008 14:09]

Report message to a moderator

Re: simple pl/sql questions , [message #356836 is a reply to message #356833] Sun, 02 November 2008 14:42 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What a shame, they don't play a fair game!

Who are you trying to fool, anyway?
Re: simple pl/sql questions , [message #356839 is a reply to message #356830] Sun, 02 November 2008 14:53 Go to previous messageGo to next message
xost
Messages: 9
Registered: February 2008
Junior Member
i'm notrying to fool anyone ,
if you want i will scan the syllabus and the question paper and also the exam time table for you .

thanks anyway ,

if i have time i will not ask you for your help , i don't need help of anybody , i will do it myself ..
Re: simple pl/sql questions , [message #356841 is a reply to message #356830] Sun, 02 November 2008 14:57 Go to previous messageGo to next message
xost
Messages: 9
Registered: February 2008
Junior Member
Suspend my account also.

goodbye

[Censored by moderator]
Re: simple pl/sql questions , [message #356842 is a reply to message #356839] Sun, 02 November 2008 15:06 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
i don't need help of anybody , i will do it myself

Well, that's probably the best option and will certainly mean a lot in the future. In a long term, you certainly can't win by cheating.

After all,
Quote:
i don't need help of anybody
isn't probably entirely true; most people here will be more than glad to help, but only if it is worth while. Providing several lines of code wouldn't help at all. Not today.
Re: simple pl/sql questions , [message #356979 is a reply to message #356842] Mon, 03 November 2008 07:03 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
User xost's account was banned.
Previous Topic: how to free download oracle clinical software?
Next Topic: oracle clinical application (merged)
Goto Forum:
  


Current Time: Tue Apr 16 04:32:16 CDT 2024