Board index › Topical Discussion › Computers, Math, Science, and Technology

Oracle SQL language help

Page 1 of 1 [ 5 posts ] 

Previous topic | Next topic

GamerNerd07901
Snowy Owl
Snowy Owl

User avatar

Joined: 5 Jun 2011
Age: 30
Gender: Male
Posts: 130
Location: Summit, New Jersey

02 Jan 2012, 11:20 am

Hello all,

I'm currently taking a class on Oracle database mangement & design. Theres only one problem.
My instructor (while I have no doubt she knows the matirial) is an AWFUL teacher, and I have alot of trouble making sense of what she is saying about the SQL programming language half the time.

Anyone here good with Oracle?

Start off Question:

I don't quite understand the LPAD/RPAD commands.

(select) LPAD(24000,10'*')
from dual

I know their supposed to left/right justify values, but why do I need to pad the value using an astrick of other symbol?

P.S. I'm new here, so just to be certain, I am allowed to do this right? (Make a threadasking for help with a class?)


_________________
What is learning? Its paying attention. its opening yourself up to this great big ball of****that we call life! And whats the worst that could happen? You get bit in the ass! Well let me tell you, My ass looks like hamburger meat,But I can still sit down!


Cornflake
Administrator
Administrator

User avatar

Joined: 30 Oct 2010
Gender: Male
Posts: 69,250
Location: Over there

02 Jan 2012, 12:46 pm

GamerNerd07901 wrote:
P.S. I'm new here, so just to be certain, I am allowed to do this right? (Make a threadasking for help with a class?)
You're doing Ok - but don't ask about any homework questions, Ok? :wink:


_________________
Giraffe: a ruminant with a view.


AngelKnight
Veteran
Veteran

User avatar

Joined: 3 May 2011
Age: 48
Gender: Male
Posts: 749
Location: This is not my home; I'm just passing through

02 Jan 2012, 1:35 pm

Look up the difference between CHAR() and VARCHAR()



GamerNerd07901
Snowy Owl
Snowy Owl

User avatar

Joined: 5 Jun 2011
Age: 30
Gender: Male
Posts: 130
Location: Summit, New Jersey

02 Jan 2012, 1:40 pm

ook....

this (subsitution variables) is going to be on a test, when I looked it up in the textbook I didn't really get the explanation.

I get how a substituion variable works, but how am I supposed to use a subsitution variable to inject the abbreviated month (MAR,JAN,DEC, etc) and only the month, into a data field formatted in standard DD-MM-YYYY/RRRR format?


_________________
What is learning? Its paying attention. its opening yourself up to this great big ball of****that we call life! And whats the worst that could happen? You get bit in the ass! Well let me tell you, My ass looks like hamburger meat,But I can still sit down!


GamerNerd07901
Snowy Owl
Snowy Owl

User avatar

Joined: 5 Jun 2011
Age: 30
Gender: Male
Posts: 130
Location: Summit, New Jersey

02 Jan 2012, 1:57 pm

oh never mind I'll figuire it out