Hello,
You can use
insert into table values ('&col1', '&col2');
it will ask you the value of col1 and col2 every time you put / on sqlplus.
Regards,
BMantri
BMantri
Last Activity: Apr 22 '08, 12:01 PM
Joined: Apr 22 '08
Location:
-
Hello,
i have executed by trying a test procedure and i got the output :)
create or replace procedure test(p_name varchar2, p_type out varchar2)
is
cursor c1 is select tabtype from tab where tname = p_name;
begin
open c1;
loop
fetch c1 into p_type;
exit when c1%notfound;
dbms_output.put _line('The type is : ' || p_type);
end loop;
close c1;
...Leave a comment:
-
Hello,
SQL> create table testtesttesttes ttesttesttest(n ame varchar2(10));
Table created.
There is no issue if you put the name of the identifier less than or equal to 30 character.
I am using the oracle version as
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit...Leave a comment:
-
Hello,
U have skipped the VALUES clause in the insert statement.
The correct sysntax is
insert into table_name(col1 , col2) values ( val1, val2);
Thanks,
BMantriLeave a comment:
-
Hello,
You can query as
select tname from tab where tabtype = "TABLE';
Regards,
BMantriLeave a comment:
-
Hello,
USER_ : contain information about objects owned by the account
performing the SQL query (current user)
ALL_ : Rows in the ALL views include rows of the USER views and all information about
objects that are accessible to the current user.
DBA_ : The DBA views encompass information about all database objects, regardless of the
owner. Only users with DBA privileges can access these views....Leave a comment:
-
Hello,
You can use col > to_date(date1, 'dd-mon-yyyy') and col <= to_date(date2,' dd-mon-yyyy') in the WHERE clauseLeave a comment:
No activity results to display
Leave a comment: