How to define a variable of a specific record type?
What is use of oracle?
without using count(*) and rownum how can we count total record in a table
What is varray?
How do we know whether an index is created on a table ???
How to assign values to data fields in record variables?
How data locks are respected in oracle?
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
What is the difference between Outer join and Full outer join?
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
How to create a server parameter file?
How many types of tables are there in oracle?