How do you add a data file to a tablespace?
Answer / shams tabrez
alter tablesapce <tablespace_name> add
datafile '/data/file/lcoation_01.dbf' size 10m autoextend
on;
Is This Answer Correct ? | 3 Yes | 0 No |
i have marks in table,how to find total?
Whats the purpose of using Nextval while creating the sequence.
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
Explain the use of table functions.
Difference between negative and positive adjustments : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
A scenario for amount correction & how to use amount correction functionality in AP invoices
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
write a query to find the third maximum salary of a employee.(table:employ col name:salary)
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
Explain the use of setting GLOBAL_NAMES equal to TRUE.