-
-
-
-
-
-
-
What is the main concept of Concurrent Program in Oracle Apps to register a report?
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
- 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...
-
-
-
-
-
-
Describe the structure of the Shared Pool in SGA.
-
-
Hi,How to switch to content canvas when iam in stack canvas
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
-
What is a temporory table? How can create temp table? What is ths use of it?thank you
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 ...
-
Create Oracle database using MS Access Database
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.
-
What are triggers in database? ">
What are triggers in database?
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
- 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...
-
What is the use of truncate command?
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...
-
Without "distinct" recorset is opened without problems.
Private Sub Command1_Click()
Dim Cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim CadOracle As String
Dim CadSql As String
CadOracle = "DSN=Oracle;UID=RECAUDA;PWD=xxxx;DBQ=orcl"
Cnn.Open CadOracle
CadSql = "select distinct NOMBRE_MUNI_SUJ from paddgc53"
rs.Open CadSql, Cnn, adOpenKeyset, adLockOptimistic, adCmdText
While Not rs.EOF
rs.MoveNext
Wend
Cnn.Close
End Sub
thanks.">Hello, I have problem with this RecordSet. Do not open with "select distinct". Why?Without "distinct" recorset is opened without problems.Private Sub Command1_Click()Dim Cnn As New ADODB.ConnectionDim rs As New ADODB.RecordsetDim CadOracle As StringDim CadSql As StringCadOracle = "DSN=Oracle;UID=RECAUDA;PWD=xxxx;DBQ=orcl"Cnn.Open CadOracleCadSql = "select distinct NOMBRE_MUNI_SUJ from paddgc53"rs.Open CadSql, Cnn, adOpenKeyset, adLockOptimistic, adCmdTextWhile Not rs.EOF rs.MoveNextWendCnn.CloseEnd Subthanks.
Oracle Basics Interview Questions
Ans