What are named parameters?
No Answer is Posted For this Question
Be the First to Post Answer
What is Partitions in Table ?
What is a named program unit?
Where do we use decode and case statements?
How can we delete duplicate rows in a table?
Give the different types of rollback segments.
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
What is the difference between post-database commit and post-form commit?
What are the types of partitions in oracle?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
how to get count of tables in particular database in Oracle?
Can we commit inside a function in oracle?