What is schema?
Answer Posted / sam
Schema is a collection of user defined objects such as
(table,view,procedure,etc..)in oracle and Active Dir.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How to start your 10g xe server from command line?
How view is different from a table?
What is columnar storage what is the advantage?
What is memory advisor in Oracle?
What is recovery manager(rman) backup in Oracle?
What are the uses of linked server and explain it in detail?
When system tablespace is created?
How to define a data field as not null?
Does facebook use oracle?
How will you write a query to get a 5th rank student from a table student_report?
Give syntax for SQL and ORACLE joins.
What is an oracle tablespace?
What is a cursor in oracle?
> 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?
How to get last row id?