-
-
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...
-
How do you create our own schema? which privileges are required?
Ajay Nerumati
- Jan 29th, 2007
Hi All,A Schema in oracle is a logical representation of all the Oracle objects owned by a user.To make my explanation simpe , let me give an example.Let's say you own a bike, a computer, mobile. Now ...
JKreddy
- Jan 24th, 2007
HI all.. To create/update schema one should have SYSADMIN privilages.. ie high level system admin privilages, And these privilages are also necessary for editing the DUAL table in the DB.. thx and regard's jk.m.reddy
-
You have EMP and dept table .how do you get the entire department and corresponding employee details and the department which are not alloted it?what is referential integrity constraint?wat is triggers,stored procedures,stored functions explain with examples
deviji2000
- Oct 15th, 2007
hi, v use joins to get details from both the tables thz kind of joins r called outer joins to get the missed statements.select e.eno, e.ename, e.deptnofrom emp e, d...
Nandakumar
- Jan 28th, 2007
Yes, you can get all the departments along with the employee details, plus the department for which no employee exists. Here you go using outerjoin, select a.employee_id, a.email, a.salary, a.departm...
-
What is the difference between NULL, NOT NULL and NVL with examples?
Prabhat Sahu
- Nov 28th, 2018
Handling NULL values: NULL: It is a value which is Unavailable / Unassigned / Unknown / Inapplicable. A NULL is not the same as "Zero" or a "Blank space". If a row lacks the data for a particular co...
jamesravid
- Jul 18th, 2007
NVL is a built in function provided by oracle which accepts two parameters. NVL function returns the first parameter if the first parameter is not null and it returns the second parameter if the...
-
Using the following Customer, Country and Orders tables: Customer Table c_id c_name c_country_id 1 John 1 Country Table country_id Name 1 US 2 UK Orders Table o_id c_id Qty o_deliver_country_id 1 1 10 1 2 1 20 2
I need the following output in SQLc_id c_name c_country_lives qty o_deliver_country 1 john US 10 US 2 john US 20 UK
Imran_Javed
- May 9th, 2008
SELECT c.c_id, c.c_name , ord.name AS "c_country_lives", ord.qty, ord.name AS "o_deliver_country"FROM customer_c c, (SELECT * &nbs...
vishalb
- Apr 25th, 2008
SELECT X.o_id, X.c_name, X.[Name], X.qty , MT.[name] FROM(SELECT OT.o_id, CT.c_name, CUT.[Name], OT.qty , OT.o_deliver_country_id --CUT.o_deliver_countryFROM Orders OT Join Customer CT on ...
Oracle SQL Interview Questions
Ans