Answer Posted / john bershan

select to_char(column_name,'dd-mon-yyyy') from <table_name>;

how many tables will create when we create table, what are they? : Sql dba

1154

---

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

1065

---

Is inner join faster than left join?

1287

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2099

---

what is sql server agent? : Sql dba

1188

---

how to escape special characters in sql statements? : Sql dba

1124

---

Do we need to rebuild index after truncate?

1151

---

define sql insert statement ? : Sql dba

1108

---

what are the advantages of sql ? : Sql dba

1154

---

what is collation? : Sql dba

1242

---

How do I remove duplicates in two columns?

1202

---

Can we use distinct and group by together?

1146

---

Does group by remove duplicates?

1120

---

Is primary key clustered index?

1026

---

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

1252

---