Answer / madhavi

SQL> set serverout on
SQL>
SQL> create or replace
2 type new_person as object (
3 last_name varchar2(100),
4 phone varchar2(100),
5 member function get_last_name return varchar2,
6 member function get_phone_number return varchar2 )
7 not final
8 /

Type created.

Answer / chandu

create type addresstype as object
(hno varchar2(5),street varchar2(10),
city varchar2(10),pin varchar2(5));

Now we use this object in creating table like this.

create table employee(empno number(5),job varchar2(10),sal
number(5),empaddress addresstype);

insert into employee
values(101,'clerk',6000,addresstype('114a','gandhi','hyd',50001));

Answer / purushottam mishra

by using dynamic sql

Which are the most commonly used sql joins?

1 Answers  

---

describe transaction-safe table types in mysql : sql dba

0 Answers  

---

What is the use of sqldataadapter?

0 Answers  

---

Is it possible to pass parameters to triggers?

0 Answers  

---

What is full join?

0 Answers  

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.

5 Answers  

---

How do I run pl sql in sql developer?

0 Answers  

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  

---

What is the use of index in sql?

0 Answers  

---

What is a pragma statement?

0 Answers  

---

how can we submit a form without a submit button? : Sql dba

0 Answers  

---