adspace


What are records give examples?

Answer Posted / Amla Rani

In SQL and PL/SQL, a record is a user-defined collection of related data items. Each record has a name and consists of one or more fields (or attributes). Records can be considered as a table with only one row. An example of creating a record in SQL would be: CREATE OR REPLACE TYPE Employee_Record AS OBJECT (id NUMBER, name VARCHAR2(50), salary NUMBER);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is dbms? : Sql dba

1069


What is your daily office routine?

2351


what are the advantages of sql ? : Sql dba

1153


what is collation? : Sql dba

1242


what is bcp? When does it used? : Sql dba

1065


Is inner join faster than left join?

1287


Is primary key always clustered index?

1101


define sql insert statement ? : Sql dba

1108


What is the best sql course?

1062


how to escape special characters in sql statements? : Sql dba

1124


How do I remove duplicates in two columns?

1201


what is schema? : Sql dba

1163


Can we use distinct and group by together?

1146


what are all the common sql function? : Sql dba

1141


What is the current version of postgresql?

1188