-
SQL
What are the data types in oracle?
MahanamShakyamuni
- Nov 19th, 2010
In SQL, there are mainly varchar2, char, number, date...then each of them has subtypes like number has integer, real etc..Following website gives all details:For SQL datatypes refer:http://download....
pradeepnagaraja
- Nov 18th, 2010
Different data type used in Oracle are number, char, varchar, varchar2, clob, blob, long.
-
Index Use
If you have a three columns table with one index on 2nd Column. In the SELECT statement you retrived column 1, can index be used or not?
amitsrivastava115
- Aug 2nd, 2011
Use index in the where clause , this way you can use it other wise not ...
geetha
- Jul 30th, 2011
Index will be used if the retrieval is based on an indexed column .if the where clause uses a column with index then the query will be executed based on that index.
