Answer Posted / apparao akki

Hi all,

plz find the below executed report on the same.
------------------------------------------------------


SQL> select * from person;

PERSON_ID FIRST_NAME LAST_NAME
TITLE_1 TITLE_2 SOCS
---------- --------------------- -------------------------
---------- ---------- -----------
9 ssss rrrrr
tttt gggg 67778-3
1 THUUTHTUT lofstrom
ba null 4940-343
1 ffsdf fsdfsd
fdsfsd fsdf 5454
1 THUUTHTUT lofstrom
ba null 4940-343
1 THUUTHTUT lofstrom
ba null 4940-343
1 appa akki
s/w btech 3i
2 rao
s/w kmm 3i
4 bunny neel
lkg ukg home

8 rows selected.

SQL> select unique(person_id),last_name from person;

PERSON_ID LAST_NAME
---------- -------------------------
2
1 lofstrom
4 neel
1 fsdfsd
9 rrrrr
1 akki

6 rows selected.

SQL> select distinct(person_id) from person;

PERSON_ID
----------
4
9
2
1

What is a primary key example?

956

---

What are different types of keys?

1104

---

what are the advantages of mysql in comparison to oracle? : Sql dba

1002

---

How do you optimize a stored procedure in sql?

957

---

In pl/sql, what is bulk binding, and when/how would it help performance?

994

---

What are three advantages to using sql?

1019

---

What happens when a trigger is associated to a view?

913

---

What is embedded sql what are its advantages?

1041

---

Why is stored procedure faster than query?

960

---

What is the best free sql database?

1051

---

Why indexing is needed?

983

---

Can we rollback delete command?

984

---

What is the syntax and use of the coalesce function?

1173

---

How does sql store data?

912

---

Can we use the cursor's to create the collection in PL/SQL?

1025

---