Categories: Oracle FAQs, Interview Questions03/20/10
A candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary key of the table. If thetable has more than one candidate key, one of them will become the primary key, and the rest are called alternate… more » 03/17/10
A column defined as UNIQUE can contain NULL while a column defined as PRIMARY KEY cannot contain NULL.
As you may know Oracle treats each NULL unique. more » 01/02/10
 05:19:48 am, by moderator_damian  332 views
Categories: Oracle FAQs, Oracle General, Interview Questions Finding grants on the object Fire the below query on user_tab_privs table to find the grants and their details. SELECT * FROM user_tab_privs; more » How to find the Oracle version of a particular database? Use of either of these queries below: select * from v$versionselect * from product_component_version more » How to get number of columns in a table? SELECT COUNT (column_name) FROM user_tab_columns WHERE table_name = '<tablename>'; more » Tag cloud«all_source table»,«alter data type of column having data»,«ascii for newline and tab»,«b-tree indexes»,«bitmap indexes»,«bulk collect»,cardinality,«column constraints»,«constraints on a table»,«control files»,cube,«ddl commands inside pl/sql proc»,«debugging a procedure»,«delete duplicates»,«describing a package body in sql plus»,«duplicate records»,«dynamic table creation in stored procedure»,«export saved database connections in toad»,«grants of an object»,«mutliline data in oracle»,«number of columns in a table»,«oracle aggregate functions»,«oracle data loader»,«oracle product version»,«oracle version»,«pragma autonomous_transaction»,rollup,«source code of a package»,«special characters in varchar2 column»,sql*loader,«toad database connections file»,user_tab_columns,user_tab_privs |
Hit Counter |
XML Feeds