potti
Last Activity: Oct 26 '07, 02:19 PM
Joined: May 25 '07
Location:
-
What is purpose of 'Tnsping'
Can u pl explain the purpose & usage of 'Tnsping' cmd -
How to select only TOP record in a table
Can we give the no. of records to be displayed in a select statement like first 5 ROWS or first 10 ROWS .And any command is there to select only TOP ROW ? -
I have initialized the fields of TOTALS with NULL values.... -
TO copy columns from tab1 to tab2
I tried to transfer data from 2columns in TABLE1 to TABLE2:
INSERT INTO TAB2(col1,col2) SELECT colY,colZ FROM TAB1.
It didn't work.
Pl suggest a way for this. -
Populating a table using trigger
Hi,
I am inserting data in table1.using a trigger I want to populate TABLE2.My code is like this :
TABLE1 :ST_INFO
FIELDS : NAME (varchar),ACCOU NT_TYPE(varchar ),TIME(date)
TABLE2 :TOTALS
FIELDS : CURR_DAY(date), DISCONNECTIONS( number)
I am inserting data in ST_INFO using SQLLOADER.I want to populate TOTALS with the TIME,count of TIME field after insertion.
CREATE OR REPLACE TRIGGER TRI_TOTALS
... -
Thanks phanimohan,this site is of great help for me...Leave a comment:
-
hi debasis, thanks for ur prompt response.when I am using the UTL_FILE package only it is giving error like 'Invalid directory path name' when i try to give the path of that file.what to do?...Leave a comment:
-
file I/O operations
hi I am new to this group.can u pl help me in using file I/O operations,when i try to fetch data from flat file to table it is giving message like"invalid path directory".Is it necessary to have access on that directory?which one is better to fetch data from external file SQLLOADER or fopen() ?pl give syntax for fopen().
No activity results to display
Leave a comment: