-
Tables in database
How to find how many tables in each data base
babuda
- Jul 14th, 2008
what abt this ? 1* select sum(count(*)) from all_tables group by ownerSQL> /SUM(COUNT(*))------------- 39SQL>
babuda
- Jul 14th, 2008
Someone need to confirm whether this is correct! Each owner is treated as schema(?),bang me if I am wrong 1* select count(1),owner from all_tables group by ownerSQL> / COUNT(1) OWNER---...
-
POPULATE_GROUP(function) POPULATE_GROUP_WITH_QUERY(function) SET_GROUP_CHAR_CELL(procedure) SET_GROUP_DATE_CELL(procedure) SET_GROUP_NUMBER_CELL(procedure)
-
How to know max three salary and their sum from table
gtomar
- Jul 25th, 2008
Select sum(sal) from (select distinct sal from emp order by sal desc) where rownum < 4try this
ddkdhar
- Feb 12th, 2007
YOU CAN USE DENSE RANK TO RETRIEVES MAX SALARIES AND EMPLOYEES DETAILSSELECT * FROM ( SELECT A.* ,DENSE_RANK () OVER ( ORDER BY SALARY DESC ) R FROM EMPLOYEES A) WHERE R
-
Hi, my question isIn a screen i have 1 datagrid with the data i have to do 2 things1)Save the data in the grid to the CSV format2)Load the Saved CSV format file into the grid as well as into the Sql Server database table at a time..
gtomar
- Jul 28th, 2008
Hi, you can do it directly also by saving datagrid as sql loader file .and then login to toad and choose csv file directly to load data into table.Thanks,Gunjan
gtomar
- Jul 28th, 2008
Hi,If you are using Toad then you need to follow up the steps given below:-1. Right click on the left top of the grid then Save datagrid in .xls format.2. Open .xls file and again ...
-
Tree Relationship
What is a tree relationship and give an example
narendranaidu.g
- Oct 16th, 2008
It is ahierarchical relation ship. In this structure parentnode (rootnode) and then child nodes, siblings etc
-
How can we improve the data retrival speed?
chenw2000
- Jul 11th, 2008
The first thing I can think of is to do indexingsecond, modify the table structure to reduce the possible comparison like "where col like '%AA%'third, modify the query to retrieve less rows of intermediate data.
-
Log File Information
How can we get information about log files in the database?
UncaAlby
- Nov 3rd, 2008
That is a vendor-specific question.In Sybase, you can get log file information as follows:prompt$ isql1> sp_help {database} 2> goThat will list the devices used by the database, including log de...
-
Write a sql query to reflect changes made in one table if u have two tables Emp1& Emp2.
Mad Hatter
- Nov 6th, 2008
For example, if tables Emp1 and Emp2 both have identical structure, and some changes were applied in them, then MINUS can show the difference. Likeselect *from Emp1MINUSselect * from Emp2 UNIONselect * from Emp2 MINUSselect * from Emp1
ddkdhar
- Feb 10th, 2007
With triiger we can do this......but in sql there is no such thingbut we can do it by viewfor example emp1 is a table and emp2 is view .if you iinsert rows into view tht may maynot reflect in the base table
-
How we can findout the Nth largest No from the table.
prashant.kathole
- Nov 11th, 2008
select distinct sal from emp e where &n=(select count(distinct sal) from emp where e.sal<=sal);
Geetha
- Nov 5th, 2007
Select distinct sal from emp e where &n=(select count(distinct sal) from emp where e.sal>=sal);
-
Wat is the difference between object library and pl/sql library
mohtaak
- Nov 21st, 2008
Object group can be used within same form but Object library can be used through out the data base connectivity in any form.
akhileshkaddi
- Jun 23rd, 2006
when object library is attached to a form, complete object library are compile/used in compilation, assume that object library has some objects like 1, 2,3. But my form don't use 1,2 & 3 all, it u...
-
Number of Updated rows from a Procedure
How to find Number of Updated rows from a procedure which is having a Update Query?
prasads_delight1
- Dec 14th, 2008
Add COUNT keyword to the Update queary by which we can get the number of rows effected by the applied update queary. Else by using the front end code we can call the update queary as string which will run after the loop which will count the rows under the given condition. (by using a perameter)
-
I have student table with fields name,marks1,marks2,marks3 fileds. i want the output as the student details and thier totals and their rank in class, i.e calculated at runtime.please send me the query in sql server or oracle
jmauriciovp
- Dec 18th, 2008
select row_number() over (order by a.marks1+a.marks2+a.marks3 desc) as Ranking, a.sName, a.marks1+a.marks2+a.marks3 total, a.marks1, a.marks2, a.marks3from students aorder by total desc
shubhangig
- Mar 24th, 2006
Try this query for rankingselect s.studentname,count(b.studentname)from studenttable s, studenttable bwhere s.totalmarks<=b.totalmarksgroupby s.studentname;
-
Hi!!!I want to know that..is there any special way to login into oracle SQL*PLUS Editor directly..Rather than every time u have enter user,password,host string...what should i do with login.sql script.. i Put it in /Bin directory..but not working..any Idea..?thanx in Advance!!
-
Database Backup & Restore
Tell the step by step procedure of taking backup of database & restore the same in case of database crash.
chaitra murthy
- Jan 9th, 2009
Well there are several methods used to backup and recover the database. So it depends on scenario which methods has to be followed.Go through the link given below to learn more about Backup & Restore:-http://download.oracle.com/docs/cd/B10501_01/server.920/a96519/toc.htm
-
Hi how to place different column in on columneg:if we have address column in that we have to place addr1,addr2,addr3.
-
Connect MySQL with XML
How to Connect MySQL with XML?
hanumanbaba
- Mar 21st, 2009
use strict; use DBI; my $dbh = DBI->connect ("DBI:mysql:test", "testuser", "testpass", { RaiseError => 1,...
hanumanbaba
- Mar 20th, 2009
adoConn.Open("Driver={MySQL ODBC 5.1 Driver};Server=VBNET4;Port=3306; Database=netmusk; User=admin; Password=pass123;Option=3; Min Pool Size=5; Max Pool Size=60; Connect Timeout=2;");
-
Block Level Recovery
How can we perform block level recovery in database files?
chaitra murthy
- Apr 16th, 2009
In Oracle this is how you do:-Syntax:-SQL>block recover datafile datafilenumber block blocknumber;Ex:-SQL>block recover datafile 2 block 1234;
-
I have my DB2 database on mainframes and I am trying to replicate the same database on Windows server. I have loaded the table definitions to the Windows servers but looking for a way to export data from Mainframe DB2 tables to Windows server tables (Table definitions in both servers are same).I am looking for an easy and efficient way which can take care of nulls, strings, delimiters etc while exporting.Any help!
-
How many types of data models are there?
Three types,they are object-based logic models,record-based logic models,and physical models.
anushandilya123
- May 8th, 2009
Data Models:
Object based
Record based
Object Based:
Object Oriented
Entity Relationship Model
Record Based:
Relational
Network
HierarchicalCulver_lake
- Mar 22nd, 2006
There are no standards in this area. Authors and theorists make it up as they go. The entity-relationship model (ER) has hundreds of derivitives (bachman, chen, ibm, IDEF1x etc.). the most popular of ...
-
1st and 2nd Normalization
How to perform 1st and 2nd normalization? Explain with example.
anushandilya123
- May 8th, 2009
For a relation to be in 1st NF the relation should contain atomic attributes only that is they must be single-valued. If its not so break the composite attribute into its parts and for multivalued...
chaitra murthy
- Feb 16th, 2009
1st Normalization specifies if and only if all the attributes of the relation R are atomic in nature.Ex: First (Empno, Prjno, Prjname, Noof Hours, Empname)Empno: Employee numberPrjno: Project nu...
Oracle Concepts Interview Questions
Ans