hi
you cannot use direct DDL stmts in Procedure instead you have to use dynamic sql stmts
execute immediate' create table a (n number)';
and delete will remove records from the table not the table structure.
so use another
execute immediate ' drop table a' ;
this will work...
Mala232
Last Activity: Mar 27 '08, 02:06 AM
Joined: Jul 27 '07
Location:
-
hi ,
try this
SQL> alter session set NLS_DATE_FORMAT = 'DD-MM-RRRR';
and try to insert the date values by converting it to
insert into table_name values ( to_date( <date column>,' RRRR-MM-DD HH:MI:SS') );...Leave a comment:
-
Hi rohit ,
here is the query .if your table has a column insrt_ts (insert timestamp)
[code=oracle]
select * from <table_name> where insrt_ts = sysdate (for todays inserted records)
select * from <table_name > where insrt_ts = sysdate -1 ( for yesterdays)
[/code]
hope this helps you .
Mala...Leave a comment:
-
hello,
Simple transaction is just a
begin
end;
bye...Leave a comment:
-
Hello,
use IN ,OUT ,INOUT modes while using parameters to a function
regards,
mala...Leave a comment:
-
Hello debasis,
I am able to connect to sql*plus while creating a datablock on form's Layout editor when I compile it says Module built successfully
and when I try to run the form as it Dev suite 10g it is running on web browser so when it trys to run the form on the IE browser there it says TNS: Protocol adapter error .it opens a connection window i tried to give the username and pswd anda lso DB it is not workin. please...Leave a comment:
-
Unable to run a Form
Hello all
can anyone help me with this problem , I have installed Oracle Developer suite 10g but unable to run the form
problem is when I try to run the form th e browser is unable to connect to my DB .
says TNS: protocol adapter error . I tried to give the Servicename also but it didnt work out. Did any one of you ever worked on Oracle Developer suite 10g plz help me .
Thanks,
... -
The syntax is
SQL> Alter table <tablename> rename column <old columnname> to <newcolumnname> ;
good luck
malaLeave a comment:
-
Here is the syntax
SQL> alter table <tablename> rename column <old columnname> to <new columnname>;
eg:
Good LuckCode:alter table test rename column ename to empname;
malaLast edited by debasisdas; Aug 6 '07, 05:32 AM. Reason: spelling error and added code tag,made some changesLeave a comment:
-
Hi,
Use set linesize 100 or more number to fit in the screen
SQL> SET LINESIZE 100;
SQL> type your query hereLeave a comment:
-
facing problem while running a form in Oracle Dev suite 10g
Hi all,
I am facing a problem while trying to run a form in Oracle developer suite 10g when i try to run a form it says
FRM : 10142:HTTP Listeneris not running on my computer at port :8889..please start the listener or check runtime preferences.
I tried to start the services but I still face it. Please any one help me.
Thanks
mala -
Hello debasis,
I am trying to connect from Forms Builder and it says protocol adapter error.It was asking to give username password and database in Forms. I trired to give the values but it still says
ORA-12154 could not resolve the connect identifier specified
.I tried the service name from TNSnames.ora file but it didnt work out.
and in the Network folder i dont have listener.ora file
My Devloper...Leave a comment:
-
Regarding Oracle Developer suite installation
Hi all,
I installed Oracle developer suite 10g version 1.0 and I have Oracle 10.2 version Database. My developer suite is not working it is not able to connect to database.
My question is, Is there any way to connect to Oracle 10.2 DB from Oracle Dev suite 10.1.?
Suggest me the correct answer.
Thank you,
Mala -
Thank you Debasis for your replyLeave a comment:
-
hello,
My question is a table already contains 5 million and need to update 1 million only during this process if performance should to good what situations /conditions you take into considerations....Leave a comment:
-
Update
Hello all
I have a question
there's a table which contains 5 millions of records and I want to update 1 million records. so what should be my primary concerns.
like you did some changes for the performance reason...
Please any boby reply this
Regards
Mala
No activity results to display
Leave a comment: