I know that DDLs cant be used in a PLSQL block.
Can you please tell me why it is not allowed??
jithan
Last Activity: Jul 24 '07, 07:05 AM
Joined: May 10 '07
Location:
-
hey arun... there r a lot of ways to tune ur SQL query...
for example
1. u can use indexes,
2. check whether all the system parameters r set properly,
3. u can run ur query in parallel,
4. u can cache some tables so that fetching of data from tht table becomes very
fast
5. reduce the number of joins etc etc
the most important feature in oracle is... there is a package called... -
Hey... seeing ur sample code there is error for sure... u cant have a DDL(create,upda te,truncate etc) statement inside a proc... u need to use dynamic sql(exec immediate)... if there r more errors use SHOW ERR in sqlplus environment to see all of them,....Leave a comment:
-
this is not the case only when u try to create a global temp table inside a proc... u can never have a DDL statement inside a procedure... If u want to perform some DDL task u need to use dynamic sql(exec immediate)...Leave a comment:
-
Hey arun... There r a lot of oracle apps... for example financials, CRM, SCM etc... U need to have some basic knowledge about banking industry if u r planning to study financials... its better u goto oracle's website and see all the apps and their desc... so tht u may get some idea....
http://www.oracle.com/applications/home.htmlLeave a comment:
No activity results to display
Leave a comment: