What privilege is needed for a user to query tables in another schema?
No Answer is Posted For this Question
Be the First to Post Answer
How to assign a tablespace to a users in oracle?
What is oracle server autotrace in oracle?
What are different Oracle database objects?
Youre getting high busy buffer waits - how can you find whats causing it?
Can we commit inside a function in oracle?
What is clustered table in Oracle?
7. Repeat query (7) but also display all clients who have never ordered anything.
Explain the use of record option in exp command.
difference between truncate and delete ,drop?
> 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 define a record variable to store a table row?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.