Interested to Buy Any Domain ? << Click Here >> for more details...
What are % TYPE and % ROWTYPE ? What are the advantages of
using these over datatypes?
- 4 Answers
- 12808 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
"% Type "is used to extract definition of the column of a
table.
"%Rowtype" is used to extract definition of the columns of
all columns.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is a trigger in sql?
Is stored procedure faster than query?
What is data definition language?
What is offset in sql query?
what is bcp? When is it used?
What is a primary key example?
Explain the difference between drop and truncate commands in sql?
Which is better join or subquery?
What is sql*loader?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
How do I trace sql profiler?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
Is grant a ddl statement?
Does sap use sql?
Why do we use joins in sql?
