OraFAQ Forum: SQL & PL/SQL » New message board for Newbies

Home » SQL & PL/SQL » SQL & PL/SQL » New message board for Newbies

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

New message board for Newbies [message #1]

Tue, 01 January 2002 19:27

Frank Naude
Messages: 4581
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

----------------------------------------------------------------------

Report message to a moderator

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

----------------------------------------------------------------------

Report message to a moderator

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.

Report message to a moderator

Re: New message board for Newbies [message #1394 is a reply to message #1]

Thu, 25 April 2002 12:07

pavani
Messages: 32
Registered: April 2002

Member

have u commited after the query if not try and let me know if it worked

Report message to a moderator

Re: New message board for Newbies [message #1396 is a reply to message #1]

Thu, 25 April 2002 12:13

pavani
Messages: 32
Registered: April 2002

Member

have u commited after the query if not try and let me know if it worked

Report message to a moderator

conversion of numbers to text [message #1953 is a reply to message #1]

Wed, 12 June 2002 11:15

mehul
Messages: 4
Registered: January 2002

Junior Member

I want to convert the numbers to text
like
Numbers 12056.00 to
Text like ONE TWO ZERO FIVE SIX DOT ZERO ZERO

Report message to a moderator

Re: New message board for Newbies [message #2496 is a reply to message #1]

Sat, 20 July 2002 00:59

Abul Fazal
Messages: 39
Registered: February 2002

Member

select begin_date
from event_reservations
where begin_date = to_Date('17-APR-03', 'DD-Mon-YY')

Report message to a moderator

Re: conversion of numbers to text [message #2861 is a reply to message #1]

Sat, 17 August 2002 21:52

Abul Fazal
Messages: 39
Registered: February 2002

Member

Do u have Oracle PL/SQL Book by Scott Urman from Oracle PRess. There is a 10-page Procedure that does this.

Best of Luck

Report message to a moderator

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)

Report message to a moderator

Previous Topic:	pipelined functions
Next Topic:	only 3 quarters prior to given date

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 21:32:05 CST 2024