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;
/

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1083

---

How do I view a view in sql?

887

---

What is rownum and rowid?

982

---

Does view contain data?

979

---

What are sql commands?

932

---

Does postgresql run on the cloud?

1072

---

How do you change a value in sql?

961

---

What are properties of the transaction?

956

---

How to rename a column in the output of sql query?

998

---

What is the difference between local and global temporary table?

986

---

What is the most common sql injection tool?

991

---

How does left join work in sql?

938

---

How do you write an inner join query?

888

---

how can we know the number of days between two given dates using mysql? : Sql dba

990

---

Is not null in sql?

922

---