Answer Posted / Rajesh Kumar Gautam

"To get a list of columns (or fields) in an existing SQL table, you can use the DESCRIBE or COLUMNS command. The general syntax for both commands is similar:
```
DESCRIBE table_name;
COLUMNS FROM table_name;
```
Both commands will return a list of columns (fields) along with their data types, lengths, and other characteristics."n

What is your daily office routine?

2353

---

how to use regular expression in pattern match conditions? : Sql dba

1125

---

Is inner join faster than left join?

1287

---

If a cursor is open, how can we find in a pl/sql block?

1252

---

Can delete statement be rollbacked?

1065

---

Can we rollback truncate?

1083

---

What is the best sql course?

1064

---

Is primary key clustered index?

1028

---

what is collation? : Sql dba

1242

---

what are the advantages of sql ? : Sql dba

1154

---

Can we use distinct and group by together?

1146

---

define sql insert statement ? : Sql dba

1110

---

what is bcp? When does it used? : Sql dba

1065

---

Do we need to rebuild index after truncate?

1154

---

what are all the common sql function? : Sql dba

1141

---