| PL/SQL queries. [message #10599] |
Mon, 02 February 2004 19:08  |
Ravi Kadu
Messages: 3
Registered: February 2004
|
Junior Member |
|
|
1. Is there any provision for removing SQL> (SQL prompt) for writing syntax etc.?
2. What about Null value in PL/SQL block?
3. Can we convert date string into character or vice-versa in PL/SQL block?
4. If we want to make PL/SQL block, in which the block should ask Student_name & percentage and returns...
"Mr. (student_name) obtained (percent)% Marks"
In addition, It should return "Unavoidable Circumstances" if we skip (blank) percentage value.
5. Can we convert Character string into Number or vice-versa in PL/SQL block?
6. How to change the user’s password from oracle?
7. Can we delete any user from oracle?
8. In the oracle, is there any possibility to change the table’s column name or size?
9. The result of the oracle block Always ask "Enter value for…" for input. Can we give any other sentence in place of ""Enter value for…"?
i.e.
As per our requirement, it should ask for input " Do you want to square-root of this Number? (Y/N)"
Hoping positive from your end.
Regards,
Ravi
|
|
|
|
| Re: PL/SQL queries. [message #10673 is a reply to message #10599] |
Mon, 09 February 2004 01:51  |
jigar
Messages: 74
Registered: July 2002
|
Member |
|
|
1. Is there any provision for removing SQL> (SQL prompt) for writing syntax etc.?
Ans: SET SQL PROMPT MYSQL>
2. What about Null value in PL/SQL block?
Ans: What you want? I am not clear.
3. Can we convert date string into character or vice-versa in PL/SQL block?
Ans: Use To_Char and To_Date function
4. If we want to make PL/SQL block, in which the block should ask Student_name & percentage and returns...
"Mr. (student_name) obtained (percent)% Marks"
Ans: Write '&StudentName' and &Percentage
In addition, It should return "Unavoidable Circumstances" if we skip (blank) percentage value.
Ans: Yes
5. Can we convert Character string into Number or vice-versa in PL/SQL block?
Ans: Use To_Char and TO_Number functions
6. How to change the user’s password from oracle?
Ans: Alter User <<User Name>> Identified by <<New Password>>
7. Can we delete any user from oracle?
Ans: Yes you can delete using Drop User <<User Name>>
8. In the oracle, is there any possibility to change the table’s column name or size?
Ans: Use Alter Command to change both
9. The result of the oracle block Always ask "Enter value for…" for input. Can we give any other sentence in place of ""Enter value for…"?
i.e.
As per our requirement, it should ask for input " Do you want to square-root of this Number? (Y/N)"
ANS: Write DBMS_OUTPUT.PUT _Line('Do you want to square-root of this Number? (Y/N)');
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
