Thanks a lot debasis now i am clear about it .:)
Type: Posts; User: kspolavarapu1; Keyword(s):
Thanks a lot debasis now i am clear about it .:)
ya debasis.Upto now we use sql loader on server .on server in command prompt from bin location i issue the command
sqlldr scott/tiger@orecl control='xxx.ctl' ,data='xxx.dat',log='xxx.log'
and...
Hi debasis as sql loader is executed in command prompt how can we issue a command from client pc on to the server command prompt
Can i use sql loader on my pc installed with oracle client to port data into oracle database server.If yes what are all the manual setting i need to make.
I got a materialized view which is based on a table having 100million records.If i added 10 more records to that base table how can i refresh only the newly added 10 records into the Materialized...
I found the ans as: any function called from the sql statement have certain side effects on the database tables and package variables.these side effects are specified using purity levels.and diff...
what is the need for using function purity in PL/SQL .
Thanks a lot james i found the link useful.
and i also found that in execute immediate DML statements need to be commited.Where as in DBMS_SQL they r auto commited .
I know views can be updated when it is based on a single base table.And views cannot be updated when there r more than one Base table.If a view uses a group function in it is it updatable.And what r...
What is the Diff B/w EXECUTE IMMEDIATE AND DBMS_SQL
which one performs better a simple stored procedure or the same procedure in a package.And Why?