Answer Posted / rajesh venati

For SQL:-

SELECT SUBSTR(ENAME,1,1) FROM EMP;
--------------------------------------------------------------
For PL-SQL:-

DECLARE
CURSOR ECUR IS SELECT SUBSTR(ENAME,1,1) FROM EMP;
BEGIN
FOR V_ECUR IN ECUR LOOP
DBMS_OUTPUT.PUT_LINE(V_ECUR.ENAME);
END LOOP;
END;

Explain the steps needed to create the scheduled job?

965

---

What is difference between mysql and postgresql?

1040

---

what is the use of friend function? : Sql dba

970

---

What is sqlcontext?

980

---

What are the operators in sql?

969

---

Why do we need unique key in a table?

882

---

What is the difference between microsoft access and sql?

958

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

930

---

What is the current version of postgresql?

1004

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2020

---

what is cross join? : Sql dba

938

---

How do you use join?

886

---

What is an inconsistent dependency?

976

---

What is a design view?

883

---

What is example of database?

984

---