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 / shrikant
After any DDL statement commit will happen by default. So
after any DML statement if you execute DDL satement then
everything is commited.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Will you be able to store pictures in the database?explain.
How to view all columns in an existing table?
How to convert csv to table in oracle?
what is normalisation?what are its uses?
How do I start tns listener?
How to use subqueries with the exists operator in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Please explain oracle data types with examples?
Can a formula column be obtained through a select statement ?
various types of hints and their usage
How to add a new column to an existing table in oracle?
Name the various constraints used in oracle?
what is insert all statement in sql
What are the four Oracle system processes that must always be up and running for the database to be useable?
How to define a specific record type?