what are %TYPE and %ROWTYPE? what is the difference?
Answer Posted / srikanth
%type can hold one perticular variable
%rowtype decalre total row declaration
Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
Why left join is used in sql?
How to create your own reports in sql developer?
What is recursive stored procedure?
What is the difference between functions, procedures, and packages in pl/sql?
Why is sql*loader direct path so fast?
Can we create index on primary key?
Is pl sql and postgresql same?
What is dynamic query?
Which operator is used in query for pattern matching?
What is the difference between having and a where in sql?
What are all the ddl commands?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Does execute immediate commit?
What is cascade in sql?
How do you know if a relationship is 2nf?