Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.
13 219761) Difference between "Delete" and "Concatenate" with reference to databases? 2) Difference between SDLC and STLC. 3) Latest versions of the browsers used. 4) What is URL Tampering? 5) Full form of URL. I don't need the answers. These are just for reference.
2400can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )
1 4502ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_ACTIVE_3970712838_6793 by 128 in tablespace SYSAUX? What is the solution for this issue?
2 19494Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?
2 4905Post New Oracle Interview Questions
On the off chance that there is a quick need for answers to business questions, which device you would run with? : sap bobi
which is the simplest file structure? (Sequential, indexed, random)
purpose of assigning Field Status Variant to Company code??
Can you edit data in repeater control? How?
What are the fetching strategies supported by hibernate?
what is the use of psapundo tablespace? what is the error ora -01555 represents.how can u prevent this error?
If you see statistics that deal with "undo" what are they really talking about?
What is a list c++?
How to remove values to a python array?
How to create an input box?
What Contains in Business Design Document?
What is solver used for in excel?
How can I load data from a text file into a table?
What are the unary operations in Relational Algebra?
You want to find out which users have an access to a particulat transaction. How would you do that?