Answer Posted / Siddharth Kumar

In SQL and PL/SQL, the [or replace] clause is used to replace specified characters in a string with other characters or remove them entirely. For example: replace(column_name, 'old_value', 'new_value')

Can we rollback truncate?

1083

---

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

1125

---

what are the advantages of sql ? : Sql dba

1154

---

Is inner join faster than left join?

1287

---

what are aggregate and scalar functions? : Sql dba

1142

---

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

1065

---

What is the current version of postgresql?

1188

---

what is collation? : Sql dba

1242

---

what is dbms? : Sql dba

1070

---

what is schema? : Sql dba

1163

---

how to start mysql server? : Sql dba

1279

---

Is primary key clustered index?

1028

---

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

1156

---

Can delete statement be rollbacked?

1065

---

define sql insert statement ? : Sql dba

1110

---