What is the maximum number of CHECK constraints that can be
defined on a column ?
Answers were Sorted based on User's Feedback
what is trigger?
Give syntax for SQL and ORACLE joins.
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
Can group functions be used in the order by clause in oracle?
How to create a testing table in oracle?
What are named parameters?
How will you identify oracle database software release?
What are the advantages of Views ?
How to define a specific record type?
How many data types are supported?
How to store only time; not date and time?