How many LONG columns are allowed in a table?
Answers were Sorted based on User's Feedback
Answer / harshit varshney
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.
Is This Answer Correct ? | 4 Yes | 0 No |
Why is pl sql used?
Explain Connect by Prior?
What is clustered and nonclustered index in sql?
How global cursor can be declare with dynamic trigger ?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.
Can we insert data in view?
Mention what does the hierarchical profiler does?
Explain foreign key in sql?
How do you retrieve the last N records from a table?
When the mutating error will comes? and how it will be resolved?
I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?