Dear Friends,
I searching google not get effective answers.Any body help me.
what is local and global index.?
what is wrapping?
what 's use pipeline?
Difference between in and exists?
Expecting your replies..
Hastha23
hastha23
Last Activity: May 25 '07, 10:13 AM
Joined: May 20 '07
Location: india
-
unique index and non unique index
Dear friends,
Any body tell me what is the difference between unique index and non unique index?
I want briefly explantation..
Expecting your replies..
Hastha23 -
dear friend,
which index i choosing?
unique ,non unique is possible to create index in null column?
PLease replies.. -
possible to create index on a column which contains NULL values
Dear friends,
My oracle version is 10 G.
I have a table vactype,this table contains vac id column have null values.
i want to create an index in vac id column is possible create index in null
column?
Any body help me.
Expecting ur replies..
Hastha23. -
hastha23 started a topic possible for function with DML statement to call other function or proceduresin Oraclepossible for function with DML statement to call other function or procedures
Dear Friends,
My oracle Version is 10g.
I calling a function from sql select same time function body contain DML statement,that time is possible call function from sql?
and again one,
same function containing DML statement call other function or procedures is possible call other functions or procedures ?
Expecting Your replies..
Hastha23 -
Dear All,
i wrote one functions this is correct? ..any body give suggestions please.
functions inside commit is ok?
create or replace function arun
return number
is
begin
insert into x values('java',3 22);
commit;
return 1;
end;
/
is possible from call function from select.?Leave a comment:
-
can you commit inside functions
Dear friends,
Is possible commit inside functions?
Regards,
Hastha 23 -
Functions
Dear friends,
which things are correct:
1) function call other function cannot contain DML.
2) function cannot call other subpgm.
3)function contain DML cannot call sql stmt.
Expecting our replies.
Hastha23 -
Function return OUT mode
Hi friends,
Is possible function return values use OUT mode?
Give some coding pls..
Hastha23. -
Dear frozen
I dont know that query,so i ask about you..
Hastha23Leave a comment:
-
Explain Plan and Full Table Scan definition
Hi,
What is explain plan?
what is full table scan?
Anybody ..
Regards,
Hastha23 -
Use functions
Dear Friends,
I have some query in functions related.Any body clear my doubt's?
1)what are the various ways calling procedures and functions?
2)what are the restrictions in procedures and function?
3)can i use function inside DML statements?
4) functions return values use OUT MODE?give some codings..
5) IS possible function use pragma autonomous transcation?whe never occur mutation ..
... -
Table using joins.
Dear friends,
Am a new guy in this forums.This is my first forum and new guy to oracle.
I have two tables :
DEPT:
deptno
10
20
30
40
and
EMP:
empno deptno
1 10
2 10
3 20
4 20
5 30
6 30
7 40
8 40
i expecting the output below:...
No activity results to display
Leave a comment: