Answer Posted / mukesh

Ques:= Can we use more than one null value for unique key?
Ans:=Yes, we can use multiple Null values in case of Unique Key
Column.

SQL> create table abcd(name varchar2(10) unique);

Table created.

SQL> insert into abcd(name)values('amit');

1 row created.

SQL> insert into abcd(name)values('MKS');

1 row created.

SQL> insert into abcd(name)values(null);

1 row created.

SQL> insert into abcd(name)values(null);

1 row created.

SQL> insert into abcd(name)values(null);

1 row created.

SQL> insert into abcd(name)values('');

1 row created.

SQL> insert into abcd(name)values('');

1 row created.

SQL> insert into abcd(name)values('');

1 row created.

SQL> select * from abcd order by name desc;

NAME
----------






amit
MKS

8 rows selected.

Note:= Here blank space above represents the entries of null
statements..!!

SQL> select nvl(name,0) from abcd;

NVL(NAME,0
----------
amit
MKS
0
0
0
0
0
0

8 rows selected.

SQL> select nvl(name,'a') from abcd;

NVL(NAME,'
----------
amit
MKS
a
a
a
a
a
a

8 rows selected.

What does the base_object_type column shows in the user.triggers data dictionary view?

1044

---

Is it possible for a table to have more than one foreign key?

1028

---

What type of database is cloud sql?

1092

---

What is difference between joins and union?

1117

---

What is the syntax to add a record to a table?

1086

---

What is substitution variable in pl sql?

1040

---

Can dml statements be used in pl/sql?

1071

---

what are the 'mysql' command line options? : Sql dba

1070

---

How to use sql statements in pl/sql?

1114

---

What is scalar function in sql?

1037

---

Can pl sql procedure have a return statement?

1023

---

What is the maximum rows in csv?

920

---

what are the security recommendations while using mysql? : Sql dba

1112

---

What does a pl/sql package consist of?

971

---

Why do we use cursors?

984

---