-
-
-
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
No, a cursor variable points a row which cannot be stored in a two-dimensional PL/SQL table.
rampratap409
- Dec 12th, 2006
No you can not store the cursor variable into pl/sql tablebut yes the out put or cursor variable can be stored how:set serveroutput ondeclaretype v_table is table of emp%rowtype index by binary_intege...
-
Can anybody provide me some common and normal scenario based questions during interveiw.
rampratap409
- Dec 12th, 2006
what is cursor ?how many type?what is the diffrence ?what is exception?diffrence between function & procedurelike wise you can prepare your own questions.
-
e.g. 3 years 4 months 19 days">
How to display "Experience of employee"?e.g. 3 years 4 months 19 days
jamesravid
- Dec 10th, 2006
Try this query select trunc(sysdate) today, hiredate, to_char(trunc(months_between(sysdate,hiredate)/12)) || ' years ' || to_char(mod(trunc(months_between(sysdate,hiredate)),12)) || ' months ' || to_c...
-
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
-
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.
-
-
-
-
In the real world, where do we use Savepoint command.
dmadhusudhanarao
- Aug 2nd, 2006
good question.remember... you are doing huge work. means assume that you have execute 100 queties. ok . you already finished 50 queries. after executing the 51 query you thaught there is a mistic. wha...
-
Why statistics are different in oracle9i and oracle 10g?
Not sure about this, better we could try again with right samplesize in both the versions. Use DBMS_STATS.AUTO_SAMPLE_SIZE.ExecuteDBMS_STATS.GATHER_SCHEMA_STATS('SCOTT',estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,GRANULARITY=>'ALL',CASCADE=>TRUE);
Jian Zhang
- Oct 22nd, 2006
Deafult Optimizer9i: CHOOSE10g: CBO
skumarpenugonda
- Jul 7th, 2006
Hi,I just started reading 10g. What I came to know that there are many features added and w.r.t. statistics, below are the changes, or new features.1. AWR ( Automatics Work Load repository )...
-
-
-
-
-
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))
-
-
-
Oracle SQL Interview Questions
Ans