-
Whats the difference between PL/SQL and a Cursor?
jmriaz
- Aug 14th, 2007
A Pl/SQl is Procedural language extension for SQl.U can do certain thingslike creating blocks,procedures,functions,triggers etc..A cursor is a private work area(or u can say it a place)...
rakesh.apps
- Aug 8th, 2007
PL/SQL is a procedural language which is used to make set of operations on the database.Actually the code is written in the form of PL/SQL blockAnd Cursor is a mechanism which is used to retrieve the data(rows) from the table.
-
-
-
Oracle8i and Oracle9i.
Difference between oracle8i and oracle9i.
Zeeshan
- Aug 3rd, 2007
SGA: System Global Area. Its a chuck of memory used on oracle processes.
-
-
How do you decide on whether to use a Procedure or a Function for a particular task ?Is it possible to get the last 10 rows of a table? If Yes How?
jamesravid
- Jul 18th, 2007
For ur second question,select * from (select * from (select col1,col2,rownum as rank ...
jamesravid
- Jul 18th, 2007
I would consider the following points,1. Identify how many variable should be returned by your pl/sql code. If it is only one go for functions else go for procedures.2. Fuctions can be used in ur sql queries whereas procedures can't be used.
-
What are the differences between physical and logical data model?
The main important aspect is physical data model is created after logical data model. For designing a logical data model one need not have through knowledge in any specific RDBMS like oracle, Informix and so on. This is because logical data model is created after having through study of the business entities which would be involved in the application. The same can be represented by using E-R diagram...
satyam_Ora
- Jul 10th, 2007
Logical vs Physical Data ModelingLogical Data ModelPhysical Data ModelRepresents business information and defines business rulesRepresents the physical implementation of the model in a database.Entity...
-
What is database domain?
satyam_Ora
- Jul 10th, 2007
Hi,The databse domain are the differenet types of database. Database domain can be Oracle, MS SQL Server, Sybase etc. It's depend on user on which database domain he can work better.Suppose if we select oracle there different domains are: Oracle 9i, Oracle 10G and Oracle 11i etc.
-
-
Can we have both Primary Key and Unique constraint in a Table?
singh.mandeep
- Jun 27th, 2007
Yes the table can have primary key as well as unique constraint in a table.a table can only have a single primary key were as it can have more than one unique key
-
-
-
-
-
How to make migrate the database from Oracle 9i to Oracle 10g ? please list out all possible differences between these two versions.
taraldesai
- Jun 23rd, 2007
For difference refer oracle manual.You want to migrate or upgrade.1.ORACLE_HOME/rdbms/admin/utlu102i.sql2.Stop all cron3.PGA_AGGREGATE_TARGET initialization parameter is set to at least 24 MB.AQ_TM_PR...
-
How to take oracle back up and Recovery procedure? Pls explain briefly and example with coding..
-
How cursor state information be used in oracle9i.
taraldesai
- Jun 23rd, 2007
Used to avoide parsing three mode shared, exclusive and similarcursor_sharing=need to set this parameter on session or system level. this can also affect bind picking
-
Usually if a large amount of data entry/updation/deletion is to be done, the index is dropped and re-created after the data entry/updation/deletion is finished, Why?
taraldesai
- Jun 23rd, 2007
It's really bad habit. you never gonna get anything from this. Reason is you are doing this to avoide fragmentation.. for this you can use LMT. and depends on index also if b*tree there are 95% al...
-
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?
SNirmala
- Jun 10th, 2007
You can definitely load the data in to the warehouse for more than one time. And that is what a warehouse is for. To implement that, we should maintain a time dimension in the warehouse to differentiate the data loaded on various runs. To know more, jus send me a mail...
-
Oracle Basics Interview Questions
Ans