Code:
if(table A Exists) then some insert operation on a; some update operations on a; else create table A; and insert data from table B; end if;
Please help
amitsukte
Last Activity: Mar 12 '12, 05:38 AM
Joined: Jan 18 '12
Location:
-
how To check table exists in Oracle?..
Hello Everyone I m Creating one procedure in that i want to check for existence of table i want to something like this..
Please help -
thank you very much r035198x.. its working fine.. -
how to update multiple columns of a table from another table?.
Hi Everyone how should i update multiple columns of a table from another table...
Suppose I have table A and B and having four columns each table
A(col1,col2,col 3,col4)
B(col1,col2,col 3,col4)
then how should i do something like this
update A set(col2,col4)= (select B.col2,B.col4 from B where B.col1=A.col1 and A.col3=A.col3)
Please help.......... -
How to insert and update in single query?..
I have two tables most_used_tab and most_used.
most_used_tab is master table in which data is stored depending on the data of most_used
tables are like this
SQL> SELECT * FROM MOST_USED_TAB;
TNAME COUNTS USED_DATE RESTART_DATE
----------------------------------------------------
TAB1 10 10-FEB-12 10-FEB-12 12.00.00.000 AM
TAB2 20 10-FEB-12 10-FEB-12 12.00.00.000 AM ... -
Thank you very much rski... i got the solution ...Leave a comment:
-
how to create table in procedure?..
hello every on please tell how should i create table through procedure for following code.
...Code:select CTYP "CMDNAME" , rpad(OBJ,10) "TNAME" , 0 - EXEM "COUNTS" , DAT "USED_DATE" from (select distinct EXEM, CTYP, OBJ, DAT from ( select decode (S.COMMAND_TYPE , 2, 'Insert into ' -
Try this Manju.. This may Help..
SELECT COUNT (*), object_name
FROM v$sql_plan
WHERE operation = 'TABLE ACCESS'
GROUP BY object_name
ORDER BY COUNT (*) DESCLeave a comment:
No activity results to display
Leave a comment: