GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Oracle
Go To First  |  Previous Question  |  Next Question 
 Oracle  |  Question 73 of 249    Print  
Hi All I am very new D2K There are lots questions but not the basic questions like Diff in Data block, Normal Block. Diff in Call_forms, New_forms,Open_forms?

  
Total Answers and Comments: 1 Last Update: November 17, 2006     Asked by: Dhiren 
  
 Sponsored Links

 
 Best Rated Answer
—

No best answer available. Please pick the good answer available or submit your answer.
November 17, 2006 06:43:14   
subasini sahu        
RE: Hi All I am very new D2K There are lots questions ...

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_form.

Call_from call one from other and you can't do any opration with base form till you back to main form from other.

in new_form we close the main form and open the new form.

In case of open_form we can open multiple form at same time and do opration at a time.

Thanks

Subasini.


 
Is this answer useful? Yes | No

 Related Questions

No. Only the DDL(Data Definition Language )statements like create,alter,drop,truncate are auto commit.But the DML statements are should be saved by giving the commit statement after execute the query 
Latest Answer : DDL is Data Definition Language. DDL commands work on the table directly or on the table structure. By default it has auto commit.DML is Data Manipulation language that affects the data present in the table. Any addition or modification of data has to ...
Read Answers (4) | Asked by : srinivasan
Latest Answer : here is the example for DBMS_SQL:CREATE OR REPLACE PROCEDURE delete_all_rows(p_tab_name IN VARCHAR2, p_rows_del OUT NUMBER)IScursor_name INTEGER;BEGINcursor_name := DBMS_SQL.OPEN_CURSOR;DBMS_SQL.PARSE(cursor_name, ’DELETE FROM ’||p_tab_name,DBMS_SQL.NATIVE ...
Read Answers (5) | Asked by : Vinoth
I am having WHEN-NEW-ITEM-INSTANCE trigger at Form, Block, Item level what is the sequence of execution? And if I want to change there sequence how I have to change?
Hi,I have scenario where I need to upload data from XML file into a table. XML file is a predifined format. How can I achieve this, Is there any built in package similar to SQL loader to extract required field values and upload them into table.Pls suggestThanks
Read Answers (2) | Asked by : vishnu
Is there a way/tool to automatically export data via forms. Kinda like Dataloader that is used to import data via forms?
Read Answers (1) | Asked by : Jarred Johnson
Suppose if we have load some data from source files to data warehouse n after a few months if we again want to add some more data into same data warehouse, then how can we implement that?
Read Answers (1) | Asked by : ramya
Hi All I am very new D2K There are lots questions but not the basic questions like Diff in Data block, Normal Block. Diff in Call_forms, New_forms,Open_forms?
Read Answers (1) | Asked by : Dhiren
What are the new features of Oracle 10g over Oracle9i?. What are the possible steps to be taken care while migrating data from 9i to 10g ?If possible please list out all the differences between Oracle 9i And 10g.
Read Answers (1) | Asked by : Ishwar Goudar
What is difference between data and informationrelated to ADBMS(advanced database management system) ! plz explain in detail !
View Question | Asked by : viral
I want to use a column as blob datatype incase of long raw datatype.what is the process of data insert into and retrive from this table .
View Question | Asked by : jagannath kar

 Sponsored Links

 
Related Articles

Breaking up XML into Relational Data

Breaking up XML into Relational Data While the preceding example shows how to construct an XML representation over relational data the example in this section illustrates how you can shred XML data back into relational data This reverse operation can be useful if your application works with relation
 

Querying Data with Oracle XQuery

Querying Data with Oracle XQuery Starting with Oracle Database 10g Release 2 you can take advantage of a full featured native XQuery engine integrated with the database With Oracle XQuery you can accomplish various tasks involved in developing PHP Oracle XML applications operating on any kind of dat
 

Using Oracle XML DB Repository

Using Oracle XML DB Repository Another variation on accessing and manipulating XML content stored in Oracle database is provided by Oracle XML DB repository which is an essential component of Oracle XML DB mosgoogle NOTE Oracle XML DB repository also known as XML repository is a hierarchically organ
 

Retrieving XML Data

Retrieving XML DataTo retrieve XML data from an XMLType table you can use a SELECT SQL statement just as you would if you had to query a relational table For example to select the employee with the id set to 100 from the employees XMLType table discussed in the preceding section you might issue the
 

Using XMLType for Handling XML Data in the Database

Using XMLType for Handling XML Data in the Database Being an object type XMLType can not only be used to store XML data in the database but also to operate on that data via its built in methods Regardless of the storage model you choose XMLType provides a set of XML specific methods to operate on XM
 

Using Oracle Database for Storing, Modifying, and Retrieving XML Data

Using Oracle Database for Storing Modifying and Retrieving XML Data With Oracle XML DB you have various XML storage and XML processing options allowing you to achieve the required level of performance and scalability One of the most interesting things about Oracle XML DB is that it allows you to per
 

XML Processing in PHP and Oracle Applications

Processing XML in PHP Oracle Applications As mentioned there are two alternatives when it comes to performing XML processing in your PHP Oracle application You can perform any required XML processing using either PHP s XML extensions or PEAR XML packages or Oracle s XML features mosgoogle In the fol
 

PHP Oracle Web Development

PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax The book is written by Yuli Vaseliev a well known author of different web development and programming books PHP Oracle Web Development Data processing Security Caching XML Web Services and Ajax is a good starting b
 

ODP.NET - Techniques to Improve Performance while Retrieving Data

ODP NET Techniques to Improve Performance while Retrieving Data Performance tuning is a great subject in Oracle Volumes of books would not be enough to cover every aspect of performance tuning in Oracle However in this section we will only discuss the fundamental performance techniques while working
 

ODP.NET - Populating a Dataset with a Single Data Table

ODP NET Populating a Dataset with a Single Data Table A dataset is simply a group of data tables These data tables can be identified with their own unique names within a dataset You can also add relations between data tables available in a dataset mosgoogle The following code gives you the details o
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2010 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape