use the execute immediate statement to do ddl statement in oracle
Type: Posts; User: expertsharingdotcom; Keyword(s):
use the execute immediate statement to do ddl statement in oracle
if you and the other user belongs to different schemas then two copy of same procedure will be created in two different schemas
select emp_name,sal from (
select emp_name, sal, rank() over (order by sal desc nulls last ) rn from emp) where rn= &var
use DBMS_DATAPUMP the best one to import or export from a pl/sql package
Yes you can call a procedure inside a view by following the scenario.
create a procedure or function which would return a ref cursor as an out parameter.
if the name of the procedure is xyz
...
it actually depends upon whether your table is having any primary key ? if there is any primary key ,then an associated index would be there . if there is an primary key in a table oracle only counts...
Write a insert before trigger for the table in the trigger write the logic in such a way count the rows on a particular date, if rows are greater than 100 raise_application error in the same way do...
select distinct table_name from user_tab_columns where column_name= 'value';
login as sys, system
grant sysdba to user
use the insert with select clause and also use the append hint which is used for direct path insertions.
insert /*+ append */ into <tablename> select <query>;
My friend this works better for you in oracle
select lpad('*',trunc(sal/1000),'*') from emp