Hello Friend,
Just go through this link once.
[B]Database Design - DDL & DML[BR]
I hope you will get your answer here.
Have a pleasant time.
Type: Posts; User: sreekumar_nair_it; Keyword(s):
Hello Friend,
Just go through this link once.
[B]Database Design - DDL & DML[BR]
I hope you will get your answer here.
Have a pleasant time.
Dear Suresh,
Thank you for the suggestion you posted.
I tried the third link also but its not working.
It shows file size more than 50 MB online,
But once downloading, it is showing file size...
Dear All,
I need JDK 1.5 setup.
Kindly suggest how to get the same.
I tried this link http: // java . sun . com/javase/downloads/index_jdk5 . jsp
But its giving Error in when i am running the...
Dear gangu_d,
Please provide sample data.
It will be easy for our team members to help you better.
Also send the structure if possible.
Have a pleasant time.
Dear Krishna,
Thank you for your reply.
Yes you are right, we can get the output without
WHERE ROWNUM < (SELECT COUNT(*)+1 FROM TABLE_NAME
Actually i was first selecting all rows using the...
Dear Friend,
Try this,
SELECT * FROM (
SELECT ROWNUM RN,A.* FROM TABLE_NAME A WHERE ROWNUM < (SELECT COUNT(*)+1 FROM TABLE_NAME) )
WHERE RN = (SELECT count(*) FROM TABLE_NAME)
Have...
Dear Krishna2007,
Try creating the Database Link from any of your team members System
If its working there then copy the TNSNAME to your System.
Is this the same Database Link or you are...
Dear susarlasireesha,
Thank you foryour kind reply.
I already the link that you sent. But i need to stop the log generation.
How can i do that. Please help me out.
Have a pleasant time.
Dear All,
In our unit, our stores department used to conduct online auction of scrape materials, every 3 months. Now the problem that i am facing is that the system is generating log in the at the...
Dear Krishna,
Kindly try this query and reply. I have tuned it at my end.
I hope it will not take much execution time.
Have a pleasant time
Dear All,
I need to grant only SELECT privilege on entire Database to a particular user
with a single GRANT statement.
Kindly suggest your opinions regarding the same.
Have a pleasant time.
Dear All,
Kindly send links that contains details regarding Oracle Apps.
Have a pleasant time.
Dear Krishna,
Check your TNSNAME file in C:\ORANT\NET80\ADMIN\TNSNAMES.ORA
If you sre unable to find the ORANT folder in C:\, Search for TNSNAMES file.
Now once you get the file, check...
Dear krishnaindia2007,
Try this
CREATE DATABASE LINK db_link_krk
CONNECT TO cmsjan IDENTIFIED BY "cmsjan"
USING 'orion.ssapl01'
Provide Password in Double Quotes and Connection String in...
Dear krishnaindia2007, you cannot grant privileges dierctly from one database to the other by simply using username and connection string. If you want to give all privileges on a table, to different...
Dear All,
Please refer the DOC file to get details regarding the Interview Questions that are asked to DBA's
Have a pleasant time
:)
Dear All,
Please refer the DOC file to get some details about SQL
Have a pleasant time.
:)
Dear All,
Spell out numbers to words
select decode( sign( &num ), -1, 'Negative ', 0, 'Zero', NULL ) ||
decode( sign( abs(&num) ), +1, to_char( to_date( abs(&num),'J'),'Jsp') )
from...
Dear All,
Test for Leap Years
select year,
decode( mod(year, 4), 0,
decode( mod(year, 400), 0, 'Leap Year',
decode( mod(year, 100), 0, 'Not a Leap Year', 'Leap...
Dear All,
Select the Nth highest value from a table
select level, max('col_name') from my_table
where level = '&n'
connect by prior ('col_name') > 'col_name')
group by level;
Have a...
Dear susarlasireesha,
Try query optimizer HINTS.
You can choose between Default, /*+ CHOOSE */, /*+ RULE */, and /*+ FIRST_ROWS */.
I hope this will help you solving your query.
Have a...
Dear krishnaindia2007,
ROWNUM is a PSEUDO Column and it is used only when you are querying data from table directly i.e. when you are using table name after FROM clause. In your second query you...
Dear RupeshDharne,
If you want to do this using trigger then it will not possible to do the same
because while writing trigger on a table, you cannot use the DML on the same
table. It will give...
Dear Bhutyaa,
Both the case is different
Suppose you have the following two columns:
a b
___
1 2
3 4
Dear Team,
Good Morning
Display Database version, installed options and port string
select banner
from sys.v_$version;
select ' With the '||parameter||' option'