which sql command we can use to get a print out from
oracle?
Answers were Sorted based on User's Feedback
Answer / anee desai
set autoprint on; will provide the command for printing.
Is This Answer Correct ? | 12 Yes | 0 No |
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help
How to install oracle odbc drivers?
What is a schema in oracle?
What is the best way to do multi-row insert in oracle?
How do we create privileges in oracle?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How many anonymous blocks can be defined?
Explain about your project and its relation to the current job position you are applying to?
How to view the data files in the current database?
What is catalog in Oracle?
Can we create index on views?
19 Answers CTS, Syntel, TCS,