USCIS Freedom of Information Act and Privacy Act; Website Policies; GOVERNMENT. U.S. Department of Homeland Security; U.S. Customs & Border Protection; U.S. Immigration & Customs Enforcement; U.S. Department of State; Passports; Visa Bulletin; White House; DHS Office of Inspector General; USA.gov
Select the cell, and then press CTRL+C to copy the value to the Clipboard. Select the cells or ranges of cells that contain the numbers stored as text that you want to convert. How to select cells, ranges, rows, or columns. To select. Do this. A single cell. Click the cell, or press the arrow keys to move to the cell.
Editorial / Best 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 table except the column having the long data type. If we give, we get the error ORA-02269: key column cannot be of LONG datatype. Showing Answers 1 - 5 of 5 Answers.