What is schema?
Answer Posted / satyabrata
Schema is Collecton of data object including logical
structures such as tables, views, sequences, stored
procedures, synonyms indexes, clusters and database links
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is ordinary table in oracle?
What is the difference between a primary key & a unique key?
How are extents allocated to a segment?
How do we display rows from the table without duplicates?
Explain coalesce function?
Explain what are the type of synonyms?
How do I limit the number of rows returned by an oracle query after ordering?
Why use resource manager in Oracle?
How to assign data of the deleted row to variables?
How would you change old and new values in an insert, delete and update triggers?
What is oracle thin client?
> 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 an oracle recycle bin?
Explain the use of record length option in exp command.
How to convert numbers to characters in oracle?