Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
SQL PLSQL Interview Questions
Questions Answers Views Company eMail

what is the bond code in materialized view?

 2003

what is the boundary line in varrays?

HCL,

1 6142

what is explain plan?

 4 17305

When we give SELECT * FROM EMP; How does oracle respond?

Accenture, HCL, Infosys,

24 40657

What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

 2 10769

what is inline command?

 2 7471

What are the default Oracle triggers??

CGI, Tech Mahindra,

2 14698

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

Wipro,

8 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

TCS,

7 7583

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;

Accenture,

7 7548

Can we write create command in the plsql block?if possible how?

 2 5648

What is differance unique key and primary key.

EDS,

7 7790

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then when no_data_found then when too_many_rows then end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

Satyam,

3 6385

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

how to retrive only second row from table?

IBM,

31 36992

Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

Which is faster count (*) or count 1?

137

What does joining a thread mean?

130

Explain the select statement in sql?

196

How do I access sql anywhere database?

133

What are some emotional triggers?

146




Enlist the data types that can be used in pl/sql?

191

How do rank () and dense_rank () differ?

145

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

169

What is an implicit commit?

147

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

163

Is left join faster than join?

132

What steps server process has to take to execute an update statement?

168

What is the purpose of using pl/sql?

189

Why use truncate instead of delete?

130

Is big data nosql?

144

For More Un-Answered { SQL PLSQL } Questions Click Here