-
How you open and close a cursor variable.Why it is required?
OPEN cursor variable FOR SELECT...StatementCLOSE cursor variable In order to associate a cursor variable with a particular SELECT statement OPEN syntax is used. In order to free the resources used for the query CLOSE statement is used.
g_sidhu
- Feb 6th, 2008
• The OPEN-FOR statement associates a cursor variable with a multirow query, executes the query, identifies the result set, and positions the cursor to point to the first row of the result set.&b...
S.Senthil Kumar
- Oct 31st, 2006
Without Open Cursor statement the data which is in the table cannot be load into cursor variable.The Close Cursor statement deallocates the memory occupied by the cursor
-
-
What is OCI. What are its uses?
Oracle Call Interface is a method of accesing database from a 3GL program. Uses--No precompiler is required,PL/SQL blocks are executed like other DML statements. The OCI library provides-functions to parse SQL statemets-bind input variables-bind output variables-execute statements-fetch the results
g_sidhu
- Feb 6th, 2008
The Oracle Call Interface (OCI) is a set of low-level APIs (Application Programming Interface Calls) used to interact with Oracle databases. It allows one to use operations like logon, execute, parse,...
-
What is an UTL_FILE.What are different procedures and functions associated with it?
UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, PUT_LINE, NEW_LINE, PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ISOPEN.
g_sidhu
- Feb 7th, 2008
With the Oracle-supplied UTL_FILE package, you can read from and write to operating system files. It Provides security for directories on the server through the init.ora file. UTL_FILE Procedures and ...
Rakesh
- Mar 20th, 2007
Utl_file is oracle procedure tht enable file access .You can write ,read to file.Also possible is to del or rename a file.It requires the use of a directory object.
-
-
Update statement in SET clause subquery is allowed or not?
Nikhil_4_Oracle
- Mar 8th, 2007
HI ALL,update statement in SET clause subquery is allowed ,Try this ,update emp set sal=(select sal from emp where empno=7900)where deptno=20Bye,Nikhil.
-
What is output of this SQL where current value of sequence is 3?Select seq.curval,seq.Nextval,seq.Nextval from dual ? Give reason?
ddkdhar
- Mar 8th, 2007
nikhil take 14 is the currvalue in the sequence the result for this query isselect s.currval , s. nextval,s.nextval from dualis15,15,15yes :-) ok now about execution of this query.i ...
Nikhil_4_Oracle
- Mar 8th, 2007
HI ddkdhar, U r output wll be... CURRVAL NEXTVAL NEXTVAL ----------- ----------- ...
-
Difference Between Hash Join & Merge Join
Merge Join :Oracle performs a join between two sets of row data using the mergejoin algorithm. The inputs are two separate sets of row data. Output isthe results of the join. Oracle reads rows from both inputs in analternating fashion and merges together matching rows in order togenerate output. The two inputs are sorted on join column.Hash Join :Oracle performs a join between two sets...
mvg_mca
- Mar 24th, 2010
A merge join basically sorts all relevant rows in the first table by the join key, and also sorts the relevant rows in the second table by the join key, and then merges these sorted rows.A hash join (...
Manoj Seemar
- Nov 2nd, 2007
Merge Joins Sort merge joins can be used to join rows from two independent sources. Hash joins generally perform better than sort merge joins. On the other hand, sort merge joins can perform better th...
-
I want to develop a reservation system database(just like at indian railways ticketing counters)using oracle in which i can connect 2 computers by networkingcan u plz suggest which languages in oracle i should useand what applications of those would help me
prasadmeduri
- Feb 14th, 2006
Hi,You can use any type of webapplications for this task.I think ASp/JSP will be of great use and benefit.Keep database(SQLServer or Oracle) and your IIS/Weblogic on one dedicated machine for ser...
-
-
How to delete set of records at a time where all the records having same values , except the Rowid differs?
rampratap409
- Dec 4th, 2006
use this query:delete from emp ewhere rowid ( select max(rowid) from empwhere ename = e.ename );
Anjali
- Aug 23rd, 2006
Abhishek, I think in the group by clause u need to add all the field names, so as to make sure the records are exactly same.Anjali
-
In Oracle10g sqlplus, how do you find the tables that have been dropped?
g_sidhu
- Feb 7th, 2008
When you drop a table, normally the database does not immediately release the space associated with the table. Rather, the database renames the table and places it in a recycle bin, where it can later...
Suresh
- Aug 4th, 2006
You can use this command to retrieve the dropped table, simply by querying,FLASHBACK TABLE TO BEFORE DROP;you can also query this to view the objects that can be undropped,SHOW RECYCLEBIN
-
Having following table named RATING :EmpID,ReviewSeason,CustID1,s1,c11,s1,c21,s2,c32,s2,c22,s3,c43,s3,c5Write a SQL statement, return EmpID who has been REVIEWED more than once.
Harshita
- Apr 18th, 2006
Select empID from RATING group by ReviewSeason having count(empID)>1
-
-
-
-
On index why u need indexing ? where that is stroed and what u mean by schema object?for what purpose we are using view
jaspreet.nagra
- Jul 14th, 2009
Sometime the special index you get automatically with every primary key and unique constraint might not help in certain situations. If this happens then maybe it's time to explicitly create a seco...
SateeshReddy
- Oct 9th, 2006
Hello frnd,why cant we create an index on the index....i think according to the database concepts we can create it. it may called as multilevel indexes...like B trees and B+trees are examples for that...
-
There is a varchar2 column ,How can I insert data which contains ' in it ,eg-Ora'cle ??The value to be inserted may vary with every insertion and we can't specifically tell as to whats the position of single quotes ..
senkumaar
- Oct 12th, 2006
In MS-SQL server we can use likeINSERT INTO () VALUES CONVERT(VARCHAR,))ExampleINSERT INTO SEN_TEST(NAMEE) VALUES(CONVERT(VARCHAR,10))
senthilkumar
- Oct 12th, 2006
-MS SSQL Inserting integer values in to varchar columINSERT INTO (col1) VALUES(CONVERT(VARCHAR,10))
-
ORA-06512: at "SYS.UTL_FILE", line 424
ORA-06512: at line 5
Can anyone solve this.
Thanks in advance
Developer.">When i write the following program, i am getting error like: DECLARE vInHandle UTL_FILE.file_type; vNewLine VARCHAR2(250); BEGIN vInHandle := UTL_FILE.Fopen ('D:', 'new.txt', 'R'); LOOP BEGIN UTL_FILE.get_line(vInHandle, vNewLine); dbms_output.put_line(vNewLine); END; END LOOP; UTL_FILE.fclose(vInHandle); END; Error:-DECLARE*ERROR at line 1:ORA-29280: invalid directory path ORA-06512: at "SYS.UTL_FILE", line 18 ORA-06512: at "SYS.UTL_FILE", line 424 ORA-06512: at line 5 Can anyone solve this.Thanks in advanceDeveloper.
rampratap409
- Dec 4th, 2006
use these steps.1 modify init.ora add a line UTL_FILE_DIR='D:My_DIR'2. login as system as sysdba shutdo...
dev
- Oct 17th, 2006
Hi Maria Antony,Thanks for the reply.I tried by giving UTL_FILE_DIR='D:' in the init.ora.71720061376 file.but still it's having the same error.please let me know the solution.Thanks in advance.Developer.
-
I have two difference database (Not Table) in SQL. and Now I want to connect/Transfer daily basis data from one database table to another database table. Please tell me How to connect and tranfer data using Visual Basic.
Arun James
- Nov 8th, 2006
You can use a single query to do it ...Use the ordinary INSERT INTO Table2 SELECT col1, col2 .. FROM Table1But only consideration should be done is the two different DataBases .. Suppose Say our appl...
Oracle SQL Interview Questions
Ans