For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Hi Experts,
Need a help On schedule tables Columns Description In functional level.I had search for columns description but i did not find anywhere.please Help me on this
S_NQ_JOB
S_NQ_INSTANCE
S_NQ_ERR_MSG
S_NQ_JOB_PARAM
thanks In Advance
Yes Chaitanya thats correct, example:
SQL> create table emp_j as select * from emp where 1=2; Table created. SQL> desc emp_j; Name Null? Type ----------------------------------------- -------- ---------------------------- EMPID NUMBER EMPNAME VARCHAR2(20) AGE NUMBER SALARY NUMBER DEPTID NUMBER MGRID NUMBER SQL> select count(*) from emp; COUNT(*) ---------- 11 SQL> select count(*) from emp_j; COUNT(*) ---------- 0 SQL> insert into emp_j select * from emp; 11 rows created. SQL> select * from emp; EMPID EMPNAME AGE SALARY DEPTID MGRID ---------- -------------------- ---------- ---------- ---------- ---------- 34 TEST 87 3453453 4 1 RAMESH 32 35000 2 VIKAS 23 22000 3 RAJ 35 500000 4 1 4 RAKESH 25 29000 1 5 VIJAY 30 31000 3 6 KASHYAP 28 28000 6 7 TOM 26 25000 5 8 MAHESH 24 22000 4 9 PREM 27 27000 10 SRINIVAS 42 54000 3 11 rows selected.
insert into my_table select * from other_schema.table