what is explain plan?4 17305
What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?2 10769
what is inline command?2 7471
hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: firstname.lastname@example.org 32345
Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question
Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;7 7548
Can we write create command in the plsql block?if possible how?2 5648
I have a small PL/SQL Block
assume in this way
select * from emp where empno=100;
when others then
1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?2 6693
Which is faster count (*) or count 1?
What does joining a thread mean?
Explain the select statement in sql?
How do I access sql anywhere database?
What are some emotional triggers?
Enlist the data types that can be used in pl/sql?
How do rank () and dense_rank () differ?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is an implicit commit?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
Is left join faster than join?
What steps server process has to take to execute an update statement?
What is the purpose of using pl/sql?
Why use truncate instead of delete?
Is big data nosql?