Answer Posted / chinna

truncate table <tbl_nm>

Is sql procedural language?

539

---

Are stored procedures faster than queries?

512

---

What are types of joins?

522

---

Is natural join same as inner join?

495

---

Is grant a ddl statement?

441

---

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

881

---

what is the difference between truncate and drop statements? : Sql dba

535

---

How do I run a sql script?

505

---

What does trigger mean in slang?

507

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1043

---

What does pl sql developer do?

498

---

What are the different ways to optimize a sql query?

474

---

How can we make an if statement within a select statement?

524

---

What is cartesian join in sql?

544

---

What is the command used to fetch first 5 characters of the string?

872

---