What is different bet native dynamic sql and Dbms_Sql?

Answer Posted / gapbridge

In Oracle Database 11g, NDS supports statements larger than 32 KB by accepting a CLOB argument.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define a data source name (dsn) in odbc manager?

732


Explain what are the different type of segments?

732


How do I use unicode codesets with the weblogic jdriver for oracle driver?

751


how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

1790


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2052


What is an oracle function?

812


What is oracle rownum?

687


What are the advantages of oracle?

746


What are the different oracle database objects?

798


What are the different types of trigger and explain its various uses and functions?

730


Explain oracle’s system global area (sga).

848


What are the parameters that we can pass through a stored procedure?

797


What is oracle open database communication (odbc)?

738


How to create an initialization parameter file?

719


what is port in oracle? how is it related to database application.

1666