| New message board for Newbies [message #1] |
Tue, 01 January 2002 19:27  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
This message board is intended for new Oracle users (newbies). Please use it to post beginner Oracle SQL & PL/SQL questions on.
Enjoy.
Frank naude
----------------------------------------------------------------------
|
|
|
|
| Re: New message board for Newbies [message #11 is a reply to message #1] |
Thu, 03 January 2002 08:44  |
Micky
Messages: 18
Registered: January 2002
|
Junior Member |
|
|
Great.
Thanks for the support!
I'm just about to start courses
Intro to oracle sql & pl/Sql
AND pl/sql program units
with the intention of following the developers track.
I'm using Sams and have ordered Sybex Certification Guide.
Any other suggestions.
Again thanks and give me a few months and I hope to be able to help others!
Take care
Micky
----------------------------------------------------------------------
|
|
|
|
| Re: New message board for Newbies [message #598 is a reply to message #1] |
Sun, 24 February 2002 08:58 |
Breaux
Messages: 1
Registered: February 2002
|
Junior Member |
|
|
I am trying to select a date from the database
but no row is returned.
>select begin_date
>from event_reservations
>where begin_date = '17-APR-03';
No row returned
But row exists in Database.
What is wrong with is statement.
Please help.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| help me with my 2 assigment problem please [message #14671 is a reply to message #1] |
Fri, 03 September 2004 05:20 |
Adumb_student
Messages: 1
Registered: September 2004
|
Junior Member |
|
|
i'm a super beginner in PL/SQL and i need the codes with comments so i can understand it. i searched the forum, and tried dense rank in number 1 but it it is not working. i'm using oracle8.05 for windows NT
1.using emp table. Create a PL/SQL program.
Sample Output:
Enter number: 3
NAME SALARY
FLOYD 6000 --(1st)
JOHN 4000 --(tie for 2nd)
ALI 4000 --(tie for 2nd)
SMITH 2000 --(3rd)
2.
ask for a user input, must accept character,number, or combination
sample input:
input: aBC25sa9a5
output:
char: aBcSaA --(alternate lower-upper)
num: 25+9+5=39
input: abcde
output:
char: AbcdE --(1st and last upper)
num: no_number_found
input: 12345
output:
char: no_char_found
number: 61725 --( times 5 if pure numbers)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
