| Rush |
Posted: Feb 22, 2007 02:16:33 AM |
Total Post: 127
Joined: Jan, 2007
|
Hello this is Rupesh and i want to take your help in a question asked to me in an interview:
Q:what is the best utilization of null value in oracle?
since this q was not very clear to me so i said sorry.can any one of you will help me plz.....
Thanks. |
|
|
 suzee |
| Posted: Feb 22, 2007 04:54:54 AM |  |
|
Total Post: 21
Joined: Feb, 2007
|
i think it should be
while using group functions null values will not be considered.
|
|
|
|
|
| suzee |
| Posted: Feb 22, 2007 04:58:15 AM | |
|
Total Post: 21
Joined: Feb, 2007
|
null when combined with any other values will return a null value
|
|
|
|
|
| Rush |
| Posted: Feb 22, 2007 05:43:55 AM | |
|
Total Post: 127
Joined: Jan, 2007
|
Thank suzee!!!:-)actually i knew these things but coudn't understand question when asked like...'what is the best utilization of null value';
one more thing i want to ask that what is the way to insert values in a table through pl/sql;
i am writing like this but it is not working.......
begin
execute immediate 'create table x(id number)';
abc:=insert into x values(:1);
execute immediate abc usind id;
end;
/
RUPESH
|
|
|
|
|
| parth |
| Posted: Mar 07, 2007 05:49:14 AM | |
|
Total Post: 4
Joined: Mar, 2007
|
yes,it matters when 1 million you have to take the record, so try to use select statement where u can use NULL value....and that is fast
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
