Topic: SQL*Plus and PL/SQL >> What is Decode
|
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.
|
|
|
|
| sm_ahmeds |
Posted: May 24, 2007 11:40:52 AM |
Total Post: 53
Joined: Apr, 2007
|
Hi,
I have been asked in an interview....what is the use of 'decode' in sql statement and also how many max no. of columns can be there in a table.
Please Help
Thanks. |
|
|
 Prakash |
| Posted: May 25, 2007 03:09:20 AM |  |
|
Total Post: 112
Joined: Aug, 2006
|
Hi,
Decode is a 'if..then.. else' type function used in SQL.
No max limit for no. of columns in a oracle table.
|
|
|
|
|
| sangeeta |
| Posted: May 27, 2007 05:58:24 AM | |
|
Total Post: 4
Joined: May, 2007
|
hi,
well the maximum no. of columns a table can have is 1000...look at the following..
ORA-01792 maximum number of columns in a table or view is 1000
Cause: An attempt was made to create a table or view with more than 1000 columns, or to add more columns to a table or view which pushes it over the maximum allowable limit of 1000. Note that unused columns in the table are counted toward the 1000 column limit.
Action: If the error is a result of a CREATE command, then reduce the number of columns in the command and resubmit. If the error is a result of an ALTER TABLE command, then there are two options:
If the table contained unused columns, remove them by executing ALTER TABLE DROP UNUSED COLUMNS before adding new columns.
Reduce the number of columns in the command and resubmit.
|
|
|
|
|
| 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 | 335 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
