Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sridevi
alter table <tablename> add column(col.name(size))
| Is This Answer Correct ? | 17 Yes | 8 No |
Post New Answer View All Answers
How to convert times to characters in oracle?
How to use subqueries with the in operator using oracle?
what happened to the global index when I truncate the data in one of the partition?
Where is the export dump file located?
What is the max number of columns in an oracle table?
Is the After report trigger fired if the report execution fails ?
What are the system predefined user roles?
What is meant by an index?
How to view the tablespaces in the current database?
When do I need to use a semicolon vs a slash in oracle sql?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What is merge statement used for?
Explain integrity constraints?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Difference between hot backup vs. Cold backup?
