What is transaction control statement and how many types of transaction control statement in Oracle?
1155Post New Oracle General Questions
What is oracle database 10g express edition?
Explain cascading triggers.
How to create a new tablespace in oracle?
How to check the oracle tns settings?
How to commit the current transaction 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
How to use like conditions in oracle?
How to use subqueries with the in operator using oracle?
What is meant by raw datatype?
How does the on-delete-cascade statement work?
What the is the diff between local index and global index. give some example.
Give the various rollback segment states.
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How to experiment a data lock in oracle?
What is the difference between alert log file and tarce file ?