Answer / yam

to see the framework of table use

DESCRIBE tablename;
or DESC tablename

Answer / sudheer kumar mikkilineni

select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from
dual;

What is trigger in sql and its types?

0 Answers  

---

What is compute?

0 Answers  

---

What is scalar and vector?

0 Answers  

---

What's the difference between inner join and left join?

0 Answers  

---

how view used for security purposes?

3 Answers   Glam India,

---

---

How to run sql statements through the web interface?

0 Answers  

---

What is the difference between union and union all command?

0 Answers  

---

What is the Diff b/w Constraints and Trigeer

4 Answers   HCL,

---

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

---

What are the advantages of stored procedure?

0 Answers  

---

Why commit is not used in triggers?

0 Answers  

---

Is inner join faster than left join?

0 Answers  

---