Could anyone please share how to write开发者_运维知识库 bold text to a .dat file using something similar to the below or otherwise in PL/SQL?
I have a table that stores trees. There is a node_id and parent_id. When I try the following: insert into table1 select * from table2 start开发者_运维百科 with node_id = 1 connect by prior node_id
I am trying to generate an insert statement from a row in a table? if the row is [1 , \"myfirstname\", \"mylastname\"] is there a way of getting a query like:
An example from my Oracle SQL Certified Expert Exam study guide has me puzzled. The SQL statement: INSERT
I got a date like this \'1302104376\' stored with the italian timezone UTC+1. I need to convert it into the format DD:MM:YYYY HH:SS, but with timezione UTC + 0 (GMT). Does exists a function that does
I\'m working on a project my boss gave me. I don\'t have much experience but I have to learn it. It\'s regarding Oracle DB 11g and I\'m using SQLPlus and PL/SQL as the query language.
I want to know total how many queries got executed with its count and execution time for my Java program开发者_如何学Python (I dont have the source code).
I need to check whether any of the column in record set contains data or not. I have to check 10 columns for the data.If data is not there it has to exit oth开发者_运维百科erwise continue to the nex
Below is the code i use to extract data from a table to a flat file. BEGIN DECLARE file_name VARCHAR2(50);
I have kind of a tricky Oracle problem. I am trying to select one set of dat开发者_如何学运维a, we\'ll call items. For each item I want to call another procedure and return an Inventory Item. I have t
加载中,请稍侯......