 Related Questions Latest Answer : Dec(p,s), desimal(p,s), double precision, foat, int, inteager, real, smallint, numeric(p,s), number(p,s), char(size), varchar2(size), long, raw, long raw, date, timestamp, urowid(size), rowid, boolean, nchar(size) , nvarchar2(size), bfile, blob, clob, ... Latest Answer : VARCHAR2: Max Size=4000 bytesCHAR: Max Size=2000 bytesNUMBER(p,s): The precision p can range from 1 to 38. The scale s can ... 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 ... Display the records between two range I know the nvl function only allows the same data type(ie. number or char or date Nvl(comm, 0)), if commission is null then the text “Not Applicable” want to display, instead of blank space. How do I write the query Answer posted by Scott on 2005-05-25 18:41:26: From the SQL> prompt, type the following: select * from v$version; Latest Answer : Just type define on your sql prompt ..you will get required info.. ... Latest Answer : Till Oracle 7.0, only 12 triggers could be defined per table. In later versions there is no such limitation. ... 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; ... 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 ... What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ? CHAR pads blank spaces to the maximum length. VARCHAR2 does not pad blank spaces. For CHAR it is 255 and 2000 for VARCHAR2.
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0 
1