Topic: SQL*Plus and PL/SQL >> Code Question
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Scan |
Posted: Apr 24, 2005 09:17:59 AM |
Total Post: 2
Joined: Apr, 2005
|
Hiya, I was browsing some SQL/oracle code earler this evening and there are couple things that catch my eyes, what are these codes mean ?
- PROJCODE VARCHAR2(20 BYTE) NOT NULL REFERENCES PROJECT (PROJCODE) why did he/she add byte not just like (20)?
- COMMIT; ?what is Commit ?
- CSKILSS CLOB, , What is Clob means ? What does it do ?
- PROJBUDGET FLOAT(126) NOT NULL, - What is Float
- WHERE CONSULTANT.CNO (+)= PROJECTCONSULTANT.CNO
AND PROJECTCONSULTANT.PCNO (+) = TIMESHEET.PCNO -- Lastly what is (+)= means ? is it the same as "Not Equal" ?
I know those question might seems Noobish question, but that what i am right now, So I need to know ..
Thanks a lot
|
|
|
 Vigyan |
| Posted: Apr 26, 2005 11:57:19 AM |  |
|
Total Post: 386
Joined: May, 2001
|
See my comments below.
- PROJCODE VARCHAR2(20 BYTE) NOT NULL REFERENCES PROJECT (PROJCODE) why did he/she add byte not just like (20)?
--- It is same thing as 20.
- COMMIT; ?what is Commit ?
--- Commit is like “SAVE” in oracle. By committing data you make sure your changes are saved in the database.
- CSKILSS CLOB, , What is Clob means ? What does it do ?
--- This is the data type to store characters. VARCHAR2 can store upto 4000 bytes only. If you need to store more than that then you can use this data type.
- PROJBUDGET FLOAT(126) NOT NULL, - What is Float
--- It is a numeric data type.
- WHERE CONSULTANT.CNO (+)= PROJECTCONSULTANT.CNO
AND PROJECTCONSULTANT.PCNO (+) = TIMESHEET.PCNO -- Lastly what is (+)= means ? is it the same as "Not Equal" ?
--- It is outer join.
Hope it helps.
Vigyan
|
|
|
|
|
| Scan |
| Posted: May 14, 2005 02:34:36 AM | |
|
Total Post: 2
Joined: Apr, 2005
|
Thanks a lot VIgyan, I however has another question. I have an assignment in which we need to make an ERD's, SQL Codes and everything, from a plain company story. Now, I'm stuck in the ERD's making things, I do the orther ERD's but not this one.
it says :
"No two events for the same adventure code ever commence on the same date."
I mean i can logically think about it and it is possible to do it on real-life. but i dont know what should i do to make this ERDs I mean, where i suppose to start ? what does it means ?
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 334 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
