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

How to load data with sql*loader?

1052

---

What is the max nvarchar size?

983

---

What is a temporal table?

934

---

What are the dml statements?

1144

---

How do you update a table in sql?

993

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2029

---

What does select top 1 do in sql?

1102

---

how to create a new view in mysql? : Sql dba

941

---

What are the advantages of sql?

1055

---

Does a primary key have to be a number?

966

---

Explain ttitle and btitle.

1123

---

Is join an inner join?

981

---

what is the difference between a local and a global temporary table? : Sql dba

1074

---

Can we create view in stored procedure?

979

---

What do you mean by field in sql?

1080

---