What are the ansi data types supported in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
how to join query for one source type is oracle another source type is sql server ?
How can we delete duplicate rows in a table?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
What is SQL Tuning Advisor in Oracle?
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
How many file formats are supported to export data?
What is key preserved table?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
Can the default values be assigned to actual parameters?
What is data file?