-
-
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...
-
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;
-
Will the ‘View’ get refreshed immediately when you update a database table. If it doesn’t get refreshed immediately, what method you use to refresh it ?
ddkdhar
- Feb 12th, 2007
there is a concept called dependencies .please check in oracle websiteif tables is altered then view becomes invalid...............but some conditions it is not invalid for example create table table1...
ravitala
- Jul 18th, 2006
NO, the view do not get refreshed when you update a data base table immediately.We have to recompile, to get them refreshed.There are 2 methods to get that refreshed .Method One:Manual approach:-ALTER VIEW COMPILEMethod Two:Automatic approach:-Select * from
-
-
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 ...
-
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 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.
-
What is Retention Policy for backup?
Kandeepan
- Jun 4th, 2008
How many days, we are going to retain the data after taking the backup. For example the data which backed up today that will get expire in 90 days. That means, it is 90 days retention policy for backup
Mohammed Abdul Afroze
- Oct 30th, 2007
You can configure retention policy command to create a persistent and automatic backup retention policy.When a backup retention policy is in effect, RMAN considers backups of datafiles and control fil...
-
DDL and DML
Why do we need a DDL and DML in a database system?
laikka_buddy
- May 5th, 2008
DDL is nothing but Data Definition Language . It is very important for a dadabase that we have to define the data such that we can create tables , alter tables, truncate and drop tables
ugly1
- Jan 25th, 2008
DDL stands for data definition language and DML stands for data manipulation language.DML changes data in an object (eg-insert,update,delete) and when we create,change or remove a database object thats DML (eg-create). so both are important.
-
Copy MYSQL database from one machine to another
How to copy database from one machine to another machine in MYSQL? Explain with an example?
bagya
- Jul 31st, 2009
Select * from information_schema.tables where TABLE_SCHEMA='test 'into outfile'D:backuptest_backup.sql';
soorajVs
- Mar 6th, 2008
Make a dump of the database to be copied : mysqldump -u root -p --databases --opt MyDatabase > MyDatabase.sql
Copy MyDatabase.sql to the second machineImport the database to MysSQL server : mysql -u root -p < MyDatabase.sql -
Database Running Slow
If your database is running slow from last 2 hrs.you can't wait for Statspack report generation. What will be your first step to handle the problem? Where can be the problem?
kven_sat
- Aug 8th, 2008
Remove unnecessary joins,? too much normalization can effect query to perform slow, excess use of cursors, indexes, procedures or temporary tables may effect on query to perform slow. If my answer is wrong please correct me
-
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---...
-
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;");
-
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...
-
JDBC Connection
Explain the steps involved in creating JDBC connection?
mfsi_chinmayb
- Apr 6th, 2012
For more details go through this site URL : http://scornik.blogspot.in/2011/05/sql-query-performance-test-with-jmeter.html
Shravan Mahendra
- Mar 31st, 2010
Here I'm Using Type-4 Driver to connect to Oracle 10g application and there it goesStep-1: JDBC Driver loading which will be as follows Class.forName("o...
-
-
-
Oracle Concepts Interview Questions
Ans