try the below query,
select ename,hiredate,sal,
to_char(next_day(trunc(add_months(hiredate,6),'mm'),'monday'),'DAY,"THE" DDSP "OF" MONTH YYYY') Review_date
FROM emp.
Type: Posts; User: ashalalaxmi2002; Keyword(s):
try the below query,
select ename,hiredate,sal,
to_char(next_day(trunc(add_months(hiredate,6),'mm'),'monday'),'DAY,"THE" DDSP "OF" MONTH YYYY') Review_date
FROM emp.
below pl/sql block can update sal of first five records.
declare
cursor c1 is select rownum,a.* from emp a where rownum<6;
c1row c1%rowtype;
begin
open c1;
loop
fetch c1 into c1row;
exit...
try the below query
select sal from emp where sal=(
select a.sal from(select sal from emp where sal is not null order by sal)a
where rownum=1)
hi
The below query will help for u
select x.* from (select a.employee_id,a.employee_name,b.address, from emp a,address b where a.employee_id=b.employee_id) x
where x.address in(select distinct...
you cannot insert column in the middle of the table.if u add any column to table it will appended to end.
if u want to appear in the middle, create another table by selecting columns from that...
There are 3 ways to insert the data into a table.
desc student
no number(3);
name varchar2(20);
address varchar(100);
1)to insert all column values in a table.
syntax:
...
yes we can use corsor attributes in cursor for loop.
eg:
declare
cursor c1 is select * from emp where deptno=10;
m number(2);
begin
for i in c1
loop
select count(empno),job from emp group by job;
CREATE TABLE table_name2 as select * from table_name1 where 1=0
Background process:
These background processes will exist in oracle instance. Every time an instance is started, a system global area (SGA) is allocated and oracle background processes are...
For query with sql, how do you select all the records from a table named "persons" where the value of the column "firstname" is "peter"? 1 select * from persons where firstname like 'peter' 2 select...
alter table tablename
modify column_name varchar2(30);
in normal PL/SQL block it will allow only DML statements to execute.if we are executing other than DML like DDL(CREATE ,ALTER ,DROP),DCL(GRANT,REVOKE) AND SESSION CONTROL LANGUAGE(CREATE SESSION) it...
if the second person is creating the procedure using CREATE OR REPLACE it will be replaced with 1st procedure. so second person's procedure will take.
its not possible to enter data in child table which is not available in parent table.
it will gives an error like integrity constraint voilated.parent key not found,when ur trying to insert.
HI
u serch in the net u can get required information.
i think cisco is related to networking products.this certification include
CCNA,CCNP..ETC but i dont know exactly.
hello vinay
as per my knowledge i prepared a query.i think this will work for u.
select * from emp
minus
select * from emp where rownum<=(select (count(*)-3) from emp);
view:
view is also a one of the database object.
view contains logical data of a base table.where base table has actual data(physical data).another way we can say view is like a window through...
hello nitin
u know execute immediate method.its a method used in native dynamic sql.native dynamic sql means at the run time we will get the query.here the query which will give at run time will...
How can one see if somebody modified any code.
Also, If scott has created the Procedure p1 which inserts the data into table t1 which is created in scott schema.if the scott gives the execute...
hello prakash,
without commiting, the inserted row is not saved in the database,just it is stored in the memory.
here is the example.
SAVEPOINT S1;
UPDATE STMT..
create STMT.
SAVEPOINT S2;...
delete means it will delete all rows.and space of deleted rows will not be released.
but when truncate the table all the rows will be deleted & space of rows also deleted.
when deleting we can roll...
its a very useful document.
thanqu.
iam intrested but in which tech the training will be.
hi
thanxs a lot