Interested to Buy Any Domain ? << Click Here >> for more details...
What is schema?
- 41 Answers
- 61605 Views
- Bodhi Global Services, Cognizant, HCL, I also Faced
- E-Mail Answers
Answer Posted / k
Schema is simply an user to the database wherein the user
can create its own objects in the database.
| Is This Answer Correct ? | 39 Yes | 22 No |
Post New Answer View All Answers
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
> 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 key preserved table?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to end the current transaction in oracle?
What are the roles of dba?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How do I uninstall oracle 11g?
what are the advantages of running a database in archive log mode?
Is there an oracle sql query that aggregates multiple rows into one row?
How to invoke the data pump import utility?
What is raw datatype?
What happens if the update subquery returns multiple rows?
What is the parameter mode that can be passed to a procedure?
What is a directory object?
