what is explain plan?4 18284
What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?2 11584
what is inline command?2 8069
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 33699
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 9167
Can we write create command in the plsql block?if possible how?2 6111
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 7171
what are properties of a transaction? : Sql dba
How do I create a memory optimized filegroup?
Is it possible for a table to have more than one foreign key?
What is nvarchar in sql?
Why does sql need a server?
What version is sql?
Can we use ddl statements in stored procedure sql server?
How long it takes to learn pl sql?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
what is the difference between a web-garden and a web-farm? : Sql dba
what are the join types in tsql? : Transact sql
Which is faster union or join?
How are sql commands classified?
What is sql and how does it work?
Can you selectively load only those records that you need? : aql loader