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: pankit.lodaya@accenture.com
8 34742Begin 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
TCS,
7 9918Dear 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 10363I have a small PL/SQL Block
assume in this way
begin
select * from emp where empno=100;
exception
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 7562
Is primary key an index?
How do I order columns in sql?
What is cursor and why it is required?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
How do I send sql query results to excel?
Explain what is a column in a table?
What is rank dense_rank and partition in sql?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is nvl?
What is sqlservr exe?
What is the difference between left outer join and left join?
How do I write a cron which will run a sql query and mail the results to agroup?
How does one use sql*loader to load images, sound clips and documents? : aql loader
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba