Answer Posted / chandrakant rathod

We can get all tables for particular instance using below block .

SET SERVEROUTPUT ON;
begin
for rec in (select object_name from user_objects where object_type='TABLE')
loop
dbms_output.put_line('TABLE'||rec.object_name);
end loop;
end;
/

Which constraints we can use while creating database in sql?

1079

---

What is sqlerrm?

934

---

what are the properties and different types of sub-queries? : Sql dba

1034

---

What type of join is sql join?

980

---

what is csv? : Sql dba

995

---

How can get second highest salary in sql?

988

---

What is snowflake sql?

1071

---

What is cursor and why it is required?

1183

---

what is an alias command? : Sql dba

1111

---

Why is theta join required?

1145

---

write an sql query to find names of employee start with 'a'? : Sql dba

1027

---

Are stored procedures faster than queries?

944

---

What is sql architecture?

1048

---

is mysql query is case sensitive? : Sql dba

1100

---

What is the difference between having clause and where clause?

1059

---