some Questions to ponder....

hi all,
do help me out with these doubts.

1) create table emp as select * from emp2 where 10=11;
what will be the contents of emp?..
2)
is it possible to create a duplicate table using a DML statement?..

thanks in adv,
love
ram


Comments

  • : hi all,
    : do help me out with these doubts.
    :
    : 1) create table emp as select * from emp2 where 10=11;
    : what will be the contents of emp?..
    : 2)
    : is it possible to create a duplicate table using a DML statement?..
    :
    : thanks in adv,
    : love
    : ram
    :
    :
    !1) The results should be wrong coz create table using select statement is creating a table with the same structure of emp2 but where statement is not the structure but the data.
    2) No, by default you cannot have 2 tables which have same names.
    Neo Gigs
    http://communities.msn.com.my/VisualBasicwithNeo


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion