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
how to use select statement as formal parameter in
procedure specification?(someone said that using string)
ex:-procedure(a in number,select ename from emp )
i am asking syntax like this?
what are the differences of where and if in SAS?
can u plz provide me oca sql dumps please i need them
how do we code triggers , store procedure , Performance
and indexing in a Java Project? Pls kindly get me the
perfect answer with the code for each....thank you in
advance............pls any body kindly help me soon as
How does propagation differ between Advanced Replication and
Snapshot Replication (read-only)?
why not null is not allowed at table level
How to do performance tunning a database in DB2 V8.2 UDB
How to customize error conditions.
1. Difference between Lookup and join?
2. Difference between funnel and join?
3. What type of load you have used in your project?
4. What type of data warehouse schema you have
fallowed in you project?
5. How many fact tables and dimension tables is their
6. How do you kill the job process using windows
7. Difference between sequence file and dataset?
8. What is delta load and subsequent load?
9. By using which stages you have implemented the SCD
I want a table like,
no name address
So i want columns like addr1,addr2 under address column.
Can one please answer me.
Hi friends can u send the oracle 9i full version download
link?????????????? please reply ?
How to generate OIDS
how to send file attachment from oracle forms
i wrote a pl/sql procedure. it must run every sunday 4.40
How can i schedule it with the help of dbms_jobs (or
another other procedure with out creating bat file,exe file)
Assuming today is Monday, how would you use the DBMS_JOB
package to schedule the execution of a given procedure owned
by SCOTT to start Wednesday at 9AM and to run subsequently
every other day at 2AM.