by: Bliss |
last post by:
Hi All,
I have a table Truck_Journey with the following structure
Tj_Date Date
Tj_Truck_Id Number(5)
Tj_Truck_No Varchar2(10)
Tj_Km Number(9)
....
|
by: Yaroslav K. Kravchishin |
last post by:
Oracle 7.0.1 Server
When I type
SQL> select sysdate from dual;
SYSDATE
---------
01-OCT-03
01-OCT-03
2 rows selected.
|
by: Arthur |
last post by:
Hey Everyone,
Is this an Oracle bug?
Here is my cursor statement:
CURSOR tax_portal_cursor IS
SELECT * FROM web_payment@remotedb WHERE caps_code IN (
SELECT * FROM TABLE(CAST(l_caps_codes...
|
by: George |
last post by:
Hi,
The sql query below returns data in the 'note' field from a table
called ww_rec_1 from the previous month and displays the sum of hours
for each category.
SELECT note,SUM(hours)FROM...
|
by: Joey Martin |
last post by:
I'm sure this has to be a simple fix. I just cannot figure it out.
To resolve the typical apostrope issue, I have the
acarriername = Replace(txtcarriername.text, "'", "''")
My problem is that...
|
by: raj |
last post by:
Hi all,
I'm using this code to import some a .txt files onto a webpage, but I
keep seeing single quotes amd double quotes as question marks.
Here's the code:
<textarea disabled="disabled"...
|
by: Yaroslav K. Kravchishin |
last post by:
Oracle 7.0.1 Server
When I type
SQLselect sysdate from dual;
SYSDATE
---------
01-OCT-03
01-OCT-03
2 rows selected.
|
by: sanQUEST |
last post by:
hi,
If I can create a dual table ,then why can't I select from it?
like :select sysdate from dual ?
thanks
sanQUEST
|
by: karuppiah |
last post by:
Hi All,
i need query,how to select last 3 month ,last 3wek,last 3 days , this last 3 month and 3 week should be friday, using sysdate from dual table, there is no exsting table, pls any one help...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|