Ask Questions & Get Answers at ibibo sawaal
Home Ask Question Answer Questions My Q&A CategoriesAsk the experts Expert leader board

Home » My Q&A

 

Kamlesh B's Questions & Answers

159

Rank

5482

1688

31

32

RSS Feed

Can one read/write files from PL/SQL?

Asked by tm prasana in Computers & Technology at   6:57 PM on November 27, 2008

Kamlesh B's Answer

A DBA user needs to grant you access to read from/ write to a specific directory before using this package.

Answered at 7:11 PM on November 27, 2008

Read all answers

Can one call DDL statements from PL/SQL?

Asked by tm prasana in Computers & Technology at   6:57 PM on November 27, 2008

Kamlesh B's Answer

Yes, One can call DDL statements like CREATE, DROP, TRUNCATE, etc. from PL/SQL by using the "EXECUTE IMMEDIATE" statement (native SQL).

Answered at 7:11 PM on November 27, 2008

Read all answers

How does one loop through tables in PL/SQL?

Asked by tm prasana in Computers & Technology at   7:02 PM on November 27, 2008

Kamlesh B's Answer

One can make use of cursors to loop through data within tables.

Answered at 7:06 PM on November 27, 2008

Read all answers

Can one use dynamic SQL statements from PL/SQL?

Asked by tm prasana in Computers & Technology at   7:00 PM on November 27, 2008

Kamlesh B's Answer

Yes, Starting from Oracle8i one can use the "EXECUTE IMMEDIATE" statement to execute dynamic SQL and PL/SQL statements (statements created at run-time).

Answered at 7:09 PM on November 27, 2008

Read all answers

How does one get the value of a sequence into a PL/SQL variable?

Asked by tm prasana in Computers & Technology at   7:01 PM on November 27, 2008

Kamlesh B's Answer

one can use embedded SQL statements to obtain sequence values:
For eexample:
select sq_sequence.NEXTVAL into :i from dual;

Answered at 7:07 PM on November 27, 2008

Read all answers

What is the difference between %TYPE and %ROWTYPE?

Asked by tm prasana in Computers & Technology at   7:01 PM on November 27, 2008

Kamlesh B's Answer

Difference between %TYPE and %ROWTYPE

1. %ROWTYPE used to declare the field and %TYPE used to declare the record
2. %ROWTYPE used to declare the record and %TYPE used to declare the field
3. BOTH ARE SAME
4. %ROWTYPE gives an error.

Answered at 7:08 PM on November 27, 2008

Read all answers

How often should one COMMIT in a PL/SQL loop? / What is the best commit strategy?

Asked by tm prasana in Computers & Technology at   7:03 PM on November 27, 2008

Kamlesh B's Answer

one should COMMIT less frequently within a PL/SQL loop to prevent ORA-1555 (Snapshot too old) errors. The higher the frequency of commit, the sooner the extents in the undo/ rollback segments will be cleared for new transactions, causing ORA-1555 errors.

Answered at 7:05 PM on November 27, 2008

Read all answers

How do you know whether your computer is 32 bit or 64 bit?

Asked by ankit gupta in Computers & Technology at   6:05 PM on November 27, 2008

Kamlesh B's Answer

You can determine it through:

My Computer > Properties > Advanced > Environment Variables > System Variables > Processor_Architecture

x86 is 32-Bit

x64 is 64-Bit

Answered at 6:51 PM on November 27, 2008

Read all answers

What is the difference structured programming language and java?

Asked by ankit gupta in Computers & Technology at   6:05 PM on November 27, 2008

Kamlesh B's Answer

Java is object-oriented language and the others are procedural-oriented languages.

Answered at 6:50 PM on November 27, 2008

Read all answers

Give list of programming language?

Asked by ankit gupta in Computers & Technology at   6:04 PM on November 27, 2008

Kamlesh B's Answer

Language like C, C++, JAVA ,C#, J#, D, PASCAL, COBOL, FOTRAN, .NET, VB are called programing language.

Answered at 6:56 PM on November 27, 2008

Read all answers

Editor's Pick
Prev | Next

Categories

View All
sawaal signature
sawaal free visiting card