sulakshana

• Jan 16th, 2007

Try out with adopendynamic,adlockoptimistic.Also try it by  givingselect distinct(column_name) from table_namedo replyThanks and regards

Chandra

• Mar 18th, 2006

In this case record set is open  in adOpenForward and adLockreadonlyor (by removing the loaktype or open mode)rs.Open CadSql, Cnn

Answer Question  Select Best Answer

Truncate command will delete all records and the most important thing to make note of truncate command is since truncate command cannot be rolled back one must make sure to take proper backup of table data before performing the truncate command. Truncate command is thus used to remove all rows from either a table or a cluster. If one wants to use the truncate command in a cluster they can use it only...

gvvskumaran

 Profile Answers by gvvskumaran Questions by gvvskumaran

• Jan 15th, 2007

* Used to Delete all the datas in a table .* Cannot be rollbacked.

Answer Question  Select Best Answer

The programmer may like the database o take some action when a database event occurs. In order to achieve the above purpose triggers are defined. The trigger body refers to the code written within the trigger which gets fired and executed when the related database event associated with the trigger occurs. On this situation one may have the question what is the event on the happening of which triggers...

gvvskumaran

 Profile Answers by gvvskumaran Questions by gvvskumaran

• Jan 15th, 2007

 trigger stored in the database can include SQL and PL/SQL or Java statements to run as a unit and can invoke stored procedures.Triggers are implicitly fired by Oracle when a triggering event occ...

Answer Question  Select Best Answer

gvvskumaran

 Profile Answers by gvvskumaran Questions by gvvskumaran

• Jan 15th, 2007

Do as john said.... use any data migration tool you will get that

John Thomas Ambadan

• Nov 29th, 2006

If u want to migrate ur access database to oracle, u can use Oracle migration work bench for microsoft access.for more details refer oracle documentation.

Answer Question  Select Best Answer

ranjeetapegu

 Profile Answers by ranjeetapegu Questions by ranjeetapegu

• Jan 11th, 2007

A temporary table is a table where data is stored temporarily during execution of a session and it is deleted as soon as session is over or commit is done. For example a create global temporary table ...

Answer Question  Select Best Answer

ranjeetapegu

 Profile Answers by ranjeetapegu Questions by ranjeetapegu

• Jan 11th, 2007

The content canvas is the base canvas , it will always be there in the window. To hide the stack canvas you can use  HIDE_VIEW('name_stack_canvas'); SHOW_VIEW('name_content_canvas');--optional

Answer Question  Select Best Answer

eibbed

• Jan 2nd, 2007

Hi thereI will gladly assist you with Ingres issues.Please let me know what you need help with.eibbed

Avanthi

• Dec 27th, 2006

Hi Eibbed,This is Avanthi.I just saw your message.Recently I got a job as Test Engineer.My product is Ingres database.It looks like you worked on Ingres earlier.I dont have any knowledge about Ingres.Can you please help me out.Thanking you in anticipationAvanthi

Answer Question  Select Best Answer

romeopeay

 Profile Answers by romeopeay Questions by romeopeay

• Dec 31st, 2006

Row Cache is also known as the Dictionary Cache in the Shared Pool.

Answer Question  Select Best Answer

Vijay Akumalla

• Dec 20th, 2006

Hi,If a Form Item's property needs to be changed, then it should be done from a form trigger and not a database trigger. You can use Visual Attributes or Property Classes to achieve this or a form tri...

Answer Question  Select Best Answer

Ashok Nayak

• Dec 19th, 2006

The problem arises because of the input date. You must not be having the timestamp in your input. So when you retrieve it into the date format "DD_MON_YYYY hh:mm:ss", what happens is that a typec...

Answer Question  Select Best Answer

Abbireddy Anil Kumar

• Dec 15th, 2006

set_block_property('blockname',orderby clause,'fieldname);

subasini sahu

• Nov 17th, 2006

Before we have to clear the Block,Then in Set_Block_Property put the where conditions value.Thanks ,Subasini.

Answer Question  Select Best Answer

Abbireddy Anil Kumar

• Dec 15th, 2006

declareserch_item number;a number;b number;beginserch_item:=:emp.empno;b:=:system.cursor_record;first_record;a:=:system.cursor_record;for i in a..b-1 loopif srich_item=:emp.empno thenmessage('Employee No Already Exists')raise form_trigger_failre;elsenext_record;end if;end loop;end;

Anil Kumar

• Dec 12th, 2006

declarea number;beginfirst_record;a:=system.current_record;for i in a..system.current_record-1 loopchecking codeend loop;

Answer Question  Select Best Answer

Pawan Ahuja

• Dec 9th, 2006

hi,The Frist step u have to define a EXECUTABLE for your program (for Ex.if your r woking with reports then define a EXECUTABLE NAME,SHORTNAME and the very important step is to select the EXECUTION ME...

bommana_vidyasagar

 Profile Answers by bommana_vidyasagar Questions by bommana_vidyasagar

• Nov 26th, 2006

hi,The Frist step u have to define a EXECUTABLE for your program (for Ex.if your r woking with reports then define a EXECUTABLE NAME,SHORTNAME and the very important step is to select the EXECUTION ME...

Answer Question  Select Best Answer

raghu

• Nov 22nd, 2006

Hii think u studied in sree nipuna technologies right..............

Subasini

• Nov 17th, 2006

Data base link is a Database object .Basically we use it when we require to connect to other user or any remote user from current user.Syntax for creation is Create database link link_name connect to&...

Answer Question  Select Best Answer

subasini sahu

• Nov 17th, 2006

Basic diff between data block and normal block is alwayes data block is based on one table and control block or normal block is without database table relationship.Diff bet call_form,new_form,open_for...

Answer Question  Select Best Answer

Sudeep Biswas

• Nov 16th, 2006

In order to understand wht is a clustered index in oracle it is imp. to know what is a cluster. A cluster is a method to store data for more than 1 table in the same block.This can be compared to...

Answer Question  Select Best Answer