What is schema?
- 41 Answers
- 53021 Views
- Bodhi Global Services, Cognizant, HCL, I also Faced
- E-Mail Answers
Answer Posted / premsagar
Schema is the over all design of the database
| Is This Answer Correct ? | 71 Yes | 20 No |
Post New Answer View All Answers
What is the difference between hot backup and cold backup in oracle?
what is the difference between substr and instr function in oracle?
What are the different types of failures that occur in Oracle database?
Differentiate between pre-select and pre-query?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is oracle server autotrace in oracle?
master table and child table performances and comparisons in Oracle ?
How to define a data source name (dsn) in odbc manager?
How to define a data field as not null?
What are the different types of synonyms?
What is a subquery?
What is the parameter mode that can be passed to a procedure?
How to count groups returned with the group by clause in oracle?
How to save query output to a local file?
> 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?
