islandfong
Last Activity: Sep 24 '07, 07:33 AM
Joined: Aug 30 '06
Location:
-
Terminate the scheduled execution job.
I have a list of job scheduled to be executed in sequence with Oracle 10g. Each of these jobs could take quite a long time to run. Eventually user may decide to terminate the execution of the job in the middle. I don't want this termination action to impact the other jobs scheduled. Can I use 1 session for each job executed and terminate the session when user wants to terminate the job? If yes, I will have many sessions for these jobs in the Oracle... -
Change the Sort order of the columns in the table structure.
Hi all,
I have a table t which contains 2 columns C1 and C2. Now I want to add one more column C3. I want C3 to be between C1 and C2. So the expected sequence is C1, C3, C2. Is there any way to achieve this in Oracle? I am using Oracle 10g. -
islandfong replied to Problem in using Connection By in inserting hierarchical data using Oracle 10g.in OracleAnybody got any idea on this? -
islandfong started a topic Problem in using Connection By in inserting hierarchical data using Oracle 10g.in OracleProblem in using Connection By in inserting hierarchical data using Oracle 10g.
Hello there,
I encounter the following problem when executing a procedure using TOAD connecting to Oracle 10g server. The problem is as following.
I have a procedure which is a statement insert a set of values retrieved by running a SELECT .. FROM ... WHERE ... START WITH ... CONNECT BY statement. It's as following:
INSERT INTO TAB_INS
SELECT T.TREE_ID, T.PARENT_ID, T.SDATE, T.SALARY
... -
Hi,
Really thanks for your reply. I also tried in a procedure and it works there. Seems like I am not able to see the proper result from the SQL Editor.Leave a comment:
-
How to insert a Enter Key (a new line) into a string in Oracle 10g?
Hi,
I am trying to insert / append a Enter Key into a string so to achieve the effect as following:
Address:
4 Hollawood Road,
USA 123456
Some ppl recommended to use chr(10) or chr(13), however it did not seem to work after i tried as following statements.
SELECT 'abc' || chr(10) || 'def' AS TestStr FROM DUAL;
or
SELECT 'abc' || chr(13)... -
As such, does it mean that there is not a general principle for using INNER JOIN or Sub-Query, at least there is not a clear cut line to say when is to use INNER JOIN and when is to use Sub-Query? But I do have this impression that the sub-query will surely add some slow down to the performance.Leave a comment:
-
INNER JOIN vs Sub-Query (with where clause)
Hi there,
I am implementing a reporting database which manipulating a huge amount of data. I used a lot of join. Just wondering which one performs better between the two scenarios:
1. INNER JOIN first then filter by the WHERE clause.
2. Sub-query which WHERE clause first then INNER JOIN.
Anybody have any recommendation? -
Best naming convention in Oracle Development
Hello folks,
I am using Oracle 10i to develop a DB. I have quite some long names in my procedures/functions' names. Can somebody share a good naming convention standard for this?
You can send to islandfong@gmai l.com
Thanks. -
How to implement user access control in ASP.NET 2.0
Hi,
I am using ASP.NET 2.0 to implement a user access control system. The idea is that I would allow users (admin) to create new role, new user, assign user to role and the role is given different privilege to access diffferent web pages. For example, the admin can have view/update/create role, however a normal user can only view the role infomation. If I want to implement the view/update/create function in the same web form,... -
Copy data to another schema
I am trying to copy data from one schema to another schema using TOAD connecting to Oracle 10i. Some of the tables can be copied smoothly but two some of them cannot. There is no error message given, TOAD just hangs there and the status bar shows "fetching rows.". The source table and destination table are identical. Anybody knows what's happening? -
How to debug a Store Proc in Oracle using TOAD
I am developing a complicated Store Proc in Oracle 10i using TOAD. What tools can I use to debug the SP? -
By default it's a sync calling.Leave a comment:
-
islandfong started a topic How to create navigation tree both on the header and the left side. (ASP.NET 2.0)in ASP .NETHow to create navigation tree both on the header and the left side. (ASP.NET 2.0)
I am a beginner in ASP.NET. I am trying to use Master page to create the navigation tree. I can create the navigation tree of the header. but how can I created the navigation tree on the left hand side? Anybody has any sample code to share?
Thanks.
No activity results to display
Leave a comment: