I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?
2) Consider a Table name A which has below records
Consider another table B which has below records
How many rows will be returned by each of the below queries
a) select * from A inner join B on A.id = b.ID
b) select * from A left join B on A.id = b.ID
c) select * from A right join B on A.id = b.ID
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
i have a question here...
As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly...
and my quetion is...
How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Database crashes. Corruption is found scattered among the
file system neither of your doing nor of Oracles. What
database recovery options are available? Database is in
archive log mode.
what is the difference between LENGTH AND SIZE?
can u plz provide me oca sql dumps please i need them
diff b/w inter process and in process
What is an SQL FORMS ?
A scenario for amount correction & how to use amount
correction functionality in AP invoices
How do use Having,Group by,Group function in SQL?
How can we expand Parameter Form Canvas on Reports 6i?
Please post the scenerois for writing the complex sql
queries , for my practice.Can be any query if you cannot
1.In a table Gender is a column in that male and female are
the two data.In a single statement i have to modify all male
to female and all female to male vice versa.
2.In a single query i need the count of male data,count of
female and total count
What view(s) do you use to associate a user's SQLPLUS
session with his o/s process?
Can you give me some DBCC command options?(Database
consistency check) - DBCC CHECKDB - Ensures that tables in
the db and the indexes are correctly linked.and DBCC
CHECKALLOC - To check that all pages in a db are correctly
allocated. DBCC SQLPERF - It gives report on current usage
of transaction log in percentage. DBCC CHECKFILEGROUP -
Checks all tables file group for any damage.
Table 1: col1 Timestamp
Table 2: col2 Timestamp
Write a query to display a row with table2 col2 value less
than tabl1 col1 value. Maximum timestamp value previous to
table1 col1 value.
Display a result as:
01-mar-2012 11:12:46 01-mar-2012 11:12:10
Could you please provide oca (oracle 10g) dumps for my