hi,
If I can create a dual table ,then why can't I select from it?
like :select sysdate from dual ?
thanks
sanQUEST
sanQUEST
Last Activity: Sep 5 '08, 06:11 AM
Joined: Aug 24 '08
Location:
-
Can I select from a dual table ?
-
What is B-Tree is index ?
hi,
can I have any suggestion on the functioning of B-Tree index ?
thanks
san -
what are the variables used in sql & pl/sql ?
hi,
plz guide me about the variables which are used in sql & pl/sql ?
thanks
san -
hi,
thanks , but can you tell me : if we have to use it in 'alter table statement' or any other way ?
san -
Query to get the output horizontally?
hi,
can anyone plz guide me abt how to get he output like the follow using a query & also the vice-versa?
1.
a
b
c
d
output shall be:
a b c d
2.
abcd
output shall be
a
b
c
d
thanks in advance
san -
sanQUEST started a topic Adding primary constraint on a table if you have duplicated records already .in OracleAdding primary constraint on a table if you have duplicated records already .
hi,
can anybody can tell me how to add pry constraint to a table if it has already duplicated records ? san
-
where to use ref cursor ?
hi,
can anyone plz tell me where to use ref cursor ? I want some scenarios in this regard.I appreciate good comments.Thanks in advance.
san
No activity results to display
Leave a comment: