 Related Questions Latest Answer : The Address Field of the index is called ROW IDFormat: BBBBBBB.RRRR.FFFFFFFF: Unique Number given by oracle engine to each Data fileBBBBBBB: each Data File is further divided in Data BlocksRRRR: Data Blocks can store one or more Records ... Latest Answer : Only one column can have LONG data type. And that column cannot be used in WHERE clause or in ORDER BY clause. Also we cannot add primary key constraint to that column only not to the whole table, that means we will give primary key to any column in the ... Latest Answer : only one long col allowed in a table. ... Answer posted by Scott on 2005-05-25 18:43:29: SELECT rownum, rowid FROM sometable Latest Answer : Besides these, the other pseudo columns are: user,uid ... INSTR (String1,String2(n,(m)),INSTR returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character Latest Answer : substr is used to get a part of given string,instr is used to search a charcter in the given string.select substr(ename,1,3) three_charename, instr(ename,'A',1) a_present_at from emp; ... ROWID is a pseudo column attached to each row of a table. It is 18 character long, blockno, rownumber are the components of ROWID. Latest Answer : rowid is a unique value assigned by system automatically when ever a insert statement gets successful.rowid contains the address of data file,data block, object id, rownumber ... Using ROWID.CONSTRAINTS Latest Answer : by using the index and rowid ... SAVEPOINTS are used to subdivide a transaction into smaller parts. It enables rolling back part of a transaction. Maximum of five save points are allowed. Latest Answer : savepoint is used to give some break points between multiple transactions so that if some transaction is required to be rolledback then some of transaction will still available in buffer. commit will save the data and remove all savepoints ... CHAR,VARCHAR2,NUMBER,DATE,RAW,LONG and LONG RAW. Latest Answer : CHAR,VARCHAR2,NUMBER,DATE,RAW,LONG and LONG RAW,BLOB, CLOB,NCLOBFOR ORACEL 9I AND ABOVE.TIMESTAMP, TIMESTAMP WITH TIME ZONE, YEAR TO DAY, DAY TO SECOND ... How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ? Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
