I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...
3 SQL PLSQL 5692I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....
3 SQL PLSQL 5349create or replace procedure show_tab_rec ( P_tab VARCHAR2 )
IS
cmd varchar2(50);
begin
cmd := 'select *
from '|| P_tab;
for int in ( execute immediate cmd )
loop
dbms_output.put_line ( int.ename||' '||int.deptno);
end loop;
end;
when i m compling this procedure i m getting this error
PLS-00103: Encountered the symbol "IMMEDIATE" when expecting
one
of the following:
. ( ) , * @ % & | = - + < / > at in is mod remainder not
range rem => ..
HCL,
1 Oracle General 4425When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............
Oracle Errors 2421Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Oracle General 1030
Question { 6445 }
What is the system function to get the current user's user
id?
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
Question { 7271 }
how to find the second highest salary in a given table????
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
i have a table
eno dno sal
1 10 200
2 10 150
3 10 100
4 20 75
5 20 100
i want to get sal which is less than the avg sal of thri dept.
eno dno sal
2 10 150
3 10 100
4 20 75
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
Question { Keane India Ltd, 8701 }
suppose we have values like 1 5 7 in a colum.Now we want
numbers like(2 3 4 6) that exists between 1 5 7.How can we
do this using sql query??
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
Question { 7889 }
how to Update table Sales_summary with max(sales) data from
table sales_dataTable 1. sales_data table Table 2.
Sales_summary
Region sales Region sales
N 500 N 0
N 800 W 0
N 600
W 899
W 458
W 900
I want the Sales_summary After Update like this
Region Sales
N 800
W 900
Answer
Is This Answer Correct ? | 2 Yes | 0 No |
Question { 16328 }
How do you retrieve the last N records from a table?
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
wirte a query to remove null? following table are
col1 col2 col3
dinesh null null
null suresh null
null null prakesh
i want the output like
col1 col2 col3
dinesh suresh prkaesh
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
Question { 4792 }
how to get count of tables in particular database in Oracle?
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
Question { 3687 }
the user should know to which database he is connected
currently in oracle
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
Question { 4762 }
how to find the first two highest salaries in deptno in emp
table
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
write a pl/sql function if enter a value=0 then output
value=1 and vise verse with out using if and case statements.
Answer
Is This Answer Correct ? | 1 Yes | 0 No |
Question { 7337 }
how to retrieve 1st and last row of table without using
group functions??
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
Question { 13660 }
How to update salary of employees department wise?
Answer
Is This Answer Correct ? | 7 Yes | 0 No |
Question { 5388 }
I have a table emp. There is only one column in the table.
In that , there are only three rows in that column.
The value in the first row is 'A' and the value in the
second row is 'B' and the third row is 'C'. Now, my question
is ,
How will you write a select query to display the output as
B
C
A
Note: order by cannot be used coz it gives us output as CBA.
But the output should be BCA.
Answer
Is This Answer Correct ? | 0 Yes | 0 No |