Answer / Pradeep Kumar Pandey

To declare a fixed-length string value in PL/SQL, you can use the VARCHAR2 data type with a specific length enclosed within single quotes. For example:nDECLARE str VARCHAR2(10) := 'Hello';

What is Raise_application_error ?

1 Answers  

---

Explain lock escalation? : Transact sql

1 Answers  

---

What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,

---

How many LONG columns are allowed in a table?

6 Answers   CTS,

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

Can we interchange parameters in procedure while calling

1 Answers   TCS,

---

What is trigger in pl sql?

1 Answers  

---

How pl/sql source code can be protected?

3 Answers  

---

What are the blocks in stored procedure?

6 Answers   Microsoft,

---

What are two parts of package ?

2 Answers   Infosys,

---

Can a key be both primary and foreign?

1 Answers  

---

What is the use of sql trace?

1 Answers  

---