Interested to Buy Any Domain ? << Click Here >> for more details...
can a table has a column that has only view data and in
other columns we can change data?
- 2 Answers
- 5096 Views
- Secon, I also Faced
- E-Mail Answers
Answer Posted / thiru
Yes. We can build a sequence generator value to a column in
a table then next columns can be handled with SQL queries.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How does Oracle guarantee data integrity of data changes?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
> 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 are the numeric comparison operations?
What is Java Pool in Oracle?
What is the difference between PFILE and SPFILE in Oracle?
How to list all user accounts in oracle?
WHAT IS ecc 6.0
What are the different types of partitions in oracle?
Explain the use of inctype option in exp command.
if you ctreate table identity
What is redo log?
What is the quickest way to export a table to a flat file?
How to write date and time literals in oracle?
