Interested to Buy Any Domain ? << Click Here >> for more details...
can we insert any row to dual table if i got the permission
from DBA
- 5 Answers
- 17277 Views
- HCL, Tesco, I also Faced
- E-Mail Answers
Answer Posted / chandana
Dual is a pseudotable with one column varchar and length=1.
Yes, we can insert values into Dual table provided the
inserted value is of type varchar and length =1.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
When do we use group by clause in a sql query?
What are joins, explain all types of joins?
> 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 difference between sid and service name in oracle?
What is a nested table and how is it different from a normal table?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is the maximum number of triggers that can be applied to a single table?
Explain what are the characteristics of data files?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Explain the difference between sql and oracle?
What happens if variable names collide with table/column names?
How to convert numbers to characters in oracle?
Is it possible to split the print reviewer into more than one region ?
What is MTTR advisor in Oracle?
How to write date and time literals in oracle?
