i have executed the Delete command after the I have created
table whether deletions will be
commit or not? if table is successfully created?
Answer Posted / vandana
After creation of table. delete will commit.
| Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
What is execute immediate in oracle?
What is tns entry?
How to run the anonymous block again?
How to use subqueries with the in operator using oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What is the data pump export utility?
How would you begin to troubleshoot an ORA-3113 error?
When do you get a .pll extension in oracle? Explain its importance
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
> 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?
Is oracle a relational database?
How to insert a new row into a table in oracle?
Explain about your project and its relation to the current job position you are applying to?
Explain view?
types of indexes and the rationale behind choosing a particular index for a situation.