Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

how can i create a user defined datatype

Question Posted / arpitha2206

Answers were Sorted based on User's Feedback



how can i create a user defined datatype..

Answer / mv

we can create a user defined data type by using subtype.

Is This Answer Correct ?    4 Yes 0 No

how can i create a user defined datatype..

Answer / vetrikumaran

WE CAN CREATE A USER DEFINED DATATYPE BY USING RECORD DATATYPE..

RECORD,INDEX BY TABLE ARE NOT BUT USER DEFINED DATATYPES

Is This Answer Correct ?    4 Yes 0 No

how can i create a user defined datatype..

Answer / avi007

We can create a user defind datatype by using abtract
datatype.

create type address_type as object
( street varchar2(10),
pincode number(6);
);

This is used in

create table emp
(Empname varchar2(20),
Adress address_type);

// address_type is user defined datatype

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Why do we need cursor in pl sql?

0 Answers  

What is a constraint? Tell me about its various levels.

0 Answers  

What is field delimiter?

0 Answers  

List different type of expressions with the example.

0 Answers  

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,

What is the difference between having and a where in sql?

0 Answers  

Can we insert in view in sql?

0 Answers  

Write a query to get last 10 records from the table.

12 Answers   iNautix,

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 Answers  

What is a function in oracle pl sql?

0 Answers  

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

For more SQL PLSQL Interview Questions Click Here
Categories